Job Application Tracking — How to Never Lose Track of Where You Applied

A recruiter calls. "Hi, this is regarding the position you applied for." And there's that half-second of silence where you're mentally scrolling through forty applications trying to figure out which company, which role, and whether you actually wanted this one. Everyone tells you to "keep a spreadsheet" and then stops there. Here's the actual system — what to track, what to skip, and how to keep it maintainable when you're applying to ten jobs a week.

Why the Usual Advice Fails

Most people start a tracking spreadsheet, use it enthusiastically for a week, then abandon it. The reason is almost always the same — the first version has too many columns. Someone reads a blog suggesting fifteen fields, sets it up, and by day four filling in fifteen boxes per application feels like more work than the application itself.

The working version is deliberately small. Start with the minimum, add columns only when you actually feel their absence.

The Essential Columns — Start With These Six

Columns to Add Later — Only When You Need Them

These aren't necessary on day one. Add them once you've been applying for two or three weeks and start noticing what you keep wishing you had written down.

• Resume version used — if you maintain more than one resume (say, one backend-focused and one full-stack), noting which one went out matters when you're preparing for the interview
• Contact person — recruiter name and email, if you had one; useful for follow-ups and for recognising the name months later
• Referral used — whether someone referred you, and who; you'll want to update them when something moves
• Salary mentioned — if the posting listed a range, note it; useful during negotiation and for spotting patterns across companies
• Next action date — the date you plan to follow up; this turns a passive log into something that actually prompts you
• Notes — one free-text column for anything that doesn't fit; keep it genuinely short

Where to Actually Keep It

Google Sheets — the default recommendation

Accessible from phone and laptop, free, and syncs automatically. The phone access matters more than people expect — when a recruiter calls while you're commuting, you need to check the entry in twenty seconds, not after getting home.

Notion — if you already use it

Better if you want to attach documents, keep interview notes alongside each application, or use a kanban board view. But if you don't already use Notion daily, setting it up becomes another form of productive procrastination.

Notes app — the honest minimum

If a spreadsheet feels like too much friction and you know you won't maintain it, a plain notes file with one line per application is genuinely better than nothing. Format: date, company, role, platform. That's it. An imperfect system you actually use beats a perfect one you abandon.

Follow-Up Timing — The Part Nobody Specifies

"Follow up if you don't hear back" is standard advice that never says when. Here's a workable timeline:

• Days 1-7: Do nothing. Applications genuinely sit unread for a week at most companies, especially large ones with high volume.
• Day 7-10: First follow-up, only if you have a direct contact (recruiter email, referral). If you applied through a portal with no contact, there's usually nobody to follow up with — accept this.
• Day 14-21: Second and final follow-up. Keep it brief, reference the specific role, and don't apologise for following up.
• After day 30: Mark it as "No response" and move on. Continuing to chase past this point rarely changes anything and takes energy away from new applications.

What a follow-up message should actually say

Three things make this work — the exact role title (they may be hiring for several), the date (helps them locate your application), and one specific detail showing you actually read the posting rather than mass-applying.

The Weekly Review — 10 Minutes, Once a Week

A tracker only becomes useful if you actually look at it. Pick a fixed time — Sunday evening works for most people — and do three things:

• Update statuses for anything that changed during the week
• Check which applications have crossed the 7-day and 14-day marks, and send follow-ups where you have a contact
• Look at the pattern — which platforms are producing responses, which roles are getting screening calls, which aren't

That third point is where the tracker stops being admin work and starts being useful. After twenty or thirty applications, patterns become visible. If every referral application gets a response and every cold portal application doesn't, that tells you exactly where to spend the next month's effort.

Small Mistakes That Break the System

• Inconsistent date formats — mixing "4 Aug", "08/04", and "4-8-26" makes sorting impossible; pick one format and stick to it
• Status values typed freshly each time — "Applied", "applied", and "Application sent" are three different values to a spreadsheet; use a dropdown if your tool supports it
• Adding entries in batches — logging ten applications at the end of the week means half the details are already fuzzy
• Tracking only successes — rejections and non-responses are the data that tells you what to change; deleting them removes the most useful signal
• Making it too pretty — colour-coding and formatting feel productive but add maintenance burden; plain and functional survives longer

When You're Applying at High Volume

If you're sending out fifteen or twenty applications a week, a few extra habits help:

• Use a browser bookmark folder for postings you plan to apply to but haven't yet — keeps the "to apply" queue separate from the "applied" log
• Batch similar roles together when applying, so you can reuse the same tailored resume across three or four genuinely similar postings
• Set a weekly cap on applications if the volume starts feeling mechanical — twenty rushed applications typically produce fewer responses than eight considered ones

One Honest Note

A tracker doesn't improve your chances of getting hired. It improves your ability to respond well when something does happen, and to see what's working when it isn't obvious. The applications themselves — how well the resume matches each role — still matter far more. The tracker just makes sure the effort you're already putting in doesn't get lost in the noise.