Job Application Tracker Spreadsheet: Columns That Work

A job application tracker spreadsheet is only useful if it changes what you do next. Most trackers list company, role and date, then go stale, because nothing in them tells you when to follow up or why some applications get replies and others don't.

This guide gives you a column-by-column layout built for two jobs: prompting timely follow-ups and showing patterns after 20 or 30 applications. It works in Google Sheets, Excel, LibreOffice or Numbers, wherever you are applying from.

The core columns of a job application tracker spreadsheet

Start with a small set of columns you will actually fill in. If logging an application takes more than a minute, you will stop doing it by week three.

Column	What to enter	Example
A. Date applied	The date you submitted	03/03/2025
B. Company	Employer name	Northfield Logistics
C. Role	Job title as advertised	Operations Analyst
D. Link	URL of the ad (save a copy too)	Job board or careers page
E. Source	Where you found it	Company site / LinkedIn / referral / agency / job board
F. CV version	Which CV file you sent	ops-analyst-v2
G. Cover letter?	Yes / No / Form only	Yes
H. Status	Current stage	Applied
I. Next action	One verb phrase	Email recruiter
J. Next action date	When to do it	13/03/2025
K. Contact	Name and channel	Priya, LinkedIn
L. Response date	First reply of any kind	10/03/2025
M. Outcome reason	Why it ended, if known	Needed German

Keep the Status column to a fixed dropdown list so you can count it later. A workable set is: Saved, Applied, Acknowledged, Screening call, Interview, Final stage, Offer, Rejected, Withdrawn, No response.

One note on dates: set the whole sheet to one date format. Readers in the UK, Ireland, Australia, Nigeria, India and much of the world use day/month/year, while the US uses month/day/year. Mixed formats break every formula below, so pick one in your spreadsheet's locale settings before you start.

Columns that make follow-up happen

Follow-ups are where most job seekers lose ground, not because they are rude, but because they forget. These columns turn memory into a to-do list.

Next action and next action date

Every row that is still open should have a Next action and a Next action date. Write the action as something you can do in five minutes: "Email Priya to confirm receipt", "Prepare STAR examples for panel", "Check portal status".

Then sort or filter by column J each morning. Anything dated today or earlier is your follow-up list. That is the whole system.

An automatic follow-up flag

Add a column N called Flag with a formula that highlights rows needing attention. In row 2:

=IF(AND(L2="",H2="Applied",TODAY()-A2>=10),"Follow up?","")

This marks any application with no reply after ten days. Ten is not a magic number; a week to two weeks is a common, reasonable gap. If the ad gives a closing date or says "we will contact shortlisted candidates by…", respect that instead and wait until after it.

Add conditional formatting so the cell turns amber when it says "Follow up?". A coloured cell is much harder to ignore than a date.

Contact and channel

A follow-up needs a person. In column K, note who you can contact and how: a recruiter's email from the ad, a hiring manager on LinkedIn, an agency consultant's phone number. If there is genuinely no contact and the application went through a portal, write "Portal only" so you don't waste time searching later.

If you are not sure what to say, keep it to three or four lines: the role, the date you applied, one sentence of continued interest, and a thank-you. Our short email templates for sending a CV can be adapted for follow-ups too.

A privacy point: you are storing other people's names and contact details. Keep the sheet private, don't share it publicly, and delete contact details you no longer need once your search ends. Data protection rules vary by country, but tidiness is good practice everywhere.

Columns that show you patterns

After a few weeks, your tracker becomes evidence. These columns let you ask useful questions instead of guessing.

Source

Is anything coming from job boards, or are your replies all from referrals and direct applications? The Source column answers this. Use the same labels every time ("LinkedIn", not sometimes "LI" and sometimes "Linkedin jobs"), ideally via a dropdown.

CV version

If you tailor your CV, log exactly which file you sent. Name files clearly, such as firstname-surname-ops-analyst-v2.pdf, and record the version name in column F. This lets you see whether one version is attracting more screening calls than another, and it means you can open the exact CV before an interview rather than guessing what you claimed.

