Job Application Tracker in Google Sheets (Free Template + Setup)
A free Google Sheets job application tracker template, plus the exact columns, formulas, and conditional formatting that make it actually useful past week two.
Why Google Sheets is the right starting point
If you're tracking your job search, a Google Sheets job application tracker is the right tool for the first 30–50 applications. It's free, works offline-ish, syncs across devices, and you don't have to learn a new app to use it. Notion is overkill. A dedicated app is overkill. A sheet is fine.
The trick is setting it up so you actually keep it updated past week two. Most trackers die because the columns are wrong, not because spreadsheets are wrong.
The 10 columns that matter
Company. Role. Date applied. Source (LinkedIn, referral, company site). Stage (Applied, Screen, Interview, Offer, Rejected, Ghosted). Last contact date. Next action. Next action date. Salary range (if posted). Notes.
That's it. Don't add a column for recruiter LinkedIn, a column for company headquarters city, or a column for 'excitement level 1–10'. Every column you add is a column you'll stop filling in by week three.
Three formulas that earn their keep
Days since applied: =TODAY()-C2 in a Days Open column. Conditional-format anything over 14 days a soft red — those are your follow-up candidates.
Auto-flag stale: =IF(TODAY()-H2>7,"⚠️ follow up","") next to your Next Action Date column. The emoji shows up as soon as a row goes stale.
Source breakdown: =COUNTIF(D:D,"LinkedIn") in a sidebar. After 30 applications you'll learn whether LinkedIn, referrals, or company sites actually convert for you.
Free Google Sheets template
We publish the same template Recruit Flow imports — copy it, save your own version, start tracking in under two minutes. It's the columns above, with the formulas and conditional formatting wired up. No sign-up.
Grab it from our applicant tracking spreadsheet template page, or use the free browser-based job application tracker if you'd rather not touch Sheets at all.
When to graduate from Sheets
If you're a recruiter or hiring manager (not a job seeker) and two people are editing the same row — that's the moment. Spreadsheets don't do multi-editor well. You also outgrow Sheets the moment you need a board view, a real candidate timeline, or stage-aging alerts. Recruit Flow imports your existing tracker CSV and maps the columns automatically, so the migration is paste-and-go, not a rebuild.
Run this pipeline in RecruitFlow
A calm, focused hiring tracker for recruiters and small teams. Table and Kanban views, real candidate timelines, stale-stage alerts — no configuration project required.
Sign up to RecruitFlowCreate your account · verify your email · choose a plan · move in today.
Useful next steps
Related posts
The applicant tracking spreadsheet, done properly (free template + when to upgrade)
A practical guide to the applicant tracking spreadsheet: the six columns small teams actually use, a free Excel and Google Sheets template, and the honest moment to switch to a recruiting candidate tracker.
The Best Excel Spreadsheet for Job Hunting (Free Template)
A free, opinionated Excel spreadsheet for job hunting — built around the 10 columns that actually keep your search organized past week three.
Recruitment Pipeline Template: A Free Framework You Can Set Up Today
A practical recruitment pipeline template covering every stage from sourcing to placement, plus when to graduate from a spreadsheet to real tracking software.
How to Resurface Old Candidates Instead of Sourcing From Scratch Every Time
Your best next candidate might already be in your database. Here's how to actually make past candidates searchable and usable, instead of starting over every time.
How to Create a Recruitment Tracker in Excel (Step-by-Step)
A practical walkthrough for building a recruitment tracker in Excel — the right columns, the formulas for time-to-hire and source-of-hire, and the moment to graduate to a real ATS.
Interview Tracker Template: Track Feedback & Decisions
A simple interview tracker template with the fields, feedback structure, and follow-up cadence small teams need to stop losing strong candidates after interviews.