# How to track job applications: a simple spreadsheet layout

> Track every job application in one place: the columns to keep, the statuses to use and the weekly check that stops follow-ups from slipping.

Guides, 2 Nov 2026.


To track job applications, keep one row per application with the company, the role, the link to the ad, the date you applied, the current status, the next step and its date, and who you spoke to. Update the row the day something happens. Once a week, sort by the next-step date and act on everything that is due.

That is the whole system. The rest of this guide is the layout we suggest, the statuses that keep it honest, and the point where a spreadsheet stops being enough.

## Why bother tracking at all

A job search with more than a handful of applications gets hard to hold in your head. Recruiters call back two weeks later and you no longer remember which version of your CV they have. An ad you applied to gets reposted and you apply again by mistake. A good lead goes cold because nobody wrote down that you promised to send a portfolio on Friday.

A tracker fixes these with very little effort. It also gives you the numbers you need when the search is not working: how many applications you sent, how many got a reply, and where they stall.

## The spreadsheet layout

Create one sheet in Google Sheets, Excel or Numbers. One row is one application. These are the columns we suggest, in this order:

| Column | What goes in it | Example |
|--------|-----------------|---------|
| Company | The employer, as the ad names it | Northwind Logistics |
| Role | The job title from the ad | Senior Data Analyst |
| Link | The ad on the company's careers page if you can find it, otherwise the board | https://... |
| Source | Where you found it | Careers page, LinkedIn, referral |
| Date found | When you saw the ad | 2026-11-03 |
| Date applied | Empty until you actually apply | 2026-11-04 |
| Status | One word from the list below | Applied |
| Next step | The single next action, yours or theirs | Follow up by email |
| Next step date | When that action is due | 2026-11-14 |
| Contact | Recruiter or hiring manager, and how you reached them | Anna K., recruiter, email |
| Pay | The range from the ad, or what the recruiter told you | 18-22k PLN gross |
| CV version | The file name of the CV you sent | cv-data-analyst-northwind.pdf |
| Notes | Anything you will want to remember before a call | Team of 6, uses dbt |

Freeze the top row and turn on a filter for the Status column. That is all the setup a spreadsheet needs.

Two columns matter more than they look. **CV version** saves you when a recruiter quotes a line from your CV and you sent a different one to five other companies. **Next step date** is what turns a list into a to-do list.

## Statuses to use

Keep the list short. Each status should mean one thing, so a filter on it tells you something.

1. **Interested**: you want to apply but have not yet.
2. **Applied**: the application is sent.
3. **Interview**: at least one call or meeting is booked or done.
4. **Offer**: you have an offer in writing.
5. **Rejected**: the employer said no.
6. **Closed**: you withdrew, or the ad went quiet and you stopped waiting.

Use **Closed** without guilt. Many applications never get an answer, and a row stuck on Applied for two months makes your active pipeline look bigger than it is.

## How to keep it up to date

1. Add the row when you decide to apply, not after. Fill in Company, Role, Link and Date found.
2. Save the ad text somewhere (a PDF or a copy in Notes). Ads get taken down, and you will want it before the interview.
3. When you apply, set the status to Applied, fill in Date applied and CV version, and set a Next step date about a week out.
4. Every time a recruiter writes or calls, update Status, Contact and Next step on the same day.
5. Once a week, sort by Next step date. Send the follow-ups that are due, and move anything with no reply after your second follow-up to Closed.
6. Once a month, count rows by status. If you have many applications and few interviews, the problem is in the applications, not in your effort (our guide on [why you are not getting interviews](/guides/why-no-interviews) goes through the usual causes).

## When a spreadsheet stops being enough

A spreadsheet works well up to a few dozen active rows. Past that, three things start to hurt:

- Copying each job into the sheet by hand takes longer than reading the ad.
- You cannot see which ads are reposts of roles you already applied to.
- The history of each application (what you sent, who said what, when) ends up in a Notes cell nobody can read.

That is why we built the [job application tracker](/tools/job-application-tracker) in gojob.now. Every job you find there already has a row. It moves through the same stages (New, Interested, Applied, Interview, Offer, plus Rejected and Not interested), keeps the CV and cover letter you sent next to it, and records every status change with its date. The Funnel tab counts how many jobs reach each stage and how many days each step takes. The tracker is free, with no card needed.

If you keep a spreadsheet, keep it. The layout above works on its own, and the habit matters more than the tool.

## FAQ

### What is the minimum I need to track?

Company, role, link, date applied, status and next step date. Without the next step date you have a list; with it you have a plan.

### Should I track jobs I have not applied to yet?

Yes, with the status Interested. It stops you from losing a good ad, and it shows whether you are finding more roles than you have time to apply to.

### How long should I wait before following up?

We suggest one polite follow-up about a week after you apply, and a second one a week later if the role still matters to you. After that, mark it Closed and move on.

### Is there a free job application tracker template?

The table above is the template: copy the column names into a new sheet. If you would rather not keep it by hand, the gojob.now [job application tracker](/tools/job-application-tracker) is free.

### How many applications should I track at once?

As many as you can follow up on properly. If the weekly check takes longer than an hour, you are applying to too many roles that do not fit, and a [match score](/tools/job-match-score) can help you drop the weaker ones early.