What is a job search spreadsheet and why use one?
A job search spreadsheet is a single table where every application gets its own row. It answers the questions that become hard to answer from memory after a few weeks: where did I apply, which resume did I send, who did I speak to and what should I do next?
It also protects you from avoidable mistakes. Without a record, it is easy to apply to the same role twice, miss a follow-up window or walk into an interview unable to recall what the posting said. Postings can be edited or removed, so saving the details at the time you apply is a real advantage. If you are still building your routine, our 30-day job search plan shows where tracking fits into each week.
What columns should your tracker have?
Keep it simple. Every extra column is something you have to maintain, so start with these and add more only if you find yourself needing them.
- Company: the employer name.
- Job title: exactly as written in the posting.
- Link: the URL of the posting, and a copy of the description saved somewhere if it might disappear.
- Source: job board, company site, referral or recruiter. This shows you where your leads really come from.
- Date applied: the day you submitted.
- Resume version: a short label such as "marketing v2", so you know what the employer saw.
- Status: use a fixed list, covered below.
- Contact: a recruiter, hiring manager or referrer, with their email or profile link.
- Next action: the single next thing you will do.
- Next action date: when you will do it.
- Notes: anything useful for interviews, such as team size, tools mentioned or questions you want to ask.
Which statuses should you use?
A short, fixed list keeps the sheet easy to filter. A common set is: saved, applied, recruiter screen, interview, final round, offer, rejected and withdrawn. In most spreadsheet tools you can turn the status column into a dropdown so you cannot type inconsistent labels. Consistent labels let you filter to just the live opportunities on any given morning.
Include "saved" for roles you have found but not yet applied to. This is useful when you are collecting postings from the jobs page and other sources, and then applying in focused blocks.
How do you set one up in ten minutes?
- Create the sheet. Open any spreadsheet tool and type the column names above into the first row.
- Freeze the header row. This keeps the labels visible as the list grows.
- Add a status dropdown. Use data validation to limit the column to your status list.
- Add a filter. A filter on the header row lets you sort by date or show only active applications.
- Colour the statuses. Conditional formatting makes offers and interviews stand out and rejected rows fade away.
- Add your existing applications. Fill in what you remember now, even if some cells are blank.
A second tab is optional but handy. Use it for networking: who you contacted, when, what you discussed and when to follow up. Treat people the same way you treat applications and nobody falls through the cracks.
How do you track which resume version you sent?
If you tailor your resume to each role, as you should, you will end up with several versions. Name each file consistently, for example with the role type and a version number, and record that name in the sheet. When an interview invitation arrives, open the exact version the employer has and reread it so your answers match what is on the page. Our guide to tailoring your resume to a job description explains how to change the right parts without rewriting everything.
Before you submit, you can paste a resume and a posting into the free ATS checker to see which key terms are missing. If you need a clean base document, the resume templates give you a single-column layout you can duplicate for each role.
How do you use the sheet to follow up?
The next action date is the most valuable column. When you apply, set a follow-up date a week or so out. Each week, sort by that column and work through anything due. Follow-ups should be short and polite: restate the role, say you remain interested and ask whether there is an update. Our guide on how to follow up after applying for a job has wording you can adapt.
After each interview, update the status, add notes while they are fresh and set a date to send your thank-you message. If you are unsure what to include, see how to write a thank you email after an interview.
What should you review each week?
Block fifteen minutes on the same day each week and look at the whole sheet. Ask yourself:
- How many applications did I send, and how many were tailored?
- Which sources produced replies, and which produced silence?
- Which resume version got the most responses?
- Are there roles stuck in "applied" with no follow-up planned?
- What are my three priorities for next week?
Treat these as signals, not proof. With a small number of applications, patterns can be coincidence. But if one source or one version keeps working, do more of that. If nothing is getting replies, look at your resume and targeting before sending more. A cover letter written for the specific role can help too, and the cover letter tool can give you a draft to edit in your own voice.
What mistakes make trackers useless?
- Updating it weeks later. Memory fades quickly. Add the row when you apply.
- Too many columns. A sheet that takes five minutes per entry will be abandoned.
- Free-text statuses. "Waiting", "pending" and "applied" mean the same thing and break your filters.
- No next action. A record of the past helps less than a plan for the future.
- Counting only applications. Conversations, referrals and informational chats matter as much as submissions.
- Ignoring rejections. Mark them, note anything you learned and move on without dwelling.
Job search spreadsheet checklist
- One row per application, with company, title, link and date applied.
- The source of each lead is recorded.
- The resume version sent is named in the row.
- Status uses a fixed dropdown list.
- Every live row has a next action and a date.
- Contacts are saved with a way to reach them.
- Posting details are saved in case the ad disappears.
- You update the sheet the same day you apply or hear back.
- You do a short weekly review and set priorities.
A tracker will not get you hired on its own, but it keeps a long search organised, makes follow-up automatic and shows you what to change. Set it up today, add the applications you already sent and then keep it current as you go.