Why track at all
Past about ten applications, memory stops being reliable. A recruiter calls about a role you applied to three weeks ago, and you can't remember which version of your resume you sent or what salary you wrote. A tracker answers those questions in seconds, tells you when to follow up, and shows you where your search is working and where it isn't.
What to track
Keep it to the columns you'll actually fill in:
- Company and role, with a link to the posting (postings disappear, so save a copy of the description too).
- Date applied and where: the company site, a referral, a job board.
- Status: saved, applied, interviewing, offer, rejected, withdrawn.
- Which resume and cover letter version you sent.
- Salary you entered on the form.
- Contacts: recruiter and hiring manager names and emails.
- Next step and its date: follow up, prepare for interview, send thank-you.
When a spreadsheet is enough
A spreadsheet is free, private, works offline, and bends to whatever you want to track. For a focused search of a few applications a week, it's often all you need. Sort by next-step date each morning and you have your to-do list.
Its weakness is that it only knows what you type into it. Every application, reply and status change is a manual entry, and the moment you stop updating it, it stops being useful.
Spreadsheet vs app at a glance
| Spreadsheet | Tracking app |
|---|---|
| Free and fully in your control | Often free to start; paid plans for more |
| Every entry typed by hand | Can add jobs and update status for you |
| Reminders only if you set them up | Follow-up reminders built in |
| Any columns you like | Structure chosen for you |
| Works best under about 30 applications | Scales to a high-volume search |
When an app is worth it
An app earns its place when the manual entry becomes the bottleneck: dozens of applications, replies arriving in your inbox, interviews to schedule. The useful ones save a job from its posting in one click, remind you to follow up, and, in the best case, update themselves when an application is sent or a reply comes in.
Whatever you choose, check where your data lives and whether you can export it. A search can run for months, and your records should outlast any one tool.
What a good entry looks like
An entry is only useful if it answers the questions you'll have later. A good one reads something like: Northwind, Product Analyst, applied 3 March through the company site, resume version "analyst-fintech", entered £50,000 for salary, recruiter Sam Lee, next step: follow up on 10 March. A weak one reads: Northwind, analyst, applied.
The difference shows up when the recruiter calls. With the good entry, you open the right resume, remember what you said about salary, and know whether you've already followed up. With the weak one, you're guessing.
Reading your numbers
After a few weeks, a tracker tells you where the search is stuck. Count how many applications turned into a first reply, how many replies turned into interviews, and how many interviews turned into offers. There's no universal benchmark, but the pattern is informative on its own.
Few replies from many applications usually means the resume or the targeting needs work: tailor more, or aim at roles closer to your experience. Replies but few interviews points at the first call, often salary or fit. Interviews but no offers points at interview preparation. Fix the stage that's losing the most, not all of them at once.
A weekly routine
- Monday: add new roles you want to apply to, with links.
- Daily, five minutes: update statuses from your inbox and do whatever is due.
- Friday: follow up on anything a week old with no reply, and look at the numbers. Lots of applications and no interviews points at the resume; interviews but no offers points at interview preparation.
Keep it private and portable
A job search tracker holds salary figures, contact details for recruiters and notes about employers, so treat it like any other personal record. A spreadsheet in your own cloud drive is private by default; if you use an app, look for a clear statement of what it stores, who can see it, and how to delete it.
Portability matters too. Being able to export to CSV means you can move tools mid-search, or keep your records for the next search, without starting again.
Start simple
The best tracker is the one you'll keep up to date. Start with a spreadsheet template; if you find yourself spending more time updating it than applying, that's the sign to move to something that does the updating for you.
Questions
What's the best way to track job applications?
Whatever you'll keep up to date. A spreadsheet works well for a focused search; an app helps once you're applying widely and replies are hard to keep up with.
What columns should a job search spreadsheet have?
Company, role, link, date applied, source, status, resume version sent, salary entered, contacts, and the next step with its date.
Should I track rejections?
Yes. They show where your search is losing momentum, whether at the resume stage or after interviews, and stop you re-applying by mistake.
Is there a free job application tracker?
Yes. A spreadsheet template costs nothing and opens in Excel, Google Sheets or Numbers.