How to Track Job Applications Without Losing Control of Your Search

Ten applications in, most people can still remember where they applied. By thirty, the details blur: which CV went to which company, who you spoke to, and whether the recruiter said "end of the month" or "early next month". Tracking your job applications fixes that, and it tells you something more useful as well: which part of your search is actually working.

This guide shows you how to track job applications in a way that takes minutes a week. You will get the fields worth recording, a simple status system, step-by-step instructions for a Google Sheets or Excel tracker, and a weekly review that turns your records into decisions. If you would rather not build anything, there is also an honest comparison of spreadsheets and dedicated job application trackers.

Quick answer

Keep every application in one place, one row per role. Record the role, company, link, date applied, CV version, status, next action and the date that action is due. Update the row as soon as anything changes. Once a week, spend 15 minutes checking how many applications led to a reply and an interview, and change one thing based on what you see.

---

Why tracking job applications matters more than it seems

A tracker is not admin for the sake of it. It solves four problems that quietly cost people interviews:

• Missed follow-ups. A polite chase a week or two after the closing date is often the difference between a forgotten application and a conversation. You can only chase what you remember.
• Unprepared phone calls. When a recruiter rings three weeks later, you need the advert and the CV you sent in front of you. Adverts are often taken down after the closing date, so if you did not save them, you are guessing.
• Duplicate applications. Applying to the same role directly and through a recruitment agency can create confusion about who introduced you. A quick search of your tracker before you apply prevents it.
• No feedback loop. Without numbers you cannot tell whether silence comes from your CV, your choice of roles or simple timing. With them, you can.

Want to skip the setup? Cafy's job application tracker is ready to use and unlimited on the free plan.

---

What to record for each application

Start with eight core fields. Add optional fields only if you will genuinely use them, because every extra column is something you have to keep up to date.

Core fields for a job application tracker. The example details are invented.

Useful optional fields include the closing date, salary range, location or hybrid pattern, notes from calls, and any essential requirement you did not fully meet. That last one is surprisingly valuable when you review your results later.

Tip

Save the job description when you apply. Paste the key requirements into your notes or save the page as a PDF. When you are invited to interview, you will want to prepare against the exact wording the employer used.

---

Use clear status stages

A tracker only works if each status means one thing. These stages cover almost every UK application process:

1. Saved: you plan to apply. Record the closing date.
2. Applied: submitted. Set a follow-up date.
3. In assessment: online tests, a phone screen or a recorded video interview.
4. Interview: a live interview or assessment centre is booked or done.
5. Offer: you have a verbal or written offer.
6. Closed: rejected, withdrawn by you, or no response.

Decide in advance when an application counts as "no response". A practical rule is three to four weeks after the closing date, or after you applied if there was no closing date, with one polite follow-up in between. Marking it closed is not giving up. It simply stops a silent application from distorting your numbers and your mood.

---

How to build a job application tracker in Google Sheets or Excel

A spreadsheet tracker takes about 20 minutes to set up. Both Google Sheets and Microsoft Excel support everything below.

Step 1: Create the columns

In row 1, add these headings from column A to column L: Role, Company, Link, Source, Date applied, CV version, Status, Next action, Due date, Notes, Response (Y/N), Interview (Y/N). Freeze the top row so the headings stay visible as you scroll.

Step 2: Add a status dropdown

Select column G. In Google Sheets, open Data, then Data validation, and add a dropdown with your stages. In Excel, open Data, then Data Validation, choose List and type the stages separated by commas. A dropdown keeps your wording consistent, which matters when you count results.

Step 3: Highlight overdue actions

Select the due date range, for example I2:I500, and add a conditional formatting rule that uses a custom formula:

=AND($I2<>"", $I2<TODAY())

Give it a strong fill colour. Every overdue follow-up now stands out when you open the file.

Step 4: Add a small summary block

Mark column K with Y when an application gets a real reply from a person (an automated acknowledgement does not count), and column L with Y when it leads to an interview. Then add three formulas somewhere visible:

• Applications sent: =COUNTA(E2:E500)
• Response rate: =COUNTIF(K2:K500,"Y")/COUNTA(E2:E500)
• Interview rate: =COUNTIF(L2:L500,"Y")/COUNTA(E2:E500)

Format the two rates as percentages. They are the numbers you will review each week.

Step 5: Sort by due date

Sort by column I before each session so the next actions sit at the top. Archive closed applications to a second tab once a month to keep the main sheet short.

---

Spreadsheet or dedicated tracker: which should you use?

Both work. The right choice depends on how many roles you apply for and how much manual copying you are willing to do.

Spreadsheet compared with a dedicated job application tracker.

If you apply to only a few carefully chosen roles a month, a spreadsheet is usually enough. Once you are saving roles from several job boards every week, the copying becomes the reason trackers go stale, and a tool that captures the details for you starts to pay off.

Prefer not to build a spreadsheet?

Cafy's job application tracker is unlimited on the free plan, with no card needed. Save roles from 50+ job boards with the Chrome extension (5 uses on the free plan, unlimited with Premium), move each application from saved to applied, interview and offer, and see follow-up deadlines and your interview and offer rates in one dashboard.

Start tracking free or see how the tracker works

---

The 15-minute weekly review

Tracking pays off when you use it to decide what to change. Once you have sent around 15 to 20 applications, look at your numbers every week and match them to the most likely cause.

What your tracker numbers can tell you.

If silence is your main problem, our article on why UK job applications get no reply walks through the most common causes in more depth.

Change one thing at a time. If you rewrite your CV, change your target roles and switch job boards in the same week, you will not know which change made the difference.

---

Common tracking mistakes to avoid

• Recording only submitted applications. Saved roles with closing dates belong in the tracker too, or deadlines slip past.
• Forgetting the CV version. Preparing for an interview without knowing what the employer read is avoidable stress.
• Counting automated emails as responses. Only a reply from a person, or an invitation to the next stage, tells you your application landed.
• Tracking twenty fields. A tracker you will not update is worse than a short one you keep current.
• Leaving old applications open forever. Close them on your agreed date so your numbers reflect reality.

---

Start small, then let your numbers guide you

You do not need a perfect system to benefit from tracking. Set up the eight core fields today, update them as you go, and give yourself 15 minutes each week to read the numbers. Within a month you will know whether your CV, your choice of roles or your interview preparation deserves your attention, and you will never again have to ask a recruiter which job they are calling about.

---

Keep every application in one place

Save roles while you browse, see what needs a follow-up and watch your interview rate change as you improve. The tracker is free and unlimited.

Start tracking free or compare plans

No card needed. Cancel any paid plan at any time.