Free Job Application Tracker Template

What to track in a job application tracker

A good job application tracker template is short enough to keep up to date and complete enough to prepare you for the next call. These are the columns in our template — and why each one earns its place:

• Company and Role — the pair you will be asked about when a recruiter calls out of the blue.
• Job link — postings disappear once a role closes. Save a copy of the description in Notes if it matters.
• Date applied — tells you when to follow up and when to stop waiting.
• Status — Saved, Applied, Interview, Offer or Rejected. Five stages are enough to see where things stall.
• Next step — the most useful column: “Follow up on Oct 15”, “Send portfolio”, “Prep case study”. If it is empty, the application is waiting on someone else.
• Notes — contacts, referral, salary range, questions they asked. Gold before a second interview.

How to use the job tracker template in Google Sheets

Google Sheets is the easiest home for a job application tracker spreadsheet: free, shareable with a mentor, and available on your phone.

1. Download the CSV template.
2. Open a blank spreadsheet in Google Sheets and choose File → Import → Upload, then select the file and import it (replace the current sheet).
3. Delete the three example rows.
4. Select the Status column and add a dropdown (Insert → Dropdown, or Data → Data validation) with Saved, Applied, Interview, Offer and Rejected — give each its own color.
5. Freeze the header row (View → Freeze → 1 row) and add a filter (Data → Create a filter) to sort by date or status.
6. Once it looks right, use File → Make a copy to keep a clean template for your next job search.

Job application tracker in Excel

Prefer Excel? The same file works as an Excel job application tracker:

1. Open the CSV in Excel, then File → Save As → Excel Workbook (.xlsx) — CSV files can’t keep colors or dropdowns.
2. Click inside the data and choose Insert → Table for filters and banded rows.
3. Select the Status column, then Data → Data Validation → List with the source Saved,Applied,Interview,Offer,Rejected.
4. Add Conditional Formatting → Text that Contains rules so offers turn green and rejections grey.

Notion job application tracker template

Notion turns the template into a board you can drag cards across. Use Notion’s Import option, choose CSV and select the template file. Notion creates a database: change Status to a Status or Select property, Date applied to a Date and Job link to a URL. Then add a Board view grouped by Status for a kanban-style Notion job tracker. To add more rows later from a spreadsheet, use “Merge with CSV” from the database menu.

Statuses that keep your job search honest

Statuses only help if they mean the same thing every time. A simple set of rules:

• Saved — you plan to apply. Give it a deadline in Next step, or delete it.
• Applied — submitted. Add a follow-up date, typically one to two weeks out.
• Interview — any conversation beyond an automated reply, from a recruiter screen to a final round.
• Offer — a written or verbal offer. Note the numbers; you will need them to negotiate.
• Rejected — a no, or silence long after your follow-up. Note why if you know; patterns are useful.

A 15-minute weekly review

Once a week, filter by Applied and send the follow-ups that are due. Move stale applications to Rejected so your pipeline shows reality. Then look at your interview rate — the share of sent applications that reached an interview. If plenty of applications are going out and few turn into interviews, the fix is usually targeting or your resume rather than more volume: run your resume through the ATS resume checker against the jobs you want most.

When a spreadsheet stops being enough

Spreadsheets break down when you apply to many jobs a week: every row is copied by hand and the sheet is only as current as your last update. JobsAICopilot’s AI Job Tracker removes that step — jobs found by automated job search appear as Saved and applications sent by auto apply appear as Applied, with the full job description attached.