What columns should a job application tracker spreadsheet include?

At minimum — company, role, application date, source, resume version submitted, contact name, status, and notes. Useful extras — salary range, why you applied, fit score, follow-up date, and a link to the saved JD.

Is a spreadsheet better than a job tracker app?

For under 30 active applications, a spreadsheet is usually better — free, infinitely customizable, no learning curve. Past 30-50 active applications, a dedicated tool starts paying for itself in saved time and missed follow-ups.

How do I avoid forgetting to update my tracker?

Put one block of "tracker maintenance" on your calendar each week — 20 minutes on Friday is usually enough. Set conditional formatting in the spreadsheet to highlight stale rows. Most tracker decay happens because the update step is friction; reduce the friction and the tracker survives.

Can I share my job tracker with a friend or coach?

Yes — that is one of the main reasons spreadsheets beat most tracker apps. Share read-only with a mentor or coach who can review the funnel and spot patterns. Most tracker apps make this awkward.

How long should I keep applications in my tracker?

At least 90 days after applying. Some employers re-engage candidates from previous searches 3-6 months later. Archive rather than delete after 90 days — a one-row history can save you from accidentally re-applying to the same role.

Free Job Application Tracker Spreadsheet (and Why You'll Outgrow It)

A spreadsheet is the most underrated job-search tool of 2026. It costs nothing, takes fifteen minutes to set up, and works as well as most paid trackers for the typical job search. Here is a copy-and-paste template you can use this week, plus an honest assessment of when to outgrow it.

The template

Open a new Google Sheet (or Excel workbook). Create the columns below in this order. Adjust as your search evolves.

Column	Type	Why it matters
Status	Dropdown	Quick visual filter; the most-checked column in any tracker
Company	Text	Self-explanatory
Role	Text	Self-explanatory
Applied date	Date	Drives every follow-up reminder
Source	Dropdown (LinkedIn / Indeed / Referral / Company site / Other)	Tells you within four weeks which sources actually convert
JD link	Hyperlink	Postings disappear; save the link
Resume version	Text	If you tailor, you will lose track without this column
Cover letter sent	Yes/No	Useful for retrospective on what converts
Contact name	Text	Recruiter, hiring manager, or referrer
Salary range	Text	Optional; useful for the final-stage decisions
Match score	Number (1-10)	Your assessment; or pull from your match tool
Notes	Text	Anything you want to remember — interview prep, gut reaction, things to follow up on
Follow-up by	Date	Auto-populates Applied date + 7 days
Last update	Date	Highlight rows older than 14 days in conditional formatting

Status dropdown values

Use a fixed set so filtering and counting works:

To apply
Applied
Acknowledged
Phone screen
On-site / final
Offer
Rejected
Ghosted (yes, explicitly)
Withdrew

Conditional formatting that actually helps

Two rules carry most of the value.

Highlight stale rows. Conditional format on Last update — older than 14 days, fill yellow. This is the visual cue that tells you which applications to follow up on without scrolling.
Color status. Green for offers, red for rejected/ghosted, yellow for in-process, gray for to-apply. Three seconds and your eye finds the live pipeline.

What to skip

Many spreadsheet templates online include columns that look useful but never get used. Skip these:

Probability of offer. You will not maintain a calibrated estimate, and the column will mislead more than it helps.
Detailed company research before applying. Save the research for after a recruiter reaches out. Adding it before is over-investment.
Hours spent. You will lie to yourself anyway. Track outcomes, not inputs.

A tracker that is too elaborate gets abandoned. The columns above are what you actually need.

The weekly maintenance ritual

A spreadsheet works only if you keep it current. The discipline that holds up is one block of weekly maintenance.

Friday afternoon, 20 minutes.
Sort by Last update, oldest first.
For each row older than 14 days — decide: follow up, archive (move to a separate Archive sheet), or update with what happened.
For each row in the active pipeline — make sure the Status is current.
Total time: 20 minutes for a 30-application active search; 10 minutes for under 15.

Without this ritual, the spreadsheet decays into uncertainty within 6 weeks. With it, the tracker stays useful for the whole search.

What a spreadsheet cannot do

Honest limits. For under 30 active applications, none of these matter much. Past that, they start to.

No automatic data capture. Every row is entered by hand. If you applied to fifteen roles last week and forgot to log five, those five are now invisible to you. Dedicated trackers and Chrome extensions capture this automatically.
No reminders. A row says "Follow-up by 2026-05-22" but no notification fires. You either check the tracker or you forget.
No collaboration. Coaches and mentors can view, but they cannot easily add structured notes. Most tracker apps offer this; spreadsheets do not.
No content capture. The JD link in your tracker works until the posting comes down. The full JD body, the resume you submitted, the cover letter — none of those live in the spreadsheet unless you paste them in.

Each of these failure modes is fine at low volume. At 50+ active applications, they compound and you start missing follow-ups.

When to switch tools

Three signals tell you the spreadsheet has hit its ceiling.

You are missing follow-ups. Specifically — you remembered the contact two weeks late and the conversation died because of the delay. If this happens more than once, the tracker is no longer doing its job.
You are spending more than 30 minutes a week on tracker maintenance. At that volume, automation pays for itself.
You can no longer remember what you said in a cover letter the recruiter is now referencing. If the recruiter calls about an application from three weeks ago and you have to scramble to remember which resume version and which cover letter you sent, the spreadsheet did not capture enough.

When any two of these are true, switch to a tool that captures automatically. The Teal vs Simplify vs JobSwyft comparison walks through the options. The TLDR: if you apply mostly through autofill, a Chrome extension that captures the JD + resume + cover letter for every application (like JobSwyft) gives you the spreadsheet's organization plus full content capture without the manual entry.

Migrating from a spreadsheet to a tracker

If you outgrow the spreadsheet, do not export the old data into the new tool — most trackers do not import cleanly, and the format mismatch is more trouble than it is worth.

Instead:

Archive the spreadsheet (read-only, keep it accessible).
Start fresh in the new tool from your active applications only.
Keep both for 30 days. After that, the new tool is the source of truth and the spreadsheet is reference.

This avoids the trap of half-migrated data that you cannot trust.

A free 5-minute setup

The template above is free to build. If you want a head start:

Open a new Google Sheet.
Add the columns from the table above.
Set the Status column to data validation with the dropdown values.
Add the two conditional formatting rules.
Drop your first 10 active applications in. Start tracking.

The whole setup is under five minutes. The discipline is in the weekly maintenance, not the spreadsheet structure.

The short version

A simple Google Sheet with 14 columns is the right tracker for searches under 30 active applications.
The right columns are status, company, role, dates, source, resume version, contact, notes, and follow-up dates. Skip the columns nobody maintains (probability, hours, fantasy research).
20 minutes of weekly maintenance keeps the spreadsheet alive. Without that, it decays in a month.
Switch to a dedicated tool — preferably one that captures applications automatically — when you start missing follow-ups or losing track of which resume version went where.
Migrate by archiving the spreadsheet and starting fresh in the new tool, not by importing.

Build it this week. Maintain it weekly. Upgrade when the math says you have outgrown it. The tracker is not the work; the applications are. Pick the simplest tracker that keeps the tracking out of your way.