Job application tracker: a free spreadsheet layout you can build in minutes

Q: What is a job application tracker?

A job application tracker is a single list where you record every application you submit. Each row holds the company, the role, where you found it, when you applied, and what comes next. It gives you one place to see the state of your whole search.

Q: What should a job application tracker include?

At minimum, include the company, the role, the job link, the date you applied, the status, and the next step with its date. Contact names, the resume version you sent, and notes make the tracker more useful. Every open row should have a next step and a date.

Q: Is there a free job application tracker template?

Yes. The layout on this page is free: copy the header row into a new Google Sheet and add one row per application. You can also start from a blank sheet with the columns listed above.

Q: How do I make a job application tracker in Google Sheets?

Paste the header row into cell A1 of a new Google Sheet and choose Data, then Split text to columns. Freeze the header row, add a dropdown for the Status column, format the two date columns as dates, and turn on a filter. The full steps are in the section above.

Q: How often should I update my job application tracker?

Update it whenever something changes, such as an application you submit, a reply you receive, or an interview you schedule. Then review the whole list once a week. The weekly review is what keeps the next steps moving.

Q: Should I use a spreadsheet or an app to track job applications?

A spreadsheet is free, flexible, and easy to back up, and it works well for most searches. An application tool can add automation and reminders. Choose whichever you will actually keep updated, because an outdated tracker loses its value.

The short answer

Keep one row per application. Record the company, the role, where you found it, when you applied, who you know there, the status, the next step, and its date. Review the list once a week. The next step column is the one that keeps a search moving.

The columns

Column	What to put in it	Why it matters
Company	The organization hiring for the role.	Groups your outreach and shows where your effort is going.
Role title	The exact title as it appears in the job advertisement.	Keeps similar roles apart when one company hires more than one.
Job link	The full web address of the advertisement.	Lets you reread the requirements without searching for them again.
Date applied	The day you submitted the application.	Shows when a follow-up is due and how long each step is taking.
Source	Where you found it: a job board, the company site, a recruiter, or a referral.	Shows which sources deserve more of your time.
Contact or referrer	The name of anyone you know at the company, or the person who referred you.	Reminds you who to thank and who can speak for you.
Status	One value from the list in the next section.	Makes the list sortable and honest at a glance.
Next step	The one action that moves this application forward, in plain words.	Turns a waiting row into a planned action.
Next step date	The day you will take that action, or the day a promised reply is due.	Makes overdue items visible instead of forgettable.
Resume version sent	Which resume, and which cover letter, you sent.	Lets you talk about the same document they have in front of them.
Notes	Anything worth remembering: names you met, questions asked, timelines given.	Saves details that never fit in any other column.

The header row, ready to paste

Copy the line below into cell A1 of a new Google Sheet, then choose Data, then Split text to columns. The names match the table above exactly, and the commas have no spaces after them so that each column name splits cleanly. Or download the same layout as a spreadsheet file: job application tracker template.

Paste into cell A1, then choose Data, then Split text to columns

Company,Role title,Job link,Date applied,Source,Contact or referrer,Status,Next step,Next step date,Resume version sent,Notes

Status values that keep the list honest

Saved: you are considering it, and you have not applied yet.
Applied: the application is in.
Recruiter screen: an initial conversation has happened or is scheduled.
Interviewing: you are past the screen and in the interview rounds.
Final round: the last conversations, often with senior leaders.
Offer: an offer has been made.
Rejected: the company said no.
Withdrawn: you stepped away.
No response: the process went quiet and nobody replied to your follow-up.

Two rules keep the list honest: every open row has a next step and a date, and a row leaves the active list only when the process has ended: an offer accepted or declined, Rejected, Withdrawn, or No response. Closed rows move to an archive tab rather than disappearing.

Building it in Google Sheets

Freeze the header row. Choose View, then Freeze, then 1 row, so the column names stay visible while you scroll.
Turn the Status column into a dropdown. Select the Status cells, choose Data, then Data validation, then add a rule with the criteria Dropdown, and list the status values from the section above.
Set the two date columns to a date format. Select both date columns, then choose Format, then Number, then Date.
Highlight overdue follow-ups. Choose Format, then Conditional formatting, and add a custom formula that compares the Next step date column with TODAY(). With the columns in the order above, apply the rule to the range A2:K1000 and use the formula =AND($I2<>"",$I2<TODAY()), so a passed date colors the whole row.
Turn on a filter. Choose Data, then Create a filter, so you can sort by next step date.

The same layout works in Excel, with equivalent commands under its Data and Format menus.

A weekly review routine

Sort by next step date, so the rows that need action this week sit at the top.
Follow up wherever a promised timeline has passed.
Move closed rows to an archive tab, so the active list stays short.
Note which sources lead to interviews, and spend your search time there.
Save the full text of each job description, because postings are often taken down before the interviews happen.

Worth tracking for senior roles

The recruiter or search firm, and their contact details.
The compensation range discussed, so you can compare offers fairly.
Who referred you, so you can thank them and keep them informed.
Which resume and cover letter you sent, so your later conversations match what they read.
The names of everyone you met, from the first screen to the final round.
The date you sent each thank-you note.

Common mistakes

Too many columns to keep up to date. Start with the eleven above, and add more only when you use them.
Rows with no next step, which are the ones that quietly stall.
Not recording which resume you sent, which makes interview preparation harder.
Losing the job description, which you will want again when an interview is scheduled.
Never reviewing the list, which turns the tracker into a diary instead of a plan.

FAQ

What is a job application tracker?

A job application tracker is a single list where you record every application you submit. Each row holds the company, the role, where you found it, when you applied, and what comes next. It gives you one place to see the state of your whole search.

What should a job application tracker include?

At minimum, include the company, the role, the job link, the date you applied, the status, and the next step with its date. Contact names, the resume version you sent, and notes make the tracker more useful. Every open row should have a next step and a date.

Is there a free job application tracker template?

Yes. The layout on this page is free: copy the header row into a new Google Sheet and add one row per application. You can also start from a blank sheet with the columns listed above.

How do I make a job application tracker in Google Sheets?

Paste the header row into cell A1 of a new Google Sheet and choose Data, then Split text to columns. Freeze the header row, add a dropdown for the Status column, format the two date columns as dates, and turn on a filter. The full steps are in the section above.

How often should I update my job application tracker?

Update it whenever something changes, such as an application you submit, a reply you receive, or an interview you schedule. Then review the whole list once a week. The weekly review is what keeps the next steps moving.

Should I use a spreadsheet or an app to track job applications?

A spreadsheet is free, flexible, and easy to back up, and it works well for most searches. An application tool can add automation and reminders. Choose whichever you will actually keep updated, because an outdated tracker loses its value.

Vantage Role is built for senior professionals and executives. It keeps your applications in one dashboard, with a personalized brief on what to do next.

Get started