Job Tracker Spreadsheet: Free Template + Columns That Matter (2026)

You're at application 17 and you've already lost track of which ones you tailored a cover letter for. The 2024 recruiting-metrics analysis of 10M+ applications put the applicant-to-interview ratio at 3%, down from 8.4% in 2023 (HiringThing 2026 stats). In plain numbers, that's about 42 applications to land one interview, and 32 to 200+ before an offer. Without a tracker you double-apply, miss follow-ups, and forget which version of your resume went where.

A spreadsheet is the bare minimum. Below is one you can copy in 30 seconds, plus an honest take on which columns earn their keep and which are there to make the template look thorough.

Copy This Template Right Now

Eight columns. That is the entire system.

If your spreadsheet has more than ten columns, you're tracking for the wrong reasons. Most templates online ship with 14 to 17 because more columns look thorough. In practice, columns 9 through 17 get filled in for the first three rows and go blank for the next forty.

What to Track and What to Skip

Keep these, in order of how much they pay you back:

• Company and Role: copy the exact role title from the posting, not your shorthand. "Senior Product Manager, Growth" isn't "PM." That precision pays off when a recruiter from a different company pings you four months later about a similar role.
• Source: where you found the posting AND where you actually applied. LinkedIn-then-company-site is a different source from LinkedIn Easy Apply. After 30 applications you'll see which sources convert and which are landfill.
• Date Applied: sorts the sheet and drives the follow-up math.
• Resume Version: which file you sent. Without this you can't run a postmortem on what worked.
• Status: six values, no more (Applied, Screening, Interview, Offer, Rejected, Ghosted).
• Follow-Up Date: when you'll nudge them. Auto-formula in Google Sheets: =D2+7.
• Notes: hiring manager name, recruiter name, any line from the JD you want to surface in the interview. The real value lives here.

Skip these unless you have a specific reason:

• "Date Found": you'll just type today, every time. Dead column.
• "Deadline": 95% of postings don't have a hard one.
• "Salary Range" before you've asked: don't guess, you'll anchor yourself wrong.
• "Rejection Reason": you won't get one. 48% of applicants were ghosted by employers in 2025, up from 38% in 2024 (iHire annual report). The column stays empty.
• Color-coding by status when you already have a status column. You're double-counting your work.

Job Application Spreadsheet vs Job Search Tracker Template

The phrasing varies; the structure shouldn't. A "job application spreadsheet" usually lives in a single tab with each application as a row. A "job search tracker template" sometimes splits into multiple tabs (Researching, Applied, Interviewing). That looks organized and is mostly procrastination dressed up as project management.

One tab. One row per application. Sort by date or by status. The moment you're maintaining three tabs you've started a project-management exercise instead of a job search.

If a second tab earns its keep, make it for contacts: recruiters and hiring managers you've talked to, where you spoke, what they said. That's the tab that pays you back twelve months later when the same recruiter pings you about a different role.

Job Search Tracker Template: Set It Up in 5 Minutes

No template marketplace needed. Open a blank Google Sheet.

1. Row 1, headers. Type the 8 columns from the table above. Freeze row 1 (menu: View > Freeze > 1 row).
2. Column F (Status), data validation dropdown. Highlight column F, then Data > Data validation > List of items: Applied, Screening, Interview, Offer, Rejected, Ghosted. Now you can't typo your way into untrackable data.
3. Column G (Follow-Up), formula. In G2 type =D2+7 and drag down. Follow-ups auto-populate as you log applications.
4. Conditional formatting (optional). Rejected goes light gray. Offer goes green. Stop there. The sheet should be readable, not festive.
5. Back it up weekly. File > Make a copy. Spreadsheet corruption is rare but it happens, and losing 80 rows of notes is the kind of pain you only feel once.

Five minutes, done. Anyone who tells you their tracker took an hour to configure is selling you a tracker.

When a Spreadsheet Starts Costing You Jobs

The spreadsheet works until it doesn't, and the break points are predictable.

First one shows up around application 30. Adding rows starts feeling like overhead, so new applications start happening in your inbox and your head instead of in the sheet. Double-applies and mismatched resume versions follow within a week.

By application 60 you can't easily see which sources are converting because you're scrolling instead of filtering. You need pivot tables to answer "did LinkedIn or direct-to-company actually produce my interviews?" If pivot tables aren't in your skill set, you avoid the question and the data sits unused.

Then the second-interview phase hits at multiple companies. The Notes column has become a wall of text with no structure. Critical detail (the hiring manager's pet question from round 1, the salary band the recruiter mentioned off-record) gets buried right before you need it most.

This is where a Kanban-style application tracker starts pulling its weight. Statuses become columns you drag cards across. Follow-ups fire as reminders instead of dates you have to remember to check. Contact info lives next to the application, not in a parallel tab you forgot existed. Free on Mirrai. If you're still under 30 applications, ignore this paragraph; the spreadsheet is fine.

Mistakes That Make Trackers Useless

The tracker is a tool. The tool isn't the work. A few patterns turn it from useful into theater:

• Backfilling at 9pm on Sunday. By then you don't remember which sources you used, so the data turns into fiction. Update it the minute you hit submit, or don't bother analyzing it later.
• Six statuses is plenty. "Submitted but not confirmed," "maybe interview?," "recruiter saw it on LinkedIn" turn the sheet into a Choose Your Own Adventure book. If a state doesn't fit one of the six, nothing has actually changed yet. Leave the row alone.
• Don't track jobs you haven't applied to yet in the same tab. "Interested in" is a different list. Mixing them inflates your numbers and contaminates your follow-up math.
• An empty Resume Version column usually means you're sending the same file to everything. If that's true, the tracker isn't your bottleneck. The resume is.
• No postmortem. After 30 applications, look at the sheet. Which sources got responses? Which resume versions? Which roles? If you can't tell, the tracker isn't tracking the right things.

On the resume side: if you're shipping one generic file to every role, Mirrai's Job Matcher scores your match against any JD in 30 seconds and flags which keywords are missing. Use it before adding more rows to the spreadsheet.

One Reddit job-hunter started with 70 employers and expanded to over 500 by checking each company's career page directly instead of relying on job-board aggregations. They landed quickly. The tracker was the audit log of a strategy, not a stand-in for one.

FAQ

Spreadsheets handle the first 30 applications well. After that, Mirrai's Application Tracker takes over: Kanban board, automatic follow-up reminders, contact CRM, and a built-in tie to your tailored resume variants. Free to try. Build the spreadsheet first; switch when it starts costing you interviews.