What is a job search tracker?
A job search tracker is one list of every job you applied for, with the date, the status and the next step for each. A spreadsheet works fine. With dozens of applications open, it is easy to lose track of which resume you sent, who you spoke to and when to follow up. The tracker holds those details for you.
It also does a second job. Canada's EI program and some US state unemployment programs ask claimants to keep a record of their job search, and a tracker can double as that record. The sections below show the columns to use, how to keep it current and what the official logs ask for.
Which columns should a job search tracker have?
Keep it to about a dozen columns, one row per application. The essentials are the company, the job title, a link to the posting, the date you applied, the resume version you sent, your contact, the status, the next step and its date. Add a notes column for anything said on a call.
Here is a layout you can copy into Google Sheets or Excel. Put the column names in row 1 and start your first application in row 2.
| Column | What to enter | Why it helps |
|---|---|---|
| A. Company | Employer name | Sorts applications by employer |
| B. Job title | Title as written in the posting | Matches the role when a recruiter calls |
| C. Posting link and ID | URL and the job ID number | Lets you reread the posting before an interview |
| D. Source | Careers page, job board, referral, recruiter | Shows which sources lead to replies |
| E. Date applied | The day you submitted | Starts the follow-up clock |
| F. Resume version | File name of the resume you sent | Lets you bring the same version to the interview |
| G. Contact | Name, email or phone of the recruiter or referrer | Gives you someone to follow up with |
| H. Status | One word from a fixed list | Lets you count and filter |
| I. Last contact | Date of the last message either way | Shows how long it has been quiet |
| J. Next step | What you will do next | Turns the list into a to-do list |
| K. Next step date | When you will do it | Lets you sort by what is due |
| L. Notes | Interview dates, names, questions asked, pay range | Keeps details you will need later |
Save a copy of each posting as a PDF too, and put the file name in column C. Postings come down, and you will want the original wording if you reach an interview.
What status labels should you use?
Use a short, fixed list so you can count them. A good set is: Saved, Applied, Screen, Interview, Final, Offer, Rejected, Withdrawn and No reply. Pick one for every row and never invent a new label for a single case. A fixed list lets one formula tell you how many applications sit at each stage.
In Google Sheets and Excel, a data validation dropdown on column H keeps the labels consistent. Then a small summary table can use COUNTIF. For example, `=COUNTIF(H:H,"Interview")` counts how many applications are at the interview stage.
Move a row to No reply after a set time with no answer, such as 30 days. Choose the cutoff once and apply it to every row, so the counts mean the same thing week to week.
How do you organize 50 or more applications?
Sort by next step date and work from the top. At 50 applications the list is too long to read every day, so the tracker has to tell you what is due. Add a days-since-applied column, color rows by status, and review the whole sheet once a week. Archive closed rows to a second tab.
These formulas cover most of it. They assume the layout in the table above.
- Days since you applied, in a new column M: `=TODAY()-E2`, copied down the column.
- Days since last contact, in column N: `=TODAY()-I2`.
- A follow-up flag, in column O: `=IF(AND(H2="Applied",M2>=10),"Follow up","")`. The 10-day mark is a choice you can change.
- Conditional formatting on column K to highlight any date on or before today.
Keep closed rows. Rejected and Withdrawn applications show which kinds of roles and sources didn't work. Moving them to an Archive tab keeps them for review without cluttering the active list.
When a follow-up is due, the guide to following up on a job application has templates. If a posting has gone quiet for weeks, check the signs in the guide to ghost jobs before you spend more time on it.
Can a job search tracker count as an unemployment work search log?
It can help, as long as it holds every field your program asks for. Washington's job search log asks for the contact date, job title or reference number, employer name, how you made contact, the type of contact and the employer's address, website or phone. A tracker with those columns covers most of it.
Washington's form also sets rules. Claimants must "complete a log for each week you claim unemployment benefits" and need "a combined total of three Employer contacts, approved WorkSource activities or Other approved activities each week." It says to keep the log at least 30 days after the end of your benefit year or your last extension payment, whichever is later.
Other states set their own rules, so check your state agency's page or handbook for the number of contacts and the fields it wants. Washington's form also warns that "Providing false information is fraud." Log only what you did.
In Canada, the federal EI rights and responsibilities page says to "keep a detailed record as proof of your job search efforts" and that "you must keep your job search record for 6 years." The EI regular benefits checklist says to log "the names of all employers you visited or contacted," with contact details and dates. It also says to record employers where you have applied or plan to apply.
How does a tracker help with follow-ups and deadlines?
It turns dates into reminders. Each row's next step date tells you when to follow up, prepare or decide. Some deadlines are set by law. Since January 1, 2026, Ontario employers with 25 or more employees must tell interviewed applicants whether a hiring decision has been made within 45 days of the last interview.
That rule is on the province's page of recent changes to the Employment Standards Act. The employer can tell you in person, in writing or by technology, and the rule doesn't apply to employers with fewer than 25 employees on the day the job was posted. In your tracker, add the 45-day date to the notes column after each Ontario interview: `=I2+45` when column I holds the date of the last interview.
For most other employers there is no legal clock, so set your own. The guide to how long it takes to hear back after an interview covers what is normal.
What should you review in your tracker each week?
Look at three numbers once a week: applications sent, replies received and interviews reached, each broken down by source. If one source brings replies and another never does, shift your time. If you get screens and no second rounds, the problem is likely in the interview, and the tracker shows where to look.
The guide to how many applications it takes to get a job helps you set a weekly target. The comparison of tailored applications vs mass applying covers the trade-off between volume and tailoring. If you are working from a layoff, the guide to a job search after a layoff has a week-by-week plan.
Use the resume version column well. Keep one master resume and save a named copy for each tailored application. The free resume optimizer rewrites the lines that matter for a posting with your facts kept, and the free job match checks every requirement against your resume and gives a score out of 10. Prept writes tailored resumes only from facts you have confirmed, which keeps every version in your tracker consistent with the others.