Free Job Search Spreadsheet Template (Google Sheets)
You don't need fancy software to run a job search. A single Google Sheet with the right columns will keep every application, follow-up, and contact in one place, and it costs nothing. Below is a template you can copy in ten seconds, plus exactly what to track and why.
Copy the template
Build it in two minutes, or copy the structure below into a blank Google Sheet. Open Google Sheets, start a blank file, paste these headers into row 1, and freeze the row (View > Freeze > 1 row). That's the whole template.
To copy any shared template into your own Drive, use File > Make a copy so you get your own editable version. Never request edit access to a public template; just copy it.
The columns that actually matter
Most trackers fail because they have too many columns nobody fills in, or too few to be useful. Here's the lean set that covers a real search:
| Column | What goes in it | Why it matters |
|---|---|---|
| Company | Employer name | Sort and spot duplicates |
| Role | Exact job title | Tailor follow-ups precisely |
| Link | URL to the posting | Reread the JD before interviews |
| Date applied | The day you submitted | Time your follow-up |
| Status | Applied / Phone / Onsite / Offer / Rejected | See your pipeline at a glance |
| Source | LinkedIn, referral, company site | Learn what actually works |
| Contact | Recruiter or referrer name | Know who to nudge |
| Next step | The single next action | Nothing stalls |
| Salary range | Posted or your estimate | Compare offers honestly |
| Notes | Anything else | Interview prep, vibes, red flags |
Keep it to one tab until you outgrow it. A second tab for networking contacts is the only addition most people ever need.
Use Status as a dropdown
The Status column is the engine of the whole sheet. Make it a dropdown so it stays consistent: select the column, then Insert > Dropdown, and add your stages (Applied, Phone Screen, Interview, Offer, Rejected, Ghosted). Now you can filter to "everything in Phone Screen" or color-code each stage with conditional formatting.
Add a "Ghosted" status on purpose. A startling share of postings never lead to a real reply, and naming it helps you stop refreshing your inbox for roles that were never going to answer. If you're seeing a lot of silence, it's worth learning how to spot a ghost job before you spend an hour on the application.
Build a follow-up trigger
The biggest payoff from a spreadsheet is timing your follow-ups. Add a small helper column:
- Follow-up due: a formula like
=Date_applied + 7to flag when a week has passed with no reply. - Then conditional-format that cell to turn yellow when today's date is past it.
Now your sheet tells you who to nudge instead of you trying to remember. One polite follow-up after about a week is plenty; more than that rarely helps.
Track your volume so you can adjust
Once a week, glance at how many applications you sent and how many turned into conversations. If you applied to 40 roles and got zero replies, the problem usually isn't volume, it's targeting or resume fit. The fix is fewer, better-matched applications, not more of the same. If you're unsure what a healthy daily number even looks like, see how many jobs to apply to per day.
A quick formula to count your pipeline: =COUNTIF(Status_column, "Applied") gives you live totals per stage, so you always know where things stand.
Spreadsheet vs. a dedicated tracker
A Sheet is free, flexible, and yours forever. The tradeoff is that you type everything in by hand, and there are no automatic reminders. Some people prefer a purpose-built tool.
| Google Sheet | Dedicated app | |
|---|---|---|
| Cost | Free | Often free tier + paid |
| Setup | 2 minutes | Account + import |
| Reminders | Manual formulas | Built in |
| Autofill | None | Some browser extensions |
| Flexibility | Total | Limited to their fields |
If you'd rather not maintain formulas, compare the best job application tracker apps or grab a job application tracker Notion template instead. There's no wrong answer; the best tracker is the one you'll actually keep current.
Where the time really goes
Here's the honest part: the spreadsheet isn't the slow bit. Filling out the same name, address, work history, and "why do you want to work here" boxes across ten different application forms is what eats your evening. That's where JobRizzer fits in: it autofills the application form on Workday, Greenhouse, Lever, Ashby, and the rest from your resume, and on Pro it tailors your resume to each posting. You still review every field and hit submit yourself; nothing auto-applies for you. The first 30 applications are free, then it's bring-your-own-AI-key (free) or $12.99/mo. Pair it with your tracker and you spend your energy on the parts that need a human.
Start now, refine later
Don't over-engineer this. Copy the headers, add a Status dropdown, log your next application the second you send it, and add a follow-up formula when you have a spare minute. A simple sheet you update beats a beautiful one you abandon. The goal isn't a pretty spreadsheet, it's never losing track of a real opportunity again.
FAQ
What columns should a job search spreadsheet have?
At minimum: company, role, link, date applied, status, source, contact, and next step. Add salary range and a notes column once you're applying regularly.
Is a Google Sheet good enough to track job applications?
Yes. For most people a single Sheet handles everything an app does, for free, and you can sort and filter it however you like. Switch to a dedicated app only if you want browser autofill or reminders.
How do I copy a Google Sheets template?
Open the template, then File > Make a copy. The copy lands in your own Drive and you can edit it freely. The original stays untouched.
How often should I update my job tracker?
Update it the moment you apply, not later. A tracker only works if it's current, and 'I'll add it tonight' is how applications get lost.