Free Job Application Tracker Spreadsheet: Keep Every Next Step in View
Download a free Excel job application tracker for applications, resume versions, interviews, and follow-ups. Learn what response rates can—and cannot—tell you.
Revised
An interview invitation lands in your inbox, and you cannot remember which resume you sent. The job posting has disappeared, the recruiter mentions a task, and your notes are scattered between bookmarks and email. A job application tracker gives that conversation a history you can actually find.
This free spreadsheet brings applications from different channels into one list. Its most useful column is not the application count. It is the next action: the thing you can do to move an open process forward or close it properly.
Download the free job application tracker
Download the FoxApply job application tracker for Excel.
The workbook includes one worksheet, summary indicators at the top, three clearly labeled fictional examples, and room for 100 editable entries. This is a manual tracker. It does not connect to job boards, check employer portals, or send reminders.
Open the file in Excel, or upload and import it into Google Sheets. Save your own working copy. Delete or replace the sample entries before measuring your real search, because the examples contribute to the totals while they remain in the table. After importing, check that dates are recognized as dates and formulas display calculated results.
For help choosing your search channels, see our guide to job sites.
Set up a record you can trust
Give each distinct vacancy its own row. If you find the same vacancy on several websites, record the channel through which you actually applied instead of counting it repeatedly. Two separate roles at one employer deserve separate entries.
| Field | What belongs here |
|---|---|
| Company and job title | The employer and exact role name |
| Source and job link | Where you submitted the application and the posting URL |
| Application date | The date the submission was completed |
| Resume version | A file name or reference you can retrieve later |
| Stage | A consistent description of the current position |
| Response date | The first substantive update or decision |
| Interview date | The first completed interview date |
| Agreed deadline | A date the employer gave you |
| Next action and date | Your next step and when you plan to take it |
| Notes | Details you will need when returning to the conversation |
Leave the application date blank while a vacancy is only saved or in preparation. Filling it in early makes an intended application look like a completed one.
The stage menu contains “Preparing,” “Applied,” “Assessment,” “Interview scheduled,” “Interview completed,” “Offer,” and “Closed.” For a withdrawal, choose “Closed” and explain in the notes. Adding other options requires editing the validation list.
Use the tracker to prepare, not just to remember
Consider this fictional example. Morgan applies for an operations coordinator role and receives an assessment due on Thursday. The stage becomes “Assessment,” the next action becomes “Review and submit the exercise,” and the action date goes before the deadline. “Waiting” would hide a task that belongs to Morgan.
Another employer says it expects to respond the following week. Morgan records that commitment and plans to review the application afterward. An agreed deadline comes from the employer; a next action date comes from you. If no timeline was given, leave the former empty instead of inventing a promise on the company's behalf.
Keep the posting and submitted resume in a separate folder, using the tracker to record their file names. Job descriptions can disappear before an interview. Our guide to tailoring a resume to a job description explains how to create a relevant version while keeping a reliable master resume.
A weekly review that leads to decisions
Update the row when you apply or receive a message. A date, stage, and short note usually suffice. Choose a regular review window.
Start with interviews and assessments already booked. Check messages requiring a reply from you. Review employer timelines that have passed, and decide whether a follow-up would be useful. Close actions for rejected or withdrawn applications. Finally, choose which saved vacancies deserve your preparation time.
If you are ready to contact an employer, use the application follow-up templates to make the message specific to the stage. A date in your spreadsheet is a prompt to make a decision, not a reason to send repeated messages automatically.
Read the numbers without creating a false benchmark
The summary tracks submitted applications, applications with a response, and applications with a completed interview, together with response and interview rates. Entries need a company, job title, and valid application date to count. Rates stay blank when there are no submissions. Use the same meaning for each date throughout the sheet.
For a response, count a substantive update or decision, including a rejection. A receipt acknowledgment confirms that an application arrived; it does not show that an employer evaluated it. Put that acknowledgment in the notes. Enter the date of the first completed interview; keep future interviews in the stage and next action fields. Record later rounds in the notes.
Response rate = applications with a response ÷ submitted applications. Interview rate = applications with an interview ÷ submitted applications.
In a fictional set of 12 applications, three responses and two interviews would produce a 25% response rate and an interview rate of about 16.7%. These figures demonstrate arithmetic. They are not FoxApply performance claims or targets for your industry.
A rejection can raise your response rate without creating an interview. Recently submitted applications have had less time to receive an answer than older ones. Do not compare those groups as though time, role level, and hiring conditions were identical. Our guide to applications that produce no interviews helps turn the record into questions worth investigating.
Common questions
Should I delete rejected applications? Keeping them preserves useful history and helps prevent duplicates. Update the stage and remove any action that no longer makes sense.
Can I share the spreadsheet? Yes, but review its contents first. Avoid storing passwords, identity documents, or unnecessary personal details about other people. Share only the information your reviewer needs.
Will this send follow-up reminders? No. You update this workbook yourself. If you need reminders, put selected action dates in the calendar you already use.
What if I run out of rows? The formulas cover records through row 116. Start another cycle in a duplicate file, or extend both the table and formula ranges before adding records beyond that row.
For support with the application work itself, explore FoxApply. Keep the spreadsheet as your manual record across channels, and assess product features against the steps you actually need help with.
Source and template authorship
Indeed's guide to tracking job applications discusses recording useful information as you apply. FoxApply created the downloadable workbook, workflow, and fictional examples on this page. Reviewed September 22, 2026.