Application Tracking: Why Excel Is Ruining Your Job Search

Application tracking sounds like admin, but it's the difference between a job search that moves forward and one that goes in circles. With five applications, everything fits in your head. With thirty, you no longer remember which resume version went to which company, who you promised to get back to, or who said "we'll be in touch next week" three weeks ago.

Excel and Google Sheets are a great starting point - free, flexible and familiar. The trouble starts when the search grows, and that's what this guide solves: how to build a tracker that doesn't fall apart, with or without a dedicated tool.

Why does an Excel tracker break down as your search grows?

Because a spreadsheet stores information but doesn't prompt you to act on it. A follow-up date in a cell doesn't ring, interview notes get crammed into one cell, and the link between a role and the resume you sent lives only in your memory.

• Dates without reminders: the follow-up due on Tuesday gets remembered the following Monday.
• Lost versions: "resume final 4" went to one role, "final 5" to another, and in the interview you're not sure what the interviewer has in front of them.
• Scattered contacts: some on LinkedIn, some in email, some in messaging apps - none in the sheet.
• Notes with no home: what the HR screen asked, the range you discussed, the next step - all of it needs to be at hand before the next round.
• No overview: it's hard to see at a glance how many applications are stuck at the same stage, or which channel actually produces calls.

What should you track for each application?

Eight fields are enough. Fewer, and you'll be missing information before an interview. More, and you'll stop updating the sheet within a week.

• Company and role - with a link to the posting. Postings get taken down, so keep a copy of the text too.
• Date applied - so you know when the follow-up is due.
• Channel - company site, job board, referral, recruiter outreach. This is the field that later tells you what works.
• Resume version - the exact file name you sent.
• Contact - name, title, and how you reached them (LinkedIn, email, phone).
• Stage - from a fixed list (see below), not free text.
• Next-action date - follow-up, interview, take-home due.
• Notes - what was asked, what was agreed, what to prepare.

What are the stages of a job application?

Seven stages cover almost any hiring process. A fixed list matters more than the exact names: it lets you filter and count.

• Applied - sent, no response yet.
• Screen - a short call with a recruiter.
• HR interview - fit, expectations, availability.
• Technical interview or assignment - with the hiring manager or the team.
• Final round and references - sometimes with a senior manager or reference checks.
• Offer - including the deadline to respond.
• Closed - rejected, withdrew, or the role was cancelled. Don't delete these rows: they'll help you see what didn't work.

Each stage needs different preparation. Before HR and technical rounds, review your notes alongside guides like HR interview questions and technical interview prep.

What should you write down after each interview?

Five lines, within an hour, while it's fresh: who interviewed you, what they asked, what went well, what didn't, and the next step. The next round is often run by someone who has read the previous interviewer's notes - you should have yours too.

• Who interviewed you and their role - so you can name them in the thank-you note and the next round.
• The questions asked - especially the ones you stumbled on. They almost always come back, at this company or another.
• What you learned about the role and team that wasn't in the posting, and is worth bringing up later.
• Anything said about salary, availability or timelines - even in passing.
• The next step and its date - and if no date was given, ask at the end and write it down.

When should you follow up on an application?

Five to seven working days after an application that has a contact, and within 24 hours after an interview (a thank-you note). If you were told "we'll get back to you by Thursday", wait until the following Monday before asking.

• After applying: one follow-up, after 5-7 working days, only if there's someone to write to. For a job-board application with no contact, there's no follow-up - only a fresh outreach to someone at the company.
• After an interview: a short thank-you within 24 hours. See message templates for recruiters.
• After "we'll get back to you": wait until the date they gave plus two days, then ask once.
• After a long silence: after one unanswered follow-up, mark it closed and move on. If they come back, great.

The trick is to set the follow-up date the moment you apply, not when you happen to remember.

How do you build a tracker that works in Excel or Google Sheets?

One row per application, one column per field, and three small settings that turn a static sheet into a working tool.

• A dropdown for the stage column (data validation), so stages are spelled the same way and can be filtered.
• Conditional formatting on the next-action date: highlight it when the date is today or past. That's the reminder a sheet is missing.
• Freeze the header row and sort by next-action date, so whatever is urgent is always on top.
• A separate tab for contacts, linked back to the role's row.

Keep resume versions in one folder, with the company name in the file name. That way the "resume version" column points to a file you can open before the interview.

When is it worth moving from a spreadsheet to a dedicated tool?

When you're running more than 20-30 active applications at once, sending several resume versions, or still missing follow-ups despite the sheet. That's not a rule - it's the point where maintenance starts to cost more than it gives.

A dedicated tool does three things a sheet doesn't do on its own: it reminds you to act, it links each role to the resume you sent, and it shows every application by stage at a glance. Custro's Application Tracker (on the Pro plan) is built for exactly that. And if your sheet works for you, there's no reason to switch - the method matters more than the tool.

What weekly routine keeps a job tracker up to date?

Fifteen minutes, once a week, on the same day: go through everything in an active stage, send the follow-ups that are due, and update the stages.

• Filter by next-action date - anything overdue gets handled now.
• Update stages based on what happened this week, and move finished ones to Closed.
• Count: applications, first calls, and from which channel. After a few weeks you'll see where your effort pays off - and put more of it there.
• Set next week's target: how many applications, to which companies, and what prep is needed.

If you're starting a search from scratch, pair this routine with the 14-day accelerated plan.