On this page
Job application tracking means recording where you applied, what happened and what to do next. Use one row per role, with a next action and review date.
Keep the first version small
This guide is about your own job-search record. An employer’s applicant tracking system is different: it manages applications for the hiring team. Your spreadsheet doesn’t show their live decisions or send an application for you. If an employer provides a candidate portal, check it for the updates available there, then record what you actually saw.
A tracker should help you resume your search without reconstructing every conversation. Start in a spreadsheet you already use. Put the employer, exact role and original vacancy URL in each row, then add status, last confirmed event, next action and review date.
Use one row for each distinct vacancy. Two roles at the same employer need separate rows; the same role found on two job boards usually needs one. A vacancy reference helps you spot the difference. Save links to your submitted CV or confirmation only if they are useful, and keep the sheet private.
Paste this into your spreadsheet
Download the editable application tracker (.xlsx), then open it and save a copy for your search. The Tracker sheet has blank rows; Examples contains three fictional entries, and Instructions explains the fields. You can also copy the tab-separated starter below into your own spreadsheet.
The starter uses tabs between columns. Paste into the top-left cell of a blank sheet. If the values appear in one column, use your spreadsheet's split-text or import option and choose Tab. Turn on filters and make the review-date column a date field after replacing the placeholders.
Choose a review date you’ll actually check. If you need an alert, put the task in your calendar or reminder app too. A date written in a row is a plan, not a notification.
The rows are illustrative. Replace them with real vacancies, dates and events before using the sheet to plan your search. Add a closing-date column if your shortlisted roles publish deadlines; keep it separate from your own review date.
Scroll sideways to inspect the spreadsheet columns. Copy and paste into a blank spreadsheet to edit.
Employer Role / reference Original vacancy URL Status Last confirmed event Next action Review date [Employer A] [Operations coordinator / ref] [verified role URL] Applied [confirmation received and date] Check employer timeline before any follow-up [YYYY-MM-DD] [Employer B] [Customer support / ref] [verified role URL] Considering [listing checked and date] Check advertised shift arrangement [YYYY-MM-DD] [Employer C] [Analyst / ref] [verified role URL] Preparing [referral conversation and date; not yet submitted] Finish tailored CV and submit through stated route [YYYY-MM-DD]
- 1Last event
Write the actual event and date. A referral conversation and an employer submission are different events.
- 2Next action
Use a verb and a specific task. Waiting is a status; checking a promised update is an action.
- 3Review date
Use your chosen reminder date unless the employer has provided a relevant timeline. Neither predicts an outcome.
Use labels that change what you do
Choose a short vocabulary and use it consistently. Keep the detail in the event column so the status stays easy to filter. The same row can move forward, go on hold or close; it does not need a new row every time something happens.
Scroll the table sideways to compare all columns.
| Status | What it means | Typical next action |
|---|---|---|
| Considering | You have saved the role and are checking fit | Verify a requirement or decide whether to prepare. |
| Preparing | You are working on the application | Finish the requested materials before the deadline. |
| Applied | Submission is recorded; note the confirmation you have | Review the employer's stated timeline. |
| Interview | An employer has invited you | Confirm arrangements and prepare for this role. |
| Closed | You have ended this row with a reason | Keep the history to prevent accidental reapplication. |
Turn a weekly check into decisions
Filter for review dates that are due, then read the last event before taking action. Use the employer's timeline where one exists. A reminder you set for yourself does not mean a reply was promised, and silence alone does not tell you the hiring decision.
- 01
Read the evidence
Check the confirmation, message or listing. Resolve an uncertain submission before making another attempt.
- 02
Do one useful task
Check the shift arrangement, complete the CV or make an appropriate inquiry through the stated channel.
- 03
Update the row
Record the completed event. Choose the next review date, or close the row with a factual reason.
What changes after a check?
Here’s a fictional review on 14 November 2026. The employers, roles and events are examples, not live vacancies. Read the evidence first, then change only what it supports.
Scroll the table sideways to compare all columns.
| Row | Evidence found on 14 November | Record now | Next action |
|---|---|---|---|
| A: Operations coordinator, Applied | Confirmation from 9 November is still the latest message. It gives no response date. | Keep Applied. Keep the confirmation date; add that messages were checked on 14 November and no later update was found. | Check the employer’s contact instructions before deciding whether to enquire. |
| B: Customer support, Considering | The saved vacancy description says rotating evenings. | Keep Considering. Record the shift requirement and the date checked. | Compare rotating evenings with your availability before preparing an application. |
| C: Analyst, Preparing | You filled the form, but can’t find a submission acknowledgement. The referral conversation is still the last confirmed contact. | Keep Preparing and note ‘submission unconfirmed’. A completed form is not a confirmed application. | Check the portal and email for submission evidence before retrying. |
C needs a check, not another application attempt. If you later find a confirmation, record its date and reference and change the status to Applied. If the result is still unclear, keep the uncertainty visible.
Completed fictional row C
| Employer | Role / reference | Original vacancy URL | Status | Last confirmed event | Next action | Review date |
|---|---|---|---|---|---|---|
| [Fictional Employer C] | Analyst / C-014 | [illustrative URL placeholder] | Preparing | 2026-11-12: referral conversation; 2026-11-14: form filled, submission unconfirmed | Check portal and email for submission evidence before retrying | 2026-11-15 |
The review date is the job seeker’s chosen check date, not an employer deadline. Keep earlier events in the row or a private note rather than overwriting them.
If the row is already at interview stage, use the employer’s timeline to decide whether you need a thank-you or a status enquiry. The interview follow-up guide has wording for asking about the next step.
Add fields only when they help a decision
Add a field when it answers a question you keep having. That might be the salary range from the listing, the filename of the CV you submitted, or a private copy of the vacancy description so you can prepare if the listing disappears. Keep the version you actually sent, not just your latest draft.
Stay with the sheet if manual updates work for you. If you keep missing reviews, consider a tool with reminders. Before connecting an inbox, check what it can read and whether you can export your records. You don’t need to change tools just because you’ve reached a certain number of applications.
Keep passwords, identity documents and sensitive personal details elsewhere. When you stop pursuing a role, record a reason such as withdrawn, employer rejection or listing closed. Retaining the event history makes the next review faster and helps you avoid sending the same application twice.
Sources & example notes
Reviewed 14 November 2026. Worked examples and suggested wording are ApplyLah editorial illustrations. Sources below support the factual guidance; examples do not report hiring outcomes.
