Tracking your search
Why your job search spreadsheet falls apart, and what to track instead
A spreadsheet works for the first ten applications. After that, statuses drift, documents go missing and history disappears. Here is what a tracker needs to hold to still be useful in week eight.
The spreadsheet works, until it doesn't
Almost everyone starts with a spreadsheet: company, role, date applied, status, link. For the first couple of weeks it works. Then applications pile up, updates arrive on your phone between meetings, and the sheet slowly stops matching reality.
The problem is not discipline. A spreadsheet only holds what you remember to type into it, and a job search produces information faster than that.
Where it breaks
- Statuses drift. A row says Applied for a role that rejected you a month ago, or that has already interviewed you twice. Once a few rows are wrong, you stop trusting any of them.
- The posting disappears. The link goes to a page that has been taken down, right when a recruiter calls and you want to reread what the role asked for.
- You cannot tell which resume you sent. A file called resume_final_v3.pdf does not say which company received it.
- There is no history. One status cell cannot tell you when you applied, when you heard back, or how long a stage has been sitting.
What a tracker actually needs to hold
Useful tracking comes down to a few things for each application:
- The full job description, saved when you apply.
- The exact resume and cover letter you submitted.
- The current status, with a dated history of how it got there.
- Notes and recruiter contacts.
- A follow-up date.
Everything beyond that is optional. Whatever you use, if it holds those five things reliably, it will still be useful in week eight.
The follow-up date is the most useful column
Many applications end in silence rather than a clear rejection. A follow-up date turns that silence into a decision: when the date comes, you either send a short note or mark the application closed and move on. Without it, stalled applications sit in your pipeline looking alive.
Set the date when you apply, usually one to two weeks out, and let the date prompt the next step rather than your memory.
Keep history, not just status
Status tells you where an application is. History tells you what is working. With a date on each change, you can see how long companies take to respond, which kinds of roles turn into interviews, and whether tailoring more carefully changed your response rate.
That is the information that should shape next week's applications, and a single status column throws it away.
Spreadsheet or dedicated tool?
If you are applying to a handful of roles, a spreadsheet with the columns above is fine. Add a column for the resume version, and paste the posting text into a notes column instead of keeping only the link.
Once you have more than a couple of dozen active applications, or you tailor documents for each one, a tool that keeps the posting, the documents and the history together saves more time than it takes to set up.
Quick answers
What should a job application tracker include?
At minimum: the full job description, the exact resume and cover letter you sent, the current status with a dated history, notes and recruiter contacts, and a follow-up date. Those are what you will need when a recruiter gets back to you weeks later.
Is a spreadsheet good enough to track job applications?
For a small search, yes, as long as you save the posting text and the resume version for each row. It gets harder to keep accurate as applications and document versions pile up, which is when a dedicated tracker starts to pay off.
When should I follow up on a job application?
One to two weeks after applying is a common point to follow up if you have not heard anything, unless the posting gives its own timeline. Setting a follow-up date when you apply means you do not have to remember.
What statuses should I use to track applications?
Keep them few and factual: saved, applied, interviewing, offer, rejected, and closed for applications that went quiet. Each status should describe something that happened, not how you feel about the role.