If you are deciding how many versions to keep, our guide to master CV vs tailored CV explains a simple structure. When you create a new version, the QuickApplyPilot AI CV builder can help you draft and format it from your existing experience; check every line still describes what you actually did before you send it.

Fit rating

Add a column for your own honest fit rating, 1 to 3, made before you apply:

• 3: you meet nearly all essential criteria
• 2: you meet most essentials and some desirables
• 1: a stretch application

Later you can see whether stretch applications ever progress for you, which helps you decide where to spend effort. If you use a match-score tool, such as the QuickApplyPilot ATS CV checker, you can log that score here too. Treat it as an estimate of keyword overlap, not the score an employer's applicant tracking system gives you; employers configure their systems differently and many shortlisting decisions are made by people reading the CV.

Days to response

Add column O: Days to reply.

=IF(L2="","",L2-A2)

Over time, this tells you how long employers in your field typically take, which makes your follow-up timing less arbitrary.

Stage reached and outcome reason

Record the furthest stage each application reached, separately from current status. Then, in Outcome reason, write what you learned: "Needed driving licence", "Salary range below my minimum", "Feedback: wanted more stakeholder examples". Only write reasons you were actually told or that were clear from the ad. Don't invent explanations for silence; "No response" is a legitimate entry.

Extra columns for remote and international applications

If you are applying across borders, add only the columns that apply to you:

• Location / time zone: e.g. "Remote, UK hours" or "Dubai, on-site". Useful when scheduling follow-ups and interviews.
• Work authorisation needed: Yes / No / Unclear. Note what the ad says rather than assuming.
• Sponsor checked: for countries with public sponsor lists, note whether you checked. In the UK, for example, you can search the Register of licensed sponsors on GOV.UK. Being on a list does not mean an employer will sponsor a particular role, and rules change, so always check official government sources rather than relying on a blog post or recruiter's word.
• Pay currency and model: salary, contractor rate or local entity. This matters for remote roles paid from another country.
• Scam check: Done / Concern. A quick note if anything looked off, such as fees requested or a chat-only interview.

Simple views and formulas to read your patterns

You don't need dashboards. Three small calculations on a separate tab are enough.

Reply rate by source (any reply other than "No response"):

=COUNTIFS(E:E,"LinkedIn",H:H,"<>No response")/COUNTIF(E:E,"LinkedIn")

Copy it for each source label. Format as a percentage.

Screening calls by CV version:

=COUNTIFS(F:F,"ops-analyst-v2",H:H,"Screening call")

Because status changes as an application moves on, you may prefer to count a separate Furthest stage column instead.

Open follow-ups this week: filter column J for dates up to seven days ahead.

A pivot table also works if you are comfortable with them: rows by Source, columns by Furthest stage, values as count.

A fortnightly review checklist

Every two weeks, spend 15 minutes with the sheet and answer these questions:

1. Are there any rows with a past next action date? Do them or close them.
2. Which source has produced replies, and which has produced nothing?
3. Is one CV version reaching screening calls more often than another?
4. Are fit-3 applications progressing, while fit-1 ones are not? Or the reverse?
5. Do outcome reasons repeat (a missing certificate, a language, location)?
6. Should anything marked "Applied" for over a month be moved to "No response"?

Be careful with small numbers. If you have sent five applications through one source, one reply versus none tells you very little. Look for patterns that hold over 20 or more applications, and treat early results as hints, not proof.

Mistakes that make trackers useless

• Too many columns. Start with the core set. Add a column only when you have a question it will answer.
• Free-text everything. Use dropdowns for Status, Source and Fit so you can count them.
• Not saving the ad. Ads disappear after closing. Save a PDF or paste the text into a linked document so you can prepare for interviews later.
• Logging in batches. Fill in the row the moment you submit. Retrospective logging means lost dates and wrong CV versions.
• Chasing too often. One polite follow-up, and perhaps a second after a further week or two, is usually plenty. Then mark it closed and move on.

Set up the sheet once, keep the next action date column honest, and your tracker will tell you both what to do tomorrow and where your search is working.