After the tenth application, most people lose track. Which version of the resume went where? Did that recruiter ever reply? When should you follow up? A job search tracker answers those questions in seconds and turns a stressful process into a manageable routine.
You do not need special software. A spreadsheet in Excel or Google Sheets does the job, and building it yourself is good practice for the organizational skills many entry-level roles ask for.
What a good tracker does
A useful tracker should help you:
- See every application and its current status at a glance.
- Know exactly which follow-ups are due this week.
- Remember which resume and cover letter version you sent.
- Spot patterns, such as which sources lead to interviews.
If your tracker does those four things, it is good enough. Resist the urge to build a complex dashboard before you have applied anywhere.
The columns to include
Create one row per application with these columns:
| Column | Example | Why it matters |
|---|---|---|
| Date applied | 2026-10-14 | Calculates follow-up timing |
| Company | Northwind Logistics (fictional) | Basic reference |
| Job title | Operations Assistant | Titles vary; keep the exact one |
| Source | Company career page | Shows which channels work |
| Link to posting | URL | Postings disappear; save a PDF too |
| Contact | Name, email or LinkedIn | For follow-ups and thank-you notes |
| Resume version | Ops-v3 | Know what they saw |
| Status | Applied | Drives your weekly review |
| Next action | Follow up | Keeps momentum |
| Next action date | 2026-10-21 | Sort by this every Monday |
| Notes | Mentioned weekend shifts | Interview prep material |
Tip: postings are often taken down once the role is filled. Save each one as a PDF in a folder named after the company so you can review the requirements before an interview.
Use a fixed list of status values
Free-text statuses quickly become messy (“applied??”, “waiting”, “heard back maybe”). Use a dropdown with a short, fixed list:
- Saved – found it, not yet applied
- Applied
- Followed up
- Interview scheduled
- Interviewed
- Offer
- Rejected
- Withdrawn
- No response (closed) – after about 30 days with no reply
In Google Sheets, select the Status column and use Data → Data validation → Dropdown. In Excel, use Data → Data Validation → List. A fixed list lets you count and filter reliably, which is the same discipline our guide to cleaning a messy contact list applies to workplace data.
Add simple automation
Two small formulas make the tracker much more useful:
- Follow-up date: in the Next action date column, use your application date plus seven days, for example
=A2+7, then adjust manually when something changes. - Overdue flag: apply conditional formatting that highlights a row when the next action date is today or earlier and the status is still “Applied” or “Followed up”.
Then add a small summary at the top or on a second sheet that counts applications by status with COUNTIF. If you want to go further, a pivot table can summarize applications by source and status; our pivot table walkthrough teaches the same technique with a practice dataset.
Your weekly review routine
Once a week, ideally Monday morning, spend 20 minutes on this checklist:
- Sort by Next action date and send every follow-up that is due. Our follow-up templates make this quick.
- Move anything older than 30 days with no response to “No response (closed)”.
- Count how many applications you sent last week and how many replies you received.
- Look at the Source column for the applications that led to interviews.
- Choose next week’s targets based on what you learned.
Reading the numbers
After three or four weeks you will have enough rows to notice patterns:
| What you see | What it probably means | What to try |
|---|---|---|
| Many applications, no replies | Resume or targeting problem | Review our no-response checklist |
| Replies but no interviews after screening calls | Phone screen answers need work | Practice with our phone screen guide |
| Interviews but no offers | Interview stories or questions need work | Prepare with the STAR method |
| One source produces most interviews | That channel suits your profile | Shift more time to it |
These are not scientific results, but they are far better than guessing.
Keep it private and tidy
Your tracker will contain names and contact details of real people. Store it in your personal account rather than a shared folder, avoid copying it into public places, and delete contact details you no longer need once your search is over.
Set up your tracker today
Create the sheet today with the columns above and add the jobs you have already applied to, even approximately. Then set a recurring calendar reminder for your weekly review. If you have not yet chosen a target role, start with our first job plan, which uses this tracker in its weekly routine.