A job application tracker turns a scattered search into a manageable process. This guide shows you what to record, how to build a simple spreadsheet, when to follow up, and how to use an eight-week workflow to improve your applications without losing track of deadlines or contacts.
Overview
Applying for jobs involves more than submitting a CV. You may need to compare roles, adapt application materials, save contact details, prepare for interviews, follow up at an appropriate time, and remember which version of your CV you used. Without a system, it is easy to apply twice to the same role, miss a closing date, forget a useful contact, or send a generic follow-up that does not match the application.
A job search spreadsheet provides one reliable record. It does not need to be complicated. A single sheet in Google Sheets, Excel, or another spreadsheet tool is enough for most job seekers. The aim is not to measure activity for its own sake; it is to make the next useful action visible.
Use the tracker alongside a weekly routine: find suitable job listings, assess them against your goals, submit focused applications, schedule follow-ups, and review the results. If you need a more detailed starting point, see the Job Application Tracker Template. For each role, keep the information needed to answer four questions:
- What is this opportunity, and why does it fit?
- What have I already done?
- What needs to happen next, and when?
- What did I learn from the outcome?
What to track
Start with columns that support decisions and follow-up. You can add detail later, but avoid building a tracker so elaborate that updating it becomes a burden.
Core application fields
- Company and role: Record the employer, job title, department if relevant, and a link to the listing.
- Location and work type: Note the location, remote or hybrid arrangement, employment type, and expected schedule. This is especially useful when comparing remote jobs, part-time jobs, internships, or hourly work.
- Date found and closing date: Add both dates when available. If there is no stated closing date, mark it as “not stated” rather than guessing.
- Application date: Record the date and method of submission, such as an employer site, job board, referral, or email.
- Status: Use consistent labels such as researching, planned, applied, follow-up due, screening, interview, offer, rejected, withdrawn, or closed.
- Next action and next-action date: Write one concrete task, such as “send follow-up,” “prepare examples for customer-service questions,” or “check application portal.”
- Role score: Give the role a simple score, such as 1 to 5, based on fit, interest, practical requirements, and likely value. Define your scale once so that it remains consistent.
Application and networking fields
- CV or resume version: Use a clear filename or version label, such as “CV_CustomerSupport_March” or “GraduateMarketing_V2.”
- Cover letter or message version: Record whether you used a tailored letter, a short application note, or no additional document.
- Contact name and details: Save the recruiter, hiring manager, referral, or other relevant contact only when you have a legitimate reason and permission to use the information.
- Source: Note where you found the opening. This helps you identify which job listings and professional networks produce relevant opportunities.
- Key requirements: Copy the most important skills, qualifications, work pattern, or availability requirement into a short notes field.
- Interview notes: After a call or interview, record the questions asked, examples you used, concerns raised, and any promised next step.
Keep notes factual and brief. Do not place sensitive personal information in a shared spreadsheet, and protect the file with appropriate account and sharing settings. Before applying, assess the listing for unclear duties, unrealistic requirements, pay information, and possible red flags using How to Evaluate a Job Description.
A practical spreadsheet layout
A useful header row might read: Company | Role | Link | Location | Work type | Source | Date found | Closing date | Date applied | Status | Role score | CV version | Contact | Follow-up date | Next action | Notes. Add filters to the header row and sort by “Next action date” at the start of each work session. Use a separate tab for contacts, interview preparation, or reusable follow-up scripts if the main sheet becomes crowded.
Cadence and checkpoints
A tracker works best when it is updated immediately, then reviewed on a predictable schedule. The following eight-week workflow can be repeated during an active search or shortened when you have a pressing deadline.
Weeks 1 and 2: Build the system and define the target
Create the spreadsheet, choose your status labels, and write down the role types you are targeting. Set practical filters for location, working pattern, schedule, experience level, and minimum acceptable conditions. Prepare a small set of CV versions rather than changing the document randomly for every application. If you are applying for entry-level jobs or roles with no experience required, focus on transferable skills, projects, coursework, volunteering, and evidence of reliability. The ATS CV checklist can help you review headings, keywords, formatting, and readability.
Weeks 3 and 4: Apply selectively and record immediately
Set aside regular blocks for sourcing and applications. For each promising listing, score the fit before investing time. Tailor the opening summary and relevant evidence in your CV, then record the exact version submitted. Add the next action as soon as the application is complete. For example, if an employer gives no response timeframe, schedule a polite check-in for about five to seven business days after applying. Treat this as a planning guideline, not a rule: follow the employer’s stated instructions whenever they provide them.
Weeks 5 and 6: Follow up and strengthen relationships
Review all rows marked “follow-up due.” A follow-up should be short, specific, and easy to answer. It should confirm the role, state when you applied, and express continued interest without demanding a response.
After an application:
Subject: Follow-up on [Role Title] application
Hello [Name],
I applied for the [Role Title] position on [date] and wanted to confirm that my application reached the team. My experience with [relevant skill or task] is closely related to the role, and I remain interested in the opportunity. Please let me know if any further information would be useful.
Kind regards,
[Name]
After an interview:
Subject: Thank you for discussing [Role Title]
Hello [Name],
Thank you for speaking with me about the [Role Title] position. I enjoyed learning about [specific responsibility or team priority]. Our discussion reinforced my interest, particularly because my experience with [relevant example] would help me contribute to [relevant outcome]. Please let me know if I can provide anything else.
Kind regards,
[Name]
Send only the follow-ups that make sense. One thoughtful message is generally more useful than repeated requests for an update. If the listing says not to contact the employer directly, respect that instruction and update the tracker accordingly.
Weeks 7 and 8: Review patterns and adjust
Look beyond the number of applications. Count how many applications were suitable, how many produced a screening call, which CV versions were used, and where applications stopped progressing. Review the notes for repeated gaps: missing examples, unclear availability, weak evidence of a required skill, or a mismatch between the role and your expectations. Use those observations to revise your search criteria and materials for the next cycle.
How to interpret changes
The tracker is most valuable when it helps you diagnose the search. If you have many applications but few acknowledgements or screening calls, check whether you are applying to roles that match your experience and whether your CV clearly reflects the stated requirements. Review the entry-level job search playbook if you are relying on broad applications without showing transferable evidence.
If you receive screenings but not interviews, examine how you answer initial questions and whether your salary, schedule, location, or work-authorization expectations are aligned with the listing. If you reach interviews but do not progress, record the questions you found difficult and practise concise examples using a situation, action, and result structure.
If a role’s status remains unchanged for several weeks, do not automatically treat it as an active lead. Mark the next check date, send one appropriate follow-up if permitted, and move the role into a waiting or closed category. This keeps your active pipeline realistic. Also compare opportunities on practical terms, not headline salary alone; a gross-to-net salary guide or other relevant calculator may help you consider deductions and working arrangements before accepting an offer.
When to revisit
Update the tracker after every application, message, interview, rejection, or change in status. Reserve a short daily or every-other-day check for upcoming deadlines and next actions. Complete a deeper review once a week: archive closed roles, reschedule overdue tasks, check that links still work, and choose the priority applications for the next seven days.
Revisit the workflow at the end of each eight-week cycle, or sooner if your circumstances change. Update your target roles after gaining a new qualification, completing an internship, changing availability, or deciding to pursue remote, part-time, retail, graduate, or gig work. Refresh saved search terms and reusable scripts periodically because listings, employer instructions, and platform features can change.
To begin today, create the header row, add every active application, assign one status and one next action to each row, and schedule the first follow-ups. Then choose a weekly review time and protect it in your calendar. A simple, current application tracking system will not replace a strong application, but it can make each one more deliberate and ensure that promising opportunities do not disappear in an untidy inbox.
