Job Application Tracker Spreadsheet: The Columns That Actually Matter
Key takeaways
- A tracker spreadsheet is worth keeping only if it is still accurate in week six, which is a data-entry problem rather than a template problem.
- Eight columns cover almost every real decision you make during a search. Everything beyond that tends to get abandoned first.
- The link column is the one people leave out and regret, because a job posting can disappear before you hear back.
- If the rows are written for you when you click Apply, the spreadsheet stays honest without discipline.
Most people start a job search with a spreadsheet and abandon it somewhere around application thirty. Not because the spreadsheet was wrong, but because filling it in is a small tax charged at the exact moment you least want to pay it: you have just finished a twenty-minute application, you are tired of your own work history, and the last thing you want is to retype the company name into a second window. So you skip one. Then five. A month later the sheet says twenty-two applications and your inbox says sixty, and you have no idea which is real.
So the useful question is not "what is the best job application tracker spreadsheet template." Nearly any layout works on day one. The question is which columns still earn their keep in week six, and how the rows get in there at all.
What the spreadsheet is actually for
A tracker exists to answer four questions you will genuinely have, usually at an awkward moment:
- Did I already apply here? Asked when the same role shows up on a job board under a slightly different title, two weeks later.
- What did I apply for, exactly? Asked when a recruiter calls about a posting you cannot remember, for a company you applied to four times.
- Who has gone quiet? Asked on a Sunday night when you are deciding who to follow up with.
- Is any of this working? Asked when you need to know whether the problem is your CV, your targeting, or simply volume.
Every column that helps answer one of those stays. Every column that does not is decoration you will stop maintaining, and a half-maintained sheet is worse than none, because you will trust it.
The columns that earn their place
| Column | Why it is there | What goes in it |
|---|---|---|
| Company | The thing you actually search by later | The legal or brand name, spelled one consistent way |
| Job title | Distinguishes four applications to the same employer | The title exactly as posted, not your paraphrase |
| Link | Postings get taken down, often before you hear back | The posting URL |
| Location | Drives the remote, hybrid and visa conversation later | City, or remote |
| Salary | Anchors the number when a recruiter asks first | Whatever the posting stated, blank if it stated nothing |
| Date applied | Turns "they have gone quiet" into a real date | The day you submitted, not the day you found it |
| Status | The only column you will filter on | A short fixed list, see below |
| Notes | The referral, the recruiter's name, the thing you promised to send | One line, not a diary |
Salary deserves a note. People leave it out because most postings omit it, and then a recruiter opens with "what are you looking for" and they are negotiating from memory. Recording whatever the posting did say, even when that is a wide band, gives you something concrete to point at.
Set it up in four steps
1. Decide where it lives before you design it
A spreadsheet in your own Google Drive beats a tracker inside a job board, for a boring reason: you can still read it in two years, export it, and share one filtered view with someone helping you. If your record of the search lives inside a product's account, it lives and dies with that account.
2. Fix your status values on day one
Free-text status is where trackers go to die, because "waiting" and "no reply yet" and "ghosted?" all mean the same thing and none of them filter. Pick a short list and never add to it mid-search. Something like: Bookmarked, Applied, Screening, Interview, Offer, Rejected, Withdrawn. Seven values is plenty, and every one of them maps to a decision you would make differently.
3. Add one derived column, not six
Days since applied, computed from the date column, is the single most useful thing a spreadsheet can do for you that a notebook cannot. Sort by it and your follow-up list writes itself. Resist the urge to add scoring, weighted fit percentages or a colour-coded funnel chart in week one. Those are projects that feel like job searching without being job searching.
4. Decide how rows get created
This is the step people skip, and it is the one that determines whether the sheet survives. Copy-pasting four fields per application is about a minute of work. At two hundred applications that is three hours of retyping, spread across exactly the moments when your patience is lowest.
Manual, template, or automatic
| Approach | What it costs per application | Where it breaks |
|---|---|---|
| Plain spreadsheet, typed by hand | About a minute of copy-pasting | Volume. The sheet quietly drifts out of date and you stop trusting it. |
| Downloaded template with formulas | The same minute, plus setup | Same place. Prettier formulas do not fill themselves in. |
| Job board's built-in tracker | Nothing, on that one board | Everything you applied to elsewhere, which is most of it. |
| Browser extension writing to your own sheet | Nothing after setup | Sites it does not recognise, where a generic fallback still logs the basics. |
Common mistakes
- No link column. The posting gets pulled, the recruiter asks which role, and you are reconstructing it from a job title you half remember. Store the URL with the row.
- Company names spelled three ways. "Acme", "Acme Inc." and "ACME Corp" are three different rows to a filter and one employer to you. Pick the form the posting used and stick to it.
- Logging the day you found it, not the day you applied. Every follow-up calculation you make afterwards is wrong by however long it sat in your tabs.
- A notes column that becomes a journal. If the note is longer than the row is wide, it belongs somewhere else. Notes are for the referral name and the promise you made, not the story.
- One sheet per month, or per job type. Splitting the record destroys the only question the sheet is uniquely good at: have I already applied here. Filter a single sheet instead.
- Backfilling from memory on Sunday. The row you write four days late is missing the salary, the link and the exact title, which were the parts worth keeping.
The part that decides whether it survives
A tracker template is not really a design problem. Every layout in this article can be built in ten minutes, and the eight columns above will serve almost anyone. What separates the sheet you still trust in month three from the one you abandoned is whether a row appears without you deciding to create it. Everything else is formatting.
Where this site comes in. Job Application Tracker for Google Sheets is a browser extension that does the admin described above: it writes every application you submit into a spreadsheet in your own Google Drive, shows an Applied or Not Applied badge on postings you have seen before, and fills repeat fields on supported application forms from answers you saved yourself, with no AI generating anything. It works on Chrome, Firefox and Edge.
Frequently asked questions
What should a job application tracker spreadsheet include?
Company, job title, link to the posting, location, salary as posted, date applied, status, and a one-line notes field. That covers the four questions a tracker actually gets used for: whether you already applied, what exactly you applied for, who has gone quiet, and whether the search is working. Anything beyond those columns tends to be the first thing you stop filling in.
Is a Google Sheets job application tracker better than Excel or Notion?
For most people, yes, for one practical reason: it is reachable from any browser and easy to share a filtered view of with someone helping you, without emailing versions around. The format matters much less than whether the rows stay current. A shared Google Sheet you keep updated beats a more powerful tool you abandon in week three.
How do I stop forgetting to update my tracker?
Remove the step where you have to remember. The failure is not laziness, it is that data entry is charged at the exact moment you are most tired of the application you just finished. Either log the row before you close the tab, as a fixed habit, or use something that writes the row when you submit, so the record does not depend on discipline at all.
How many applications should a tracker be able to handle?
More than you expect. A focused search can run to a few dozen, but a broad one in a slow market often passes two hundred, and that is precisely where hand-typed trackers fall apart. Design for the volume you might end up at rather than the volume you are at in week one.