← Blog

Guide

How to Track Your Job Applications

By The Job Alert Team · October 22, 2026

Two weeks into a serious job search, most people hit the same wall: someone calls about a role and they cannot remember which version of their CV they sent, what the salary range was, or whether they already applied to that company a month ago under a different job title.

The fix is a record you keep yourself. Not an app, not a service — a file you own, in a format you can read in five years. This post is a layout you can build in about ten minutes and maintain in about a minute a day.

Why a plain spreadsheet wins

A spreadsheet is portable, works offline, exports anywhere, and is impossible to lock you out of. It also lets you sort and filter, which is the entire point: the value of a record is not in writing it down, it is in being able to ask it questions. Which of my applications are older than two weeks with no reply? Which three companies have I heard from twice?

Create one file. One sheet for live applications, one for archived ones. That is the whole structure.

The columns worth having

Anything you would want to know while a recruiter is on the phone.

Column	Why it earns its place
Date applied	The basis of every follow-up decision
Company	Prevents duplicate applications and awkward overlaps
Job title as advertised	Titles differ from what you call the job; quote theirs
Link to the original posting	Postings disappear; keep the URL and a saved PDF
Source	Where you found it, so you learn which sources actually work
Location and work type	On-site, hybrid, remote — and which city
Salary range if stated	Otherwise “not stated”, which is itself information
CV version sent	“CV-analyst-v3” beats trying to remember
Cover note sent?	Yes or no, plus where the file lives
Contact name and email	The person who replies, once you know who they are
Status	See the fixed vocabulary below
Next action and date	The single most useful column in the sheet
Notes	Interview questions asked, names heard, anything said about timelines

Keep the status vocabulary short and fixed, so you can filter on it: Applied · Acknowledged · Screening call · Interview 1 · Interview 2 · Task · Offer · Rejected · No response · Withdrawn.

Add one optional column if you are searching across countries: documents needed. For international roles, that column will save you more time than all the others combined.

A rule that keeps the file honest: nothing gets a status change without a date. “Interview 1 — 14 Nov” is a record. “Interview” is a memory.

Email folders and labels

Your inbox is already a log of your job search. It just needs three minutes of structure.

• Create one parent folder or label — Job search — with three children: Applied, Active conversations, and Closed.
• Move every confirmation email into Applied the moment it lands. Anything that gets a human reply moves to Active conversations.
• Use a filter or rule to label incoming mail from your applications automatically where the sender domain is predictable.
• Star only what needs a reply today. If everything is starred, nothing is.
• When you apply through a portal, forward yourself the confirmation with the company name in the subject line. Portal emails are often unsearchable because the sender is a no-reply address and the subject says nothing.

One more habit worth the effort: save the job posting as a PDF at the moment you apply. Listings are taken down, and the description is what you will want to re-read the night before an interview. How long job postings stay up explains why a posting you saw last week may already be gone, and where listings come from explains why the same role can appear in several places under different wording.

Calendar reminders for follow-ups

The spreadsheet remembers; the calendar prompts. Put the prompt where you already look.

When	Reminder to set
Day of applying	Nothing — resist the urge to follow up immediately
Day 7	Check whether the posting is still live; note it
Day 10–14	Send one short follow-up to a named contact if you have one
Day 21	Mark as “no response” and move to the archive sheet
24 hours after any interview	Send the thank-you note
Date the employer promised a decision, plus 2 days	Polite check-in

Set these as all-day events with the company name in the title, so a glance at the week tells you what is owed. One follow-up is professional; three is not, and the calendar is what stops the third.

The weekly review that makes the record pay off

Fifteen minutes, same time each week. Sort by date applied and ask four questions.

1. What needs a follow-up this week? Do them in one sitting.
2. What is dead? Move it to the archive sheet. A short live list is easier to face.
3. Which sources produced replies? After twenty or thirty applications you will see a pattern — one channel is carrying your search and another is noise. Spend your time accordingly.
4. Where do I stall? Lots of applications and no acknowledgements is a CV-and-targeting problem. Plenty of first calls and no second rounds is an interview-preparation problem. The record is what tells you which one you have.

Keep it low-friction, and back it up

The best record is the one you actually update. Two rules keep it alive: fill in the row at the moment you apply, never later, and never add a column you will not maintain. If you have skipped a field three weeks running, delete it.

Store the file in cloud storage or email yourself a copy monthly, and keep your CV versions in the same folder as the sheet. Phones get lost and laptops fail, and rebuilding four months of search history from memory is genuinely painful.

That is the whole system: one spreadsheet, three email folders, six standing calendar reminders, and a quarter of an hour on a Friday. It costs nothing, it belongs to you, and it will still make sense the next time you need it.

---