Free Job Application Tracker for Google Sheets and Excel
by Patrick Da Costa Guimarais • Last Updated 9/3/2026
Once you are applying to several roles, it becomes easy to forget which resume you sent, who replied, or when to follow up. This free job application tracker keeps those details in one place and shows what needs attention next.
Use the native Google Sheets version in your browser or download the Excel workbook. Both versions include the same application log, follow-up reminders, pipeline dashboard, and editable dropdowns.
Get the free job application tracker
Both versions are free. There is no email gate, and the formulas are not locked.
What the tracker helps you answer
A useful tracker should tell you:
Did I already apply to this company?
What stage is the application in now?
What is the furthest stage it reached?
Who should I contact, and when?
Which sources and resume versions lead to conversations?
The workbook has four tabs. Applications holds one row per role. Dashboard summarizes the pipeline and weekly activity. Read Me explains the workflow. Lists contains the editable dropdown choices.
The Applications tab includes 500 prepared rows, filters, frozen headers, date and currency formatting, follow-up flags, and visual signals for high-priority, interview, offer, accepted, and rejected roles.
Set it up in five minutes
Open the Google Sheets copy or download the Excel workbook.
Replace the three sample rows with applications from your current search.
Add saved roles before their job descriptions disappear.
Record the application date, resume version, contact, and next action as soon as you apply.
Check the Dashboard once a week and work from the follow-ups that are due.
Save a separate copy of important job descriptions. Employers often remove or revise a posting before the interview process ends.
The fields worth keeping current
Status and highest stage reached
Status shows where the application is now: Saved, Applied, Recruiter Screen, Interviewing, Assessment, Offer, Accepted, Rejected, Withdrawn, or Closed.
Highest Stage Reached preserves the furthest point in the process. If you interview and later receive a rejection, set Status to Rejected but leave Highest Stage Reached as Interviewing. That keeps the Dashboard conversation rate accurate.
Follow-up dates
Next Follow-Up is the next date you plan to act. The Follow-Up Due? column flags an active application when that date arrives, including roles at the applied, recruiter-screen, interview, and assessment stages.
When you send the message, enter the date in Last Follow-Up Sent. The Dashboard uses that field to count completed follow-ups for the week.
If you need help deciding what to send, use these messages for following up with a hiring manager. Respect any instruction in the job posting that asks candidates not to contact the company.
Resume version, contact, and job URL
Record the exact resume file submitted, such as product-ops-v3.pdf. This lets you compare which positioning produces recruiter conversations. Before submitting, check the file against LifeShack's guide to common ATS resume mistakes.
Add the recruiter, hiring manager, or referrer in Contact. Keep the direct job URL in the tracker, but save the description separately when the role matters.
Salary, next event, and notes
Use Salary Min and Salary Max for the advertised or discussed range. Do not mix annual and hourly figures without noting the unit.
Next Event Date can hold the next recruiter call, interview, assessment deadline, or decision date. Put preparation notes, time zones, and interview details in Notes. For structured practice, compare LifeShack's interview preparation tools.
How the formulas work
Days Since Applied stays blank until you enter an application date, then updates each day:
=IF($G6="","",TODAY()-$G6)
The follow-up flag checks Next Follow-Up against today's date and ignores saved, accepted, rejected, withdrawn, and closed roles.
Conversation Rate divides applications that have ever reached Recruiter Screen or later by all rows with an application date. The calculation uses Highest Stage Reached, so recording a final rejection does not erase an earlier interview.
Two weekly goals update automatically: high-fit applications and completed follow-ups. Networking conversations and interview-preparation sessions are manual fields because those activities happen outside the application log.
A practical review routine
Update the tracker after an application, reply, interview, follow-up, or decision. A clean row should take less than a minute to maintain.
Once a week, spend 15 minutes on five questions:
Which follow-ups are due now?
Are high-priority roles getting enough attention?
Which sources are producing recruiter conversations?
Is one resume version performing better than the others?
Are saved roles accumulating faster than you can process them?
Treat small samples carefully. One interview does not prove that a source or resume is superior. Look for a repeated pattern before changing your search.
If applications keep going quiet, use LifeShack's four-step plan for the job application black hole to decide when to follow up and when to move on.
When a spreadsheet stops being enough
A spreadsheet works well when you are choosing roles manually and can keep the rows current. Consider application automation when you have clear job criteria, an accurate profile, and more relevant openings than you can process yourself.
LifeShack AI Auto Apply finds roles that match your preferences, prepares supported applications, submits them, and records the activity. You can keep using this tracker for referrals, dream roles, and other applications that deserve more personal attention.
Frequently asked questions
Is the job application tracker free?
Yes. The Google Sheets copy and Excel download are free, with no email required.
Should I use Google Sheets or Excel?
Use Google Sheets if you want browser access, easy sharing, and a native cloud copy. Use Excel if you prefer a local workbook or already manage your search in Microsoft 365.
How often should I update the tracker?
Update it after each meaningful event, then review the Dashboard once a week. Waiting several weeks makes follow-up dates and pipeline data much less useful.
Why are Status and Highest Stage Reached separate?
Status records where the application is now. Highest Stage Reached preserves how far it progressed. Keeping both lets you close a role without losing accurate conversion data.
Can the tracker remind me to follow up?
It flags dates that are due inside the workbook. It does not send email or calendar notifications, so add an external reminder for time-sensitive interviews or deadlines.