Job Search Tracker: the spreadsheet that gets you replies
One table, ten columns, and a 20-minute weekly review. Stop chasing applications from memory.
Most job searches fail on follow-up, not on effort. You apply to 20 companies, forget which one you emailed, miss the second nudge by three weeks, and wonder why nobody calls back. A tracker fixes this: every application becomes one row, and every follow-up becomes a dated next action. Build it in any spreadsheet app in about ten minutes.
Build the base table (ten columns)
Create these columns exactly. Resist the urge to add more — ten is the minimum that keeps every stage visible.
| Column | What you write | Example |
|---|---|---|
| Company / Role | Company name plus the exact job title | Northwind — HR Coordinator |
| Date applied | The day you actually submitted | 2026-10-20 |
| Source | Where the lead came from | Referral (Ana G.) / LinkedIn / Board |
| Contact | Recruiter or internal referrer, with email | recruiter@northwind.com |
| Stage | One of: Applied / Screen / Interview / Offer / Closed | Screen |
| Next action | The single next step, in words | Send thank-you note |
| Next date | Hard date for the next action | 2026-10-28 |
| Follow-ups | Count and dates of nudges sent | #1 on 2026-10-27 |
| Notes | Salary range, interview questions, red flags | $62-68k band; asked about team size |
| Status | Active / On hold / Closed won / Closed lost | Active |
What to log at each stage
- Applied: log the source. Referrals get a shorter follow-up clock (3 business days) than cold applications (5).
- Screen call: write down the questions you were asked and the salary band they mentioned — you will reuse both.
- Interview: within 30 minutes, jot two lines: what went well, and the one question you fumbled. This feeds your next interview prep.
- Offer: record the deadline and every number (base, bonus, vacation, remote days) — you will use the negotiation-notes page on it.
The 20-minute weekly review
Every Friday, sort the table by Next date and ask three questions:
- Which rows are stalled over 7 days? Send one follow-up, or close the row and stop carrying it.
- What are my funnel numbers this week? A realistic funnel is about 30 applications to 8 screens to 3 interviews to 1 offer.
- Is the funnel broken at the top? If 30 applications produced zero screens, your resume keywords — not your interviewing — are the problem.
How it works
- Open a new spreadsheet and create the ten columns above before applying to your next role.
- Add every new application within 24 hours of submitting — a row you forget is a follow-up you miss.
- Spend 20 minutes each Friday clearing stalled rows and checking your funnel numbers.
Most people work best with 15 to 25 active rows. Fewer than 15 means your funnel is too thin to produce interviews; more than 25 and follow-ups slip. When a row turns into an offer or rejection, close it out so the active list stays manageable.
Send the first follow-up five business days after applying if you have a contact name. Then wait another five business days for a second, shorter nudge. After that, move on — repeated messages damage your reputation with the recruiter.
Send one polite thank-you email within 24 hours, then one follow-up after the date they gave you. If they still do not reply after two more weeks, close the row and focus on companies that respond. Silence itself is feedback.
No. A spreadsheet with the ten columns on this page beats most paid tools in the first three months. You only outgrow it when you are past 50 applications in parallel, and even then exporting your data is trivial.
Yes. Mark the source column clearly and add a row for your internal referrer. Referrals usually get screened within a few days, so their follow-up clock is shorter — chase silence after three business days instead of five.
Who this tool is for
Use this when the search has more moving parts than memory can hold: five or more applications a week, referrals running alongside cold applications, or two role families at once. It also gives structure to a search after a layoff, when the days blur and progress feels invisible.
It is a spreadsheet you maintain, not an app that scores you. Do not start it if you will not open it on Friday; an unreviewed tracker feels like progress while hiding the follow-ups you missed. It is also not an ATS for recruiters, and not worth the setup for two applications.
How to read your result
The result is a table plus a weekly snapshot. Read four things before adding more rows.
- Row count. Fifteen to twenty-five active rows. Fewer makes the funnel too thin; more and follow-ups slip.
- Stalled rows. Sort by next date. Any row more than seven days past it needs one action or a close.
- Stage mix. Most rows stuck at Applied points to resume keywords. Plenty of screens but no interviews points to your answers.
- Source column. After six weeks, compare which sources produced screens, not how many applications you sent. Referrals follow up after three business days; cold applications after five.
- Follow-up log. Write the date you sent, not a count. A count hides whether the last nudge was last week or last month.
- Funnel shape. The 30 to 8 to 3 to 1 pattern on the page is a planning heuristic, not a promise. Use it to choose between widening your sources and fixing your materials.
- Closing rows. Won and lost both get closed. A dead row left open takes attention from a live one.
A worked example
Maya, 29, was a marketing coordinator at an education company in Shanghai until a September restructure. She is targeting sixteen roles, half in-house brands and half agencies. By 23 October her table looks like this.
| Company and role | Applied | Source | Stage | Next action | Next date | Status |
|---|---|---|---|---|---|---|
| Halden Studio — Marketing Coordinator | 10-06 | Referral (Jonas) | Screen | Send portfolio and thank-you | 10-09 | Active |
| Brightline Retail — Content Executive | 10-08 | Applied | Follow up with hiring manager | 10-15 | Active | |
| Moss and Co — Campaign Manager | 10-09 | Job board | Closed lost | None | None | Closed lost |
| Kestrel Health — Marketing Executive | 10-12 | Referral (Priya) | Interview | Prepare case study | 10-20 | Active |
| Farrow Foods — Brand Assistant | 10-15 | Cold email | Applied | Wait, then nudge | 10-22 | Active |
On Friday 23 October two rows are past their next date, Brightline and Farrow. Maya sends one short follow-up to each and closes Moss and Co, where the rejection cited two years of agency experience she does not have. Her snapshot reads sixteen applications, four screens and two interviews. Monday's decision is not more applications; it is adding agency keywords to the resume. She also moves the Kestrel interview to the top of Monday's list, because a live interview deserves more attention than a cold row that has not replied.
The table does not measure her worth. It tells her which three emails to send before lunch.
Common mistakes
- Too many columns or tabs by day two. Ten columns survive; twenty do not.
- Logging only when a reply arrives. Log at submission, or the row never exists.
- Vague next actions such as follow up. Write the channel and the first sentence you will send.
- No hard date, so nothing surfaces on Friday.
- Managing the search from the inbox. Email is where messages go to be forgotten.
- Leaving dead rows open. Close them and reclaim the attention.
- Counting applications as progress. Conversations are the unit that moves.
- Storing private contact detail in a shared file. Keep a work email and the minimum you need, not a recruiter's mobile or someone else's salary.