A job search spreadsheet is just a running log of every application, with columns for the company, role, date applied, status, and pay, and it matters more than it sounds like it should once you’re past a handful of applications. Most people lose track around application 15 to 20: you forget whether you already applied somewhere, you miss a follow-up window because you didn’t write down when you last heard anything, and you can’t actually tell whether your search is working or just busy. Below is a free template you can copy directly, the columns that actually matter versus the ones that just add clutter, and how to read your own data once you have a few weeks of it.
Contents
- Copy This Template
- The Columns That Actually Matter
- How to Actually Use It Week to Week
- What Your Own Data Can Tell You
- Setup Checklist
- Frequently Asked Questions
Copy This Template
Copy the header row below into Google Sheets or Excel, then add one row per application. Keep it to one row per company per role, not per interaction, so it stays usable past the first week.
| Company | Role | Date Applied | Source | Status | Last Contact | Pay Range | Notes |
|---|---|---|---|---|---|---|---|
| Aero Staffing Solutions | Support Specialist | Mar 3 | Company site | Interviewing | Mar 10 | $52-58k | 2nd round scheduled Mar 17 |
| [Company] | [Role] | [Date] | [Where found] | Applied / Interviewing / Offer / Rejected / Ghosted | [Last update] | [Range] | [Anything worth remembering] |
The Columns That Actually Matter
- Status, with a fixed set of options. Use the same handful of labels every time (Applied, Interviewing, Offer, Rejected, Ghosted) rather than writing free-text notes here, so you can actually filter and count later.
- Last Contact date, not just date applied. This is the single most useful column for deciding when a follow-up is actually overdue, and it’s the one most people skip.
- Source. Knowing whether a role came from a job board, a referral, or a direct company visit tells you where your results are actually coming from, which matters more than most people expect once you have 30+ rows.
- Pay range, even when it’s a guess. Recording an estimate up front makes it much easier to compare offers later without having to reconstruct what you originally expected.
Skip columns like detailed interviewer names, full job descriptions, or company research notes in the main sheet; those belong in a separate doc per company if you want them, since cramming everything into one row makes the tracker harder to scan at a glance, which defeats the point of having one.
How to Actually Use It Week to Week
- Add the row the moment you apply, not at the end of the day from memory. Rows added later are the ones that end up with missing or wrong dates.
- Update status immediately after any contact, including a rejection, rather than letting rows go stale.
- Sort by Last Contact once a week to see which applications are overdue for a follow-up.
- Set a simple weekly target (a number of new applications, not a number of hours spent) and track it against the sheet rather than your memory of how busy you felt.
- Archive rejected or ghosted rows to a separate tab instead of deleting them, so your active view stays short without losing the history.
What Your Own Data Can Tell You
After three or four weeks, a few simple counts usually tell you more than how the search feels day to day. A low response rate across many applications (say, under 10%) often points to a resume or targeting problem worth fixing before applying to more roles. A decent response rate but few second interviews suggests the gap is happening during the actual conversation, not before it. Getting to second or third rounds regularly but no offers lines up with the pattern in our breakdown of the real odds by interview round, worth a read if that’s where you keep landing.
Setup Checklist
- Copied the header row into a fresh Google Sheet or Excel file
- Picked a fixed, short list of status labels and committed to using only those
- Set a recurring weekly reminder to sort by Last Contact and send any overdue follow-ups
- Decided on a realistic weekly application target based on your actual availability
- Created a second tab for rejected or ghosted applications so the active view stays short
- Bookmarked or shared the sheet somewhere you’ll actually open it daily, not buried in a folder
Frequently Asked Questions
Should I use Google Sheets or Excel?
Google Sheets is usually easier since it’s free, cloud-based, and updates from your phone instantly. Excel works just as well if you already prefer it; the columns matter far more than which program you use.
Is it worth buying a fancier template instead of building this one?
Generally no. Most paid templates add visual polish or automated charts, which are nice but not necessary; the actual value comes from consistently updating a simple sheet, not from how it looks.
Should I track gig or freelance platform applications the same way?
It depends on the volume. For a handful of platforms like Appen or Prolific, a simple list is usually enough; the full tracker earns its keep once you’re applying to many individual roles with separate timelines to follow up on.
How long should I keep a rejected application in the sheet?
Move it to an archive tab rather than deleting it. Having the full history is useful if the same company reaches out again later, and it lets you see your overall numbers accurately.
Is it a good idea to share the spreadsheet with a mentor or accountability partner?
Often yes. Sharing view access with someone you trust can add useful accountability, and a second set of eyes sometimes spots a pattern (like a consistently low response rate from one type of role) that’s harder to notice from inside your own search.
