How to build a job application tracker in Google Sheets, Excel or Notion
A job application tracker is a list of every role you applied to, where each one stands, and what you do next. For most people, a spreadsheet in Google Sheets or Excel is enough. Notion helps when you want each company's posting, notes and interview prep in one place. Either way, a tracker rarely fails because of the tool. It fails because of the follow-up you forgot.
For years, before ChatGPT, I tracked my own applications in a very elaborate Excel file, with VBA macros, because no tool I tried did what I needed. That file is the ancestor of Raise. Here is what it taught me, for Google Sheets, Excel and Notion.

What columns should a job application tracker have?
The same base works in a spreadsheet and in Notion. Nine columns are enough:
| Column | Why |
|---|---|
| Company | To group several roles at the same employer. |
| Job title | The exact title from the posting, not your summary of it. |
| Link to the posting | To find it again. Copy its text too: postings are often taken down once the role is filled, and you will need it to prepare for the interview. |
| Source | Career page, job board, referral: to see what works for you. |
| Date applied | The starting point of any follow-up. |
| Stage | A short, fixed list: spotted, applied, interview, offer, rejected. |
| Next step and its date | The most important column. An active application with no next-step date is an application you will forget. |
| Contact | Name and role of the person handling the hiring, if you know them. |
| Notes | Advertised salary, things to check, impressions after a call. |
That is also the free template: type these nine headers into the first row of a blank sheet.
How to build a job application tracker in Google Sheets or Excel
What works.
- It's fast: a blank sheet and the nine columns above, and you're ready.
- It's free: Google Sheets with a Google account, Excel for the web with a Microsoft account.
- Sorting and filtering are instant: every application at the "interview" stage, or every one from the same source.
- Simple formulas count your applications at each stage.
What doesn't.
- One row per application handles long notes badly: interview prep doesn't fit in a cell.
- Nothing reminds you on a given date. The best a spreadsheet can do is color a row.
- Typing on a phone is tedious.
The formula that flags overdue follow-ups. Select your rows and add a conditional formatting rule based on a custom formula. If the next-step date is in column G, paste this formula, which works in both Google Sheets and Excel:
=AND($G2<>"",$G2<TODAY())
Every row whose follow-up date has passed changes color. Google Sheets and Excel explain where to add the rule.
How to track job applications in Notion
What works.
- One database, shown in several ways: a table, a board with one column per stage, a calendar of follow-ups.
- One page per application, where you keep the posting, your notes, your exchanges and your interview prep.
- A reminder on a date: Notion notifies you on the day of the follow-up.
- Ready-made trackers in Notion's job search templates.
What doesn't.
- Setting it up takes longer, even with a template.
- The temptation to polish the tool instead of applying.
- Counts and filters are less direct than in a spreadsheet.
Google Sheets, Excel or Notion: side by side
| Google Sheets or Excel | Notion | |
|---|---|---|
| Setup | A few minutes | Longer, even with a template |
| Price | Free (Google Sheets, Excel for the web) | Free plan for personal use |
| Overview | Sorting and filters | Table, board by stage, calendar |
| Notes per application | One cell | A full page |
| Follow-up reminder | No: a color, at best | Yes, on a date |
| Counts (applications per stage…) | Simple formulas | Possible, less direct |
| Best for | A few applications, moving fast | Detailed prep, company by company |

The real trap: the follow-up
Whatever the tool, three habits make the difference:
- A next-step date on every active application. Set it when you apply, based on what the posting or the recruiter says (deadline, hiring timeline).
- A fixed weekly slot to review the list, ideally on the same day.
- Archive instead of deleting. A rejection is information: at which stage, for which kind of role, from which source.
When should you switch to a dedicated job tracker?
A spreadsheet and Notion share the same limit: they track applications, but they don't find the jobs. A dedicated tool becomes useful when:
- you track too many applications to keep up with follow-ups by hand;
- you spend more time looking for jobs than tracking them;
- you are preparing several interviews at once.
Two examples, with different approaches:
- Teal: a free job tracker with a Chrome extension (Teal's pricing page and its Chrome Web Store listing, read in September and October 2026).
- Raise, the app I built from that spreadsheet: it reads the career pages of more than 500 companies every morning, groups duplicate postings and tracks each application stage by stage. Applications sent with no news for more than 10 days appear on your home page, to follow up, and you can ask Raise's assistant what to follow up. It sends no reminders. Raise also prepares your interviews from the job posting, with a written mock interview. It runs in a desktop browser, with a free plan, and access is by waitlist for now.
Frequently asked questions
Is there a free job application tracker template?
Yes. The nine columns in this guide are a template: type them into the first row of a blank sheet. Notion's template gallery also has ready-made job trackers.
Can I make a job application tracker in Google Sheets for free?
Yes. Google Sheets is free with a Google account. Create the nine columns, add the overdue follow-up formula as a conditional formatting rule, and you have a working tracker.
Excel or Google Sheets: which is better for a job tracker?
For a tracker, both do the job. Google Sheets works in any browser and syncs with your phone; Excel works offline and handles bigger files. Pick the one you already use.
Should you keep rejected applications?
Yes, archived. They show which sources and which kinds of roles take you furthest, and they stop you from applying again, by mistake, to a role that already turned you down.
How long should you wait before following up?
There is no official delay. The safest approach is to set the follow-up date as soon as you apply, based on what the posting says, and to write it in your tracker: the forgotten date, more than the delay you pick, is what loses applications.