By Haseeb Kamran, Founder of VeloApply, 8+ years in recruiting · Updated July 24, 2026 · 7 min read
Quick answer: Download the free tracker below, import it into Google Sheets or open it in Excel, and log every application the day you send it. It has a Summary tab that counts your response and interview rates automatically, and it flags anything waiting more than fourteen days so you know what needs a follow-up. No email required, nothing to sign up for.
Key takeaways
- The free template works in both Google Sheets and Excel. Import it, no account needed.
- Ten columns is enough. Company, role, date, source, link, status, last follow-up, next action, notes.
- Days since applied calculates itself and shows closed once a row is marked Offer or Rejected.
- The Summary tab gives you a response rate and an interview rate from your own data.
- Anything past fourteen days without movement is your follow-up list.
- Track the day you apply. A tracker you update weekly stops being accurate within a fortnight.
- Response rate matters more than applications sent. It is the number that tells you whether to change approach.
On this page
Download the free template
Job application tracker
Works in Google Sheets and Excel. Three tabs, formulas already set up, one example row you can delete. Free, no signup.
Download the tracker (.xlsx)There is no email gate on this. Take it, use it, share it with anyone who needs it.
What is in it
| Tab | What it does |
|---|---|
| Applications | One row per application, ten columns, with a Status dropdown and a self-calculating day count |
| Summary | Counts every status and works out your response rate and interview rate automatically |
| How to use | A short legend saying which cells you fill and which fill themselves |
The columns on the Applications tab are company, role, date applied, source, job link, status, last follow-up, days since applied, next action and notes. That is deliberately short. Every extra column is another thing to maintain, and a tracker you stop maintaining is worse than no tracker at all because you start trusting numbers that are out of date.
Days since applied is the one column you never touch. It counts from today's date and switches to closed once you mark a row as Offer or Rejected, so your follow-up list stays clean without you tidying it.
How to use it in Google Sheets or Excel
Google Sheets: open Sheets, choose File then Import, upload the file, and select Replace spreadsheet. The dropdowns and formulas carry across intact.
Excel: just open it. Nothing else to do.
Row 2 is an example, shown in blue. Delete it once you have logged your first real application. The How to use tab explains which cells are yours and which calculate themselves, so you do not accidentally type over a formula.
What to track, and what to ignore
Most trackers people build fail for the same reason: too many columns. Here is what earns its place and what does not.
| Worth tracking | Why | Not worth tracking |
|---|---|---|
| Date applied | Everything else is measured from it | Salary range guesses |
| Source | Tells you which channel actually works | Company size or industry |
| Status | Drives every number on the Summary tab | Colour coding by excitement |
| Last follow-up | Stops you following up twice or never | Full job descriptions pasted in |
| Next action | Turns the sheet into a to-do list | Interviewer names before you have one |
The one habit that matters more than any column: log it the day you apply. A tracker updated once a week is inaccurate by the following Tuesday, and inaccurate data is what makes people abandon trackers entirely.
Reading your own numbers
Once you have twenty or so applications logged, the Summary tab starts telling you something useful. Two numbers matter.
Response rate is the share of applications that moved beyond Applied. If this is very low across a decent sample, the problem is usually upstream of the application itself: the roles you are targeting, or how well your resume matches them. We cover the diagnostic in why you get no response from applications.
Interview rate is the share that reached an interview stage. This is the number worth watching over time, because it responds to changes you make. Applications sent is not, and chasing it is the trap we describe in do auto-apply tools actually work.
Your own numbers beat any published average, because they describe your field, your seniority and your market. If you want the wider context, the Bureau of Labor Statistics publishes openings and hires in its Job Openings and Labor Turnover Survey, but that tells you about the market, not about your search.
When a spreadsheet stops being enough
Honestly, for many searches it never does. If you are sending five applications a week and running a focused search, this template will carry you to an offer without anything else.
It starts to strain in three situations. When you are applying at volume and the logging itself becomes a chore you skip. When you want the record to fill in as you apply rather than after. And when you are checking status across a dozen separate employer portals, which is a problem no spreadsheet solves, as we explain in how to check your application status.
The VeloApply tracker
VeloApply logs applications as you send them, so the record exists without you maintaining it. Company, role, date and link are captured at the moment you apply, and the board view shows where everything stands.
The part that makes the difference is upstream. The Chrome extension reads each application step by step and fills it as it goes, including multi-step Workday forms, and its AI drafts answers to custom screening questions and shows every one for your review. Nothing is submitted until you click submit. The logging is a side effect of applying rather than a separate task you have to remember.
If the spreadsheet is working for you, keep using it. It is free and it is yours. The tool is for the point where maintaining it stops being worth the time.
Stop maintaining the tracker by hand
VeloApply fills applications for your review and logs each one as you send it, so your record stays current without any extra work.
See how it works →Frequently asked questions
Is this job application tracker template really free?
Yes. Download it, use it, share it. There is no email gate, no signup and no trial. It is an ordinary .xlsx file with the formulas already set up.
Does it work in Google Sheets?
Yes. Open Google Sheets, choose File then Import, upload the file and select Replace spreadsheet. The Status dropdown and all the formulas carry across. It also opens directly in Excel with nothing to configure.
What should I track for each job application?
Company, role, date applied, source, job link, status, last follow-up, next action and notes. That is enough. Extra columns are extra maintenance, and the most common reason trackers get abandoned is that they became too much work to keep accurate.
How often should I update my tracker?
Log each application the day you send it, and update a status the day it changes. A tracker updated once a week is already inaccurate by the following week, and inaccurate numbers are worse than none because you act on them.
What is a good response rate on job applications?
There is no reliable universal figure, and any specific number you see quoted usually depends heavily on field and seniority. What matters is your own rate over time: if it is very low across twenty or more applications, the issue is usually the roles you are targeting or how closely your resume matches them.
Do I need an app instead of a spreadsheet?
Not necessarily. For a focused search at moderate volume, a spreadsheet is genuinely sufficient. It strains when logging becomes a chore you skip, when you want the record to fill itself as you apply, or when you are checking status across many separate employer portals.
Keep reading
How to check your application status →
Why you get no response from applications →
How long it takes to hear back →
How many jobs should you apply to per day →
All free job search tools →
Applying on a specific platform?
Workday · Greenhouse · Lever · iCIMS · Taleo · Ashby · SmartRecruiters · BambooHR · JazzHR · Jobvite