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 works as a plain job tracker spreadsheet — a job application spreadsheet you own, not an app you sign up for — and 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.
Applicant tracking spreadsheet vs. ATS: same words, different tools
An applicant tracking spreadsheet (this template) is for job seekers tracking their own applications; an applicant tracking system (ATS) is the software employers use to screen candidates. If you searched "applicant tracking system template", this download is the job-seeker version — a personal pipeline tracker. To see how the employer-side ATS reads your resume, run it through our free resume checker.
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.
Job application tracker statuses: Applied, Interview, Offer, Rejected
If you only copy one thing from this template, copy the status list. Six stages, fixed, no improvising:
| Status | What it means | What it tells you when applications pile up here |
|---|---|---|
| Applied | Submitted, no human contact yet | Your resume isn't clearing the ATS screen — fix keywords and formatting first |
| Screening | Recruiter call or take-home in progress | Resume works; the phone screen is where you're losing it |
| Interview | Scheduled with the hiring team | The pipeline is healthy — focus on prep and follow-ups |
| Offer | Written or verbal offer received | Accelerate your other live processes before you answer |
| Rejected | They said no | Log when it came; fast rejections point at fit, slow ones at competition |
| Withdrawn | You pulled out | Worth tracking so your response-rate math stays honest |
Some people add "Ghosted," but resist it — an application with no reply for 30 days is just Rejected with worse record-keeping. Keeping the set small is the whole point: a Friday glance at the status column should tell you which stage your search is dying at, and that stage is the diagnosis.
Adapting it: Google Sheets vs. Excel vs. Notion
The CSV works as-is in all three, but each tool has one upgrade worth doing. If you already know which one you're using, we have a step-by-step setup for each:
- Job application tracker for Google Sheets — the dropdowns, conditional formatting and
FILTERformulas that build a self-maintaining overdue list. - Job application tracker for Excel — the
Ctrl+TTable setup, structured references, a PivotTable, and what to do if your Excel has noFILTERfunction.
The summary below covers the one upgrade that matters most in each tool.
| 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.
Reading your own tracker: the weekly 15-minute review
A tracker nobody reads is a diary. Once a week — same slot, fifteen minutes — sort by Next Follow-up Date and answer three questions.
1. What's overdue? Everything with a follow-up date in the past gets an action today or gets moved to Withdrawn. Nothing stays ambiguous. This single pass is most of the value of keeping a tracker at all.
2. Where is the pipeline narrowing? Count rows per status and compare the drop-offs:
| Pattern | What it means | What to change |
|---|---|---|
| Lots of Applied, almost no Screening | Your resume isn't clearing the ATS or the recruiter skim | Tailor per posting and check your ATS match score before submitting |
| Screening but rarely Interview | The resume works; the phone screen doesn't | Rehearse your two-minute story and salary answer |
| Interview but no Offer | You're competitive and losing on the final margin | Ask for feedback explicitly; tighten your closing questions |
| Very few rows at all | Volume, not quality, is the constraint | Raise weekly application targets before touching the resume |
The stage where applications stop is the diagnosis, and it takes about twenty rows before the pattern is trustworthy. Below that, you're reading noise.
3. What did the ATS Match Score predict? Once you have a dozen scored applications, compare scores against outcomes. Most people find a personal threshold — interviews cluster above it, silence below. That number tells you when a resume is actually ready to submit, which is far more useful than any generic "aim for 80%" advice.
Log the three answers in a Notes row at the bottom of the sheet. Four weeks of those turns a spreadsheet into evidence about your own search.
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.
Job search spreadsheet vs. job application tracker — same thing, different name
A job search spreadsheet and a job application tracker are the same tool: one sheet where you log every role you apply to, its status, and your next follow-up date. People search for both names, so if you arrived looking for a "job search spreadsheet template", the download above is it — the columns are identical whichever term you use.
The only distinction worth making is job search spreadsheets sometimes add prospecting columns (companies to target, contacts to reach, networking touches) alongside submitted applications. If you want that, add two columns to the template: Source (job board, referral, recruiter) and Contact (who you know there). Everything else stays as-is.
Not sure how many roles you should be logging in the first place? See how many jobs to apply to per day for the volume-versus-tailoring math.
Frequently asked questions
- Is there a free job search spreadsheet template?
- Yes — the CSV above is free with no signup and opens in Google Sheets, Excel or Numbers. It covers company, role, posting URL, date applied, status, ATS match score, recruiter contact, next follow-up date, interview stage, salary range and notes, with three example rows showing how to fill it in.
- 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.
- How do I track job applications in Google Sheets without Excel?
- Download the CSV above, then in Google Sheets go to File → Import → Upload and choose "Replace spreadsheet". You never need Excel or a Microsoft account — the file is plain CSV, so Google Sheets, Apple Numbers, and LibreOffice all open it natively and keep every column intact.
- Is an applicant tracking sheet the same as an applicant tracking system?
- No, and the overlap in names causes real confusion. An applicant tracking sheet (or form) is the spreadsheet *you* keep to track the jobs you've applied to. An applicant tracking system is the software *employers* run to screen incoming resumes. This template is the first one — see [which ATS Fortune 500 companies use](/blog/which-ats-fortune-500-uses) for the second.
- 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.