Job Application Tracker in Google Sheets (Free Template + Setup)

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.