A job application tracker turns a scattered search into a manageable process. Use the spreadsheet layout below to record every application, protect important deadlines, prepare for interviews, and follow up consistently without relying on memory or searching through old emails.
Overview
When you apply for several roles at once, small details become easy to lose: which CV version you sent, whether an employer requested a portfolio, when a screening call is scheduled, or when it is appropriate to send a follow-up. A job search spreadsheet gives you one reliable place to store those details.
The aim is not to create unnecessary administration. A useful tracker should help you answer five questions quickly:
- Which roles have I applied for?
- What action is needed next, and by when?
- What information did I provide to each employer?
- Where does each application currently stand?
- What patterns can improve my search?
You can build the tracker in a spreadsheet, notes application, database, or task manager. The format matters less than keeping the information current and easy to review. If you are applying for internships, start with an application timeline such as the one in this internship search and application guide. For entry-level roles, a tracker works particularly well alongside a structured no-experience job search plan.
What to track
Begin with one row per job application. Avoid adding so many fields that updating the sheet becomes a burden. The following columns cover the information most applicants need.
Core job application tracker columns
| Column | What to record |
|---|---|
| Employer | The company, school, organisation, or client name. |
| Job title | The exact title used in the listing. |
| Location and work type | Location, remote, hybrid, onsite, part-time, contract, or gig work. |
| Job listing link | The original advert or employer careers page. |
| Date found | When you first identified the opportunity. |
| Application date | When you submitted the application. |
| Closing date | The stated deadline, if one is provided. |
| CV or resume version | The filename or version used for this application. |
| Cover letter or portfolio | Record whether one was required and which version you sent. |
| Contact person | Name, role, email address, or recruiter profile when available. |
| Status | The current stage of the application. |
| Next action | The specific task you need to complete. |
| Next-action date | The date you plan to complete that task. |
| Notes | Key requirements, questions, salary details, or communication history. |
Use consistent status labels so that filtering works properly. A practical set is: To review, Ready to apply, Applied, Follow-up due, Screening, Interview, Assessment, Offer, Rejected, Withdrawn, and Closed or no response. Choose one label per row rather than combining several stages in the same cell.
Useful optional fields
Add optional columns when they support a decision or action. These might include required qualifications, your match rating, expected working hours, pay information, notice period, interview format, and the reason you saved the role. If you are comparing offers, keep compensation notes separate from assumptions and use a gross-to-net salary guide to distinguish advertised pay from estimated take-home pay. If a role depends on your availability, record your likely start date and check it with a notice period calculator guide.
For each communication, record the date, channel, person, and outcome. A short note such as “sent availability for Tuesday call” is more useful than a vague entry such as “contacted employer.” Never store passwords or sensitive identity documents in the tracker.
Cadence and checkpoints
A tracker is most effective when it is reviewed at predictable intervals. Use the following routine as a starting point and adjust it to your search.
When saving a job
- Copy the original listing link and note the closing date.
- Check whether the role fits your location, schedule, eligibility, and experience.
- Record the main requirements and identify any missing information.
- Set a realistic application deadline before the employer’s closing date when possible.
When submitting an application
- Save the submitted CV, cover letter, portfolio, or application answers with a clear filename.
- Change the status to Applied and enter the submission date.
- Record any confirmation number or automated acknowledgement.
- Set a follow-up review date based on the communication you received and the employer’s instructions.
Weekly review
Once a week, filter the sheet by next-action date. Complete overdue tasks first, then review applications that have been inactive for several days or weeks. Check for duplicate applications, expired listings, and interviews that need preparation. A weekly review should end with a short priority list rather than an attempt to update every note perfectly.
Follow-up schedule
Follow the employer’s stated process before sending a message. If no timeframe is given, a polite follow-up after a reasonable interval may be appropriate, but avoid repeated messages in quick succession. Use a simple sequence:
- First contact: Record the application or interview date and any promised response time.
- First follow-up: Send one concise message after that timeframe has passed, if appropriate.
- Final check: If there is still no response, mark the application for later review rather than chasing indefinitely.
Keep messages professional and specific. Mention the role, date of application, and your continued interest. Do not treat silence as a definite rejection unless the employer communicates that outcome; instead, use a neutral status such as Closed or no response.
How to interpret changes
The tracker is not only a record of activity. Over time, it can show where your search needs adjustment. Review the data without treating any single application as a verdict on your ability.
- Many saved roles but few applications: Your screening criteria may be too broad, or you may be spending too long tailoring each application. Set a decision deadline for moving a suitable listing from “To review” to “Ready to apply.”
- Many applications with no invitations: Recheck whether your CV clearly reflects the requirements. Compare keywords and evidence in the listing with your application. This ATS CV checklist can help you review structure and relevance.
- Invitations but weak interview progression: Add interview notes, questions you found difficult, and examples you want to improve. Prepare role-specific answers rather than repeating generic scripts.
- Frequent missed deadlines: Reduce the number of active applications or create earlier personal deadlines. A shorter, current list is easier to manage than a large backlog.
- Interest concentrated in one type of role: Compare the skills, hours, and requirements across those listings. This may help you focus your search or identify a useful training gap.
Use simple categories such as role type, industry, work arrangement, and application source to spot patterns. For example, you may discover that remote roles require more research, while local part-time roles move faster. These observations should guide your next actions, not limit your options permanently.
When to revisit
Update the tracker whenever you apply, receive a message, schedule an interview, or complete a follow-up. Set aside a weekly checkpoint for active applications and a monthly or quarterly review for the system itself.
During the monthly review, archive closed roles, remove broken listing links, standardise inconsistent status labels, and check that your CV filenames still match the versions you use. Review the fields as well: remove columns you never consult and add a field only when it leads to a clearer decision. If you use multiple job boards, confirm that each new application is entered once and that the source is recorded consistently.
Revisit your follow-up approach whenever an employer gives different instructions, your target sector changes, or you begin applying across countries or employment types. Communication norms, application portals, and document requirements can vary, so rely on the specific listing or employer message rather than assuming every process is the same.
To put the tracker into use today, create the columns above, enter your current applications, and sort by next-action date. Mark the three most important tasks, prepare any missing documents, and schedule your next weekly review. For remote applications, also use this remote job screening checklist to record whether the opportunity appears legitimate before investing more time.