The Ultimate Job Search Tracker Setup for Spreadsheet Beginners
Build a simple spreadsheet that tells you who to contact today, what you promised, and which applications have gone quiet — no formulas required.
By Desmond Okafor-Lee · Oct 05, 2026 · 8 min read
A job search tracker is one spreadsheet that answers three questions: what have I applied to, what did I promise someone, and what is due today. You do not need formulas, macros or a paid tool to build one — a blank sheet with the right columns, filled in the same way every time, does the job.
This guide gives you the column list to copy, the daily and weekly habits that keep it accurate, and three follow-up emails you can adapt from it. How employers respond, and how fast, varies enormously by company size, sector and state — the tracker's job is to make sure your side of it never slips.
Tracker Template Columns
Start a new sheet, put these across row 1, freeze that row, and add one row per application. Both Google Sheets and Excel let you freeze the top row and attach a dropdown list to a column (data validation), which is worth doing for Status so your entries stay consistent enough to filter.
| Column | Why it matters |
|---|---|
| Date Applied | Every follow-up decision is measured from this date, and it tells you at a glance whether a quiet application is two days old or two months old. |
| Company | You will apply to the same company twice without realising it unless you can sort by this column. |
| Role Title | Exact titles differ between postings, and you need the employer's wording when you reply or follow up. |
| Source | Records where you found it — a job board, a referral, the company careers page — so you can see which sources actually produce replies. |
| Job ID or Posting Link | Postings get taken down; the ID or saved link is what lets you reference the right req when someone asks. |
| Resume Version Used | If you tailored keywords, job-title wording or metrics for that posting, note which file you sent so an interview question does not catch you out. |
| Contact Name | The recruiter, hiring manager or referrer attached to that application — without a name, a follow-up has nowhere to go. |
| Contact Email or Profile | Keeps the actual address or profile URL next to the name so you are not re-searching for it under time pressure. |
| Follow-Up Date | The one date you act on each morning; set it when you create the row, not later. |
| Status | A fixed set of values (Applied, Screening, Interviewing, Offer, Rejected, No response) that lets you filter your active pipeline away from the dead rows. |
| Next Action | One short phrase plus a date — "send portfolio link, Tue" — so you never reopen a row wondering what you owe. |
| Interview Dates | Each round with its date and the interviewer's name, which is what you need to write a specific thank-you note later. |
| Posted Pay Range | Many states now require a pay range in the posting; copying what was published gives you a reference point later, and tells you when nothing was published. |
| Notes | Anything that will not fit elsewhere: how you were referred, what the recruiter said about timeline, what you want to ask next. |
Add a second tab called Contacts if you are dealing with the same recruiter across several roles, and a third called Archive if the main sheet gets long. Resist adding columns you will not fill in — an abandoned column is worse than no column.
Daily/Weekly Tracking Habits
The tracker only works if updating it is a fixed habit rather than a mood. Pick the cadence below and attach each item to something you already do.
- Daily, within one hour of submitting: add the row — Company, Role Title, Date Applied, Source, Job ID and resume version — while the posting is still open in front of you.
- Daily, at the same moment: set a Follow-Up Date 7 calendar days out and type one Next Action phrase in the row.
- Daily, before closing the tab: paste the full posting text into a notes doc or a hidden column, because postings are removed and you will want the exact requirements before an interview.
- Daily, first ten minutes of your search block: sort or filter the sheet by Follow-Up Date, send only the follow-ups due today, then push each one's date forward.
- Daily, immediately after any call or email: update Status, add the interviewer's name and date to Interview Dates, and rewrite Next Action.
- Weekly, same day each week: change the Status of anything with no reply after 21 days to "No response" and filter it out of your working view.
- Weekly, same sitting: count how many rows you added, then look at the Source column for which channels produced any reply at all and plan next week's hours around those.
- Weekly, two minutes: download a copy of the sheet or confirm version history is on, so a bad paste does not cost you the whole search.
Response times vary widely by employer — a small company may reply in days, while large organisations and public-sector hiring in many US states run on fixed review calendars that can take weeks. Treat the 7-day and 21-day marks as your own working rules, not as a prediction of what the employer will do.
Follow-Up Email Templates
Each of these is a skeleton. Fill every bracket from your tracker row, cut anything that is not true for you, and read it aloud once before sending. Sending any of these unedited is obvious to the person receiving it.
One week of silence after applying
Subject: Following up — [Role Title] application
Hi [Contact Name],
I applied for the [Role Title] role on [Date Applied] and wanted to make sure my application reached you. [One sentence naming a specific requirement from the posting and the experience you have with it.]
Happy to send anything else that would help. Thanks for your time.
[Your Name] [Phone] · [Profile or portfolio link]
Personalize before sending: replace the middle sentence with something only you could write about that posting, and use a real name — if your tracker's Contact Name is blank, find one or skip the email rather than writing "Dear Hiring Team" and hoping.
Thank-you after an interview
Subject: Thank you — [Role Title] conversation, [Interview Date]
Hi [Interviewer Name],
Thanks for the time on [Interview Date]. I keep thinking about [specific topic or problem they raised] — [one or two sentences on how you would approach it, or a detail you did not get to mention].
I'd be glad to answer anything else as you decide. Thank you again.
[Your Name]
Personalize before sending: the specific topic must come from that conversation, so write it into your tracker's Notes column the same day. Send within 24 hours, and write separate versions if you met several people.
Status check at three weeks
Subject: [Role Title] — checking in
Hi [Contact Name],
Checking in on the [Role Title] role I applied for on [Date Applied]. I'm still very interested, and I understand timelines move.
If the role is filled or on hold, I'd appreciate knowing so I can plan — and I'd welcome being considered for [related role or team] if something opens there.
Thanks, [Your Name]
Personalize before sending: name a real adjacent team or role rather than asking to be "kept in mind." Log the send date in Notes, and if there is still no reply after this one, change Status to "No response" at your next weekly review.
Frequently asked questions
How many applications should I add to the tracker each week?
There is no correct number, and anyone quoting you a universal ratio of applications to interviews is guessing — it varies by field, location and how closely you match the postings. Set your own weekly target, write it at the top of the sheet, and use the Source column at your weekly review to judge whether more volume or better-matched roles is the fix.
When should I mark an application dead?
A practical rule is 21 days with no reply after your one-week follow-up, at which point you change Status to "No response" and filter the row out of your active view. Nothing is lost — the row stays in the sheet with the Job ID and Contact Name, so you can reference it if that employer posts again.
Is a spreadsheet enough, or do I need a dedicated tracking app?
A spreadsheet with the columns above does everything most searches need, and it never locks your data behind an account. Job boards do keep partial records of their own — LinkedIn and Indeed both have a "My Jobs" area listing roles you saved and applied to through their site — but neither captures applications you made elsewhere, your Follow-Up Date or your Next Action.
Written by
Desmond Okafor-Lee
Desmond writes about gig work, contracting, and the shifting idea of a 'normal' job. He tracks how people patch together income and what gets lost or gained in that patchwork. He's wary of easy verdicts on whether freelancing is freedom or precarity.
