Free Job Application Tracker Template (Google Sheets, Excel & Notion) — 2026
Somewhere around application number eight, every job search hits the same wall: you get a call from a recruiter, they say "I'm following up on your application," and you genuinely cannot remember which version of your resume you sent them — or whether you applied at all. That's not a memory problem. It's a tracking problem, and it costs people interviews every week.
This post gives you a free job application tracker template you can download in one click and open in Google Sheets, Excel, or Apple Numbers. It ships with three realistic example rows so you can see exactly how to use it, plus a column-by-column explanation of why each field earns its place.
Download the template
Download the free job application tracker template (CSV) — it opens in Google Sheets, Excel, or Numbers. No signup, no email gate, no watermark. It includes the header row plus three example applications (one just applied, one in screening, one at the interview stage) so the format is obvious at a glance. Delete the examples once you've added your first real row.
How to import it into Google Sheets
- Download the CSV file above.
- In Google Sheets, open a blank spreadsheet, then go to File → Import.
- Click the Upload tab and drag in
job-application-tracker-template.csv(or browse to it). - Leave the defaults (Replace spreadsheet, separator Detect automatically) and click Import data.
- Optional but worth 60 seconds: select row 1 and choose View → Freeze → 1 row so the headers stay visible as your list grows.
Excel and Numbers users can simply double-click the file — both open CSVs natively. In Excel, save it as .xlsx afterward so formatting sticks.
What each column does (and why it's there)
Plenty of trackers fail because they're either too thin (company + date, useless in week three) or too bloated (27 columns nobody fills in). These 11 are the ones that survive contact with a real search.
Company and Role. Obvious, but write the exact job title from the posting, not your shorthand. When a recruiter calls about the "Marketing Coordinator II" role, you want to match on their words, and you'll reuse that exact title in your tailored resume and thank-you emails.
Job Posting URL. The single most underrated column. Companies routinely pull postings once they have enough applicants — often right around when you get the interview invite. If you saved the URL (or better, pasted the full description into the Notes or a linked doc), you can still prep against the actual requirements. Without it, you're rehearsing for an exam whose questions you threw away.
Date Applied. This drives everything downstream: when to follow up, when to consider an application dead, and — over a full search — your real response-rate data. If you're getting callbacks on 2 of 40 applications, that's a resume problem, and you'll only spot the pattern if the dates are logged. Our weekly job search routine leans on this column heavily.
Status. Use a small, fixed set of pipeline stages and be strict about it: Applied → Screening → Interview → Offer, plus Rejected and Withdrawn. Resist inventing stages like "probably ghosted" or "they seemed keen." The point of a pipeline is that a Friday glance tells you exactly how many applications sit at each stage — and where they're dying. If everything stalls at Applied, your resume isn't clearing the ATS screen. If you reach Screening but never Interview, the problem is your phone screen, not your paperwork. The stage where applications die is the diagnosis.
ATS Match Score. Before you submit, run your resume against the job description and record the match score. Two payoffs: first, it forces the tailoring step instead of letting you fire off the same PDF forty times; second, after a month you can compare scores against outcomes. If your interviews cluster among applications that scored 80%+ and your silence clusters below 65%, you've just learned your personal threshold. You can get a score from our free resume checker in under a minute per application.
Contact / Recruiter. The moment a human enters the process — a recruiter emails you, a hiring manager appears on a screen invite — log their name and role. Follow-ups addressed to "Priya, following up on our Tuesday call" get answered. Follow-ups addressed to careers@company.com do not.
Next Follow-up Date. If you adopt only one habit from this post, make it this one. More candidacies die from missed follow-ups than from bad interviews. Recruiters juggle dozens of open requisitions; a polite nudge at the right moment is often what moves your file from the "pending" pile back to the top. The rule that works: every time anything happens — you apply, you finish a screen, they say "we'll be in touch next week" — immediately write the next follow-up date. Applied and heard nothing? Follow up at 7–10 business days. Finished an interview? Thank-you note within 24 hours, follow-up on the date they gave you plus two days. An empty follow-up column means that application is drifting, and drifting applications become ghosted applications.
Interview Stage. Separate from Status on purpose. Status says where in the pipeline you are; Interview Stage says what's actually scheduled — "recruiter screen 7/14," "panel 7/16," "take-home due Friday." When you're running multiple processes at once, this column is what stops you from prepping the wrong company's case study.
Salary Range. Log the posted range (increasingly required by law in many US states) or whatever the recruiter tells you. When you reach offer stage at one company, this column tells you instantly which of your other live processes are worth accelerating — and gives you real numbers for negotiation instead of vibes.
Notes. Everything else: who referred you, what the recruiter asked, the interviewer's name and what they cared about, why you withdrew. Future-you, prepping for round two, will thank present-you.
Adapting it: Google Sheets vs. Excel vs. Notion
The CSV works as-is in all three, but each tool has one upgrade worth doing.
| Tool | Best-fit upgrade | How |
|---|---|---|
| Google Sheets | Status dropdowns + shared access | Select the Status column, then Insert → Dropdown; add Applied, Screening, Interview, Offer, Rejected, Withdrawn. Easy to share with a mentor or career coach. |
| Excel | Conditional formatting on Status | Home → Conditional Formatting → Highlight Cell Rules → Text that Contains: green for Interview/Offer, yellow for Screening, gray for Rejected. Your pipeline becomes readable at a glance. |
| Notion | Database views by stage | Create a database with the same 11 fields: Status as a Select property, dates as Date properties, ATS Match Score as a Number. Then add a Board view grouped by Status for a kanban pipeline, and a Calendar view on Next Follow-up Date. |
A few specifics:
- Google Sheets: after adding the Status dropdown, add a conditional-format rule on the Next Follow-up Date column —
Format → Conditional formatting → Date is before → todayin red. Overdue follow-ups now glow at you. - Excel: beyond Status colors, turn the range into a proper Table (Ctrl+T) so sorting and filtering by Status or Date Applied is one click.
- Notion: the kanban Board view is genuinely nice for drag-and-drop stage changes, but keep the Table view as your default for weekly reviews — kanban hides the follow-up dates that matter most.
When a spreadsheet stops working
Honest answer: a spreadsheet is the right tool for your first handful of applications, and it starts to crack somewhere around 10+ parallel applications. The failure mode is always the same — the spreadsheet only knows what you remember to type into it. Follow-up dates don't nag you. Status doesn't update itself when a rejection email lands. And the ATS Match Score column depends on you running a check and pasting the number in, every single time, usually at 11pm when you're least likely to bother.
If you're at that volume, our job application tracker does the same pipeline with the manual steps removed — and it computes an ATS match score for every application automatically, scoring your resume against each specific job description as you add it. That's the column that predicts callbacks, and it's the one that spreadsheet users abandon first. The spreadsheet template above is genuinely enough for a focused, low-volume search; the tool earns its place when the tab count gets out of hand.
Either way: track from application number one. The candidates who convert searches into offers aren't the ones who apply the most — they're the ones who never let a live application go cold.
Frequently asked questions
- Is this job application tracker template really free?
- Yes — the CSV download is free with no signup or email required. It opens directly in Google Sheets (File → Import → Upload), Excel, or Apple Numbers, and includes three example rows showing how to fill it in.
- What statuses should I use in a job application tracker?
- Keep it to six: Applied, Screening, Interview, Offer, Rejected, and Withdrawn. A small fixed set makes your pipeline readable at a glance and shows you exactly which stage your applications are dying at — which tells you what to fix.
- How often should I follow up on a job application?
- Follow up 7–10 business days after applying if you've heard nothing, and within 24 hours after any interview with a thank-you note. Set the Next Follow-up Date column immediately after every event — missed follow-ups quietly kill more candidacies than weak interviews do.
- Should I use a spreadsheet or an app to track job applications?
- Use the spreadsheet for a focused search of under about 10 parallel applications — it's free and flexible. Past that point, manual updates and follow-up reminders start slipping; a dedicated tracker that auto-scores your resume against each job description saves the busywork.