A job application tracker turns a scattered search into a manageable workflow. This guide includes an editable spreadsheet layout, follow-up checkpoints, re-application rules, and three reusable email templates so students and entry-level candidates can make informed decisions without losing track of applications.
Overview
Applying for internships, entry-level jobs, part-time jobs, remote jobs, or no-experience roles often involves several different platforms and timelines. One employer may ask for a CV and cover letter, while another uses a short form, screening questions, or a separate candidate portal. Without a central record, it is easy to forget which version of your CV you sent, miss a follow-up opportunity, or apply to the same employer twice without explaining what has changed.
A job application tracker is a simple spreadsheet or database containing one row for each application. It should help you answer five questions quickly:
- What role did I apply for, and where?
- What materials and information did I submit?
- What is the current status and next action?
- When should I follow up?
- Should I reapply, target another role, or close the application?
The aim is not to maximize the number of applications. It is to improve the quality and consistency of your search. A useful tracker makes patterns visible, such as applications that need stronger tailoring, employers that respond slowly, or job types that match your skills more closely.
For a broader comparison of search filters and application quality, see Best Job Boards for Students and Graduates. Use the tracker alongside your preferred job boards rather than relying on memory or browser history.
What to track
Create a spreadsheet in Excel, Google Sheets, or another tool you can access easily. Keep the first row for column headings and freeze it so the labels remain visible. The following layout is a practical job application tracker template:
| Column | What to enter |
|---|---|
| Date found | When you first saved or noticed the vacancy |
| Date applied | The date the application was submitted |
| Employer | Company, school, charity, or organisation name |
| Role and reference | Exact job title and vacancy reference, if provided |
| Location and working pattern | Location, remote, hybrid, shift-based, or part-time details |
| Source | Job board, employer website, careers service, referral, or event |
| Job link | URL to the listing or candidate portal |
| CV version | File name or short label for the CV submitted |
| Cover letter | File name, link, or “not requested” |
| Key requirements | Skills, qualifications, availability, or work samples requested |
| Contact | Recruiter or hiring contact, if one is provided |
| Status | Saved, preparing, applied, screening, interview, offer, rejected, withdrawn, or closed |
| Last contact | Date of your latest message or the employer’s latest update |
| Next action | Follow up, prepare for interview, submit document, or close record |
| Next-action date | The date you plan to take that action |
| Notes | Interview details, feedback, salary range, shift information, or changes |
Use consistent status labels rather than writing a different description in every row. A small dropdown list makes filtering easier. You can also add a priority field, such as high, medium, or low, based on fit, deadline, location, working pattern, and interest.
Record the exact CV version you used. If you update your CV later, do not overwrite the file without keeping a copy of the submitted version. The CV Optimizer Checklist can help you review structure and keywords before starting a new application cycle.
Protect personal information in the sheet. Avoid storing passwords, identity documents, bank details, or sensitive information that is not needed to manage your search. If you share the file with a tutor, careers adviser, or trusted mentor, check the access settings first.
Cadence and checkpoints
A tracker works best when it has a routine. Set aside a short review period two or three times each week while actively searching. During each review, add new opportunities, update statuses, and identify the next action for every open application.
At the time you apply
Save the vacancy link, copy the exact title, record the closing date if shown, and note any promised response time. Save the submitted CV and cover letter with a clear file name, such as FirstName_LastName_Employer_Role_Date. Record whether the application was completed on an employer site or through a third-party platform.
After submission
Check the employer’s instructions before deciding when to follow up. If the listing gives a response date or says that only shortlisted candidates will be contacted, follow that guidance. If no timeframe is provided, a polite status check after roughly one to two weeks may be reasonable for many standard applications. Treat this as a planning guide, not a rule: closing dates, seasonal recruitment, public holidays, high application volumes, and the type of role can affect timing.
Do not send repeated messages every few days. Record each contact in the tracker and wait for a meaningful interval before another message. A single useful follow-up is generally better than several messages that add no new information.
Before an interview
Change the status immediately and record the interview date, format, names of interviewers, and any requested preparation. Create a separate row or linked note for questions, examples, and follow-up tasks. The Interview Preparation Planner is useful for organising STAR examples and role-specific practice.
At the end of each week
Filter the tracker by “next-action date” and complete overdue tasks. Then review applications with no next action. Every open row should either have a clear date and task or be marked closed. This small discipline prevents the spreadsheet from becoming another source of uncertainty.
How to interpret changes
The tracker is not only a diary; it is a feedback tool. Review it after a reasonable sample of applications rather than drawing conclusions from one result.
- Many applications but few acknowledgements: check whether applications are being completed correctly, whether your contact details are accurate, and whether your CV clearly matches the role. Review the cover letter examples by job type if the application asks for a tailored letter.
- Screening calls but no interviews: revisit how you describe your experience, availability, motivation, and examples. Note recurring questions and prepare clearer evidence.
- Interviews but no offers: record feedback where available and compare your preparation, role understanding, and follow-up. Avoid treating rejection as a complete diagnosis when no feedback is provided.
- Good responses from a particular role type: consider focusing more of your search on similar duties, employers, or working patterns.
- Applications repeatedly become unsuitable: update your search criteria. Check commute, schedule, pay expectations, required qualifications, and notice period before applying. A notice period calculator can help when availability affects an application.
When to reapply to a job
Reapply when the role has been posted again and you can show a meaningful change or stronger fit. Examples include new coursework, relevant work experience, a completed project, improved availability, a new qualification, or a substantially better-tailored CV. Reapplying with exactly the same materials and no new information is less useful.
Check whether the new listing is genuinely a new vacancy or simply a refreshed posting. If you previously interviewed, were encouraged to apply again, or received feedback, mention that context briefly and professionally. If you were rejected at an early stage with no feedback, improve the application first and consider targeting a related role that better matches your current evidence.
Do not apply for several unrelated roles at the same employer without a clear rationale. Instead, choose roles that fit your skills and explain your interest in the function or team. Track each application separately while noting the broader employer relationship.
Reusable follow-up and re-application emails
Keep messages short, accurate, and easy to answer. Replace the brackets before sending and use the contact method requested by the employer.
Initial follow-up
Subject: Application follow-up: [Role title] – [Your name]
Hello [Name],
I applied for the [Role title] position on [date] and wanted to confirm that my application was received. I remain interested in the opportunity, particularly because of [specific reason connected to the role]. Please let me know if any further information would be helpful.
Thank you for your time,
[Your name]
[Phone or professional profile, if appropriate]
Status check
Subject: Update on [Role title] application
Hello [Name],
I am writing to ask whether there has been an update on my application for [Role title], submitted on [date]. I understand that recruitment timelines can vary, and I would be grateful for any information about the next stage or expected timing.
Thank you,
[Your name]
Re-application outreach
Subject: Reapplying for [Role title] – [Your name]
Hello [Name],
I noticed that the [Role title] vacancy has reopened and would like to apply again. Since my previous application, I have [specific improvement, such as completed a project, gained relevant experience, or increased availability]. I have updated my CV to reflect this and remain interested in contributing to [team or organisation].
Please let me know if there is anything I should include when submitting the new application. Thank you for considering it.
Best regards,
[Your name]
When to revisit
Review the tracker at the end of every job-search week and complete a deeper review once a month. During the monthly review, archive closed applications, remove expired links, update search priorities, and check whether your CV and cover letter versions still reflect your current skills. If you are a student, revisit the plan before a new term, placement period, internship season, or graduation window. The Internship Application Timeline can help you plan around academic deadlines.
Update your follow-up wording and timing when an employer gives different instructions, when a platform changes its application flow, or when your search priorities change. Revisit the tracker after receiving interview feedback, completing a course, changing your availability, or gaining a new project to include in applications. For part-time or shift-based roles, update hours and commute constraints; the part-time jobs comparison guide provides a useful framework.
To start today, create the columns above, add every active application, assign one status and one next-action date to each row, then schedule your next review. A simple, current record will make it easier to follow up thoughtfully, recognise useful patterns, and decide when to reapply or redirect your search.
