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:

ColumnWhat goes in itWhy it matters
CompanyEmployer nameSort and spot duplicates
RoleExact job titleTailor follow-ups precisely
LinkURL to the postingReread the JD before interviews
Date appliedThe day you submittedTime your follow-up
StatusApplied / Phone / Onsite / Offer / RejectedSee your pipeline at a glance
SourceLinkedIn, referral, company siteLearn what actually works
ContactRecruiter or referrer nameKnow who to nudge
Next stepThe single next actionNothing stalls
Salary rangePosted or your estimateCompare offers honestly
NotesAnything elseInterview 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 + 7 to 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 SheetDedicated app
CostFreeOften free tier + paid
Setup2 minutesAccount + import
RemindersManual formulasBuilt in
AutofillNoneSome browser extensions
FlexibilityTotalLimited 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.