How to keep track of job applications (without a messy spreadsheet)
Most job searches do not fall apart because of a bad CV. They fall apart in the gaps between applications: the posting you saved somewhere and cannot find, the closing date you meant to check, the follow up you sent a week late, the interview invite for a role you barely remember applying to.
A tracker fixes that, but only if it stays up to date. This guide sets out a simple system that works in a spreadsheet, then shows where the spreadsheet starts to cost you time, and what to use instead when it does.
What a job application tracker actually needs to hold
Forget the 30 column templates. For each role, you need seven things:
- Company and role title, exactly as posted, so a recruiter's call never catches you guessing.
- A link to the posting, and a saved copy of the text. Postings disappear when a role closes, usually right before your interview, when you need the details most.
- Status. A short, fixed list works best: Saved, Applied, Interviewing, Offer, Closed. Five stages you can scan in seconds.
- Dates that matter. The closing date before you apply, and the date you applied once you have.
- The CV version you used. When a callback comes, you want to open the exact document you sent, not your current draft.
- Next step and its date. Follow up, prepare, chase, or let go. This one field turns a list into a plan.
- Notes. Why the role fits, who you spoke to, what they said. Two lines is plenty.
If your tracker holds those seven things for every role, it is doing its job. Everything else is decoration.
The spreadsheet method, done properly
job application tracker template
A spreadsheet is a fair starting point, and for a short search it may be all you need. Set it up like this:
- One row per role, with the seven fields above as columns.
- Add each role the moment you find it, not after you apply. A search has more saved roles than applications, and the saved ones are where closing dates get missed.
- Keep the status list fixed. Free text statuses ("waiting", "pending", "chased once") make the sheet impossible to scan after two weeks.
- Spend ten minutes on it once a week. Update statuses, send the follow ups that are due, close anything that has gone quiet for five or six weeks. A tracker you review weekly stays true; one you open only in a panic does not.
Be honest about the running costs, because they are real. Every posting has to be copied in by hand: title, company, salary, closing date, the full text if you are being careful. Glassdoor has reported that 49% of workers track their search in Sheets or Excel, which also means a lot of people are doing unpaid data entry for their own job search. The sheet also cannot remind you of anything, cannot save a posting before it vanishes, and gets harder to trust the busier your search gets.
The point where the spreadsheet breaks
Three moments tell you it is time to move on:
- You stop logging roles. If adding a row feels like a chore, you skip it, and the tracker quietly stops reflecting your search.
- A posting vanishes. The role closes, the page comes down, and your interview prep loses the exact requirements you applied against.
- A follow up slips. Nobody forgets on purpose. Without dates and reminders in front of you, a week passes and the moment is gone.
None of these are discipline problems. They are data entry problems, and data entry is the part a tool should do for you.
What to use instead: track on a board, with capture as support
RolePocket was built around that exact break point. Your roles sit on a private board that tracks status, notes, tags and follow ups, with the CV you used kept against each application, and the posting text saved with the role, so it is still there when you prepare for the interview. If you work with an AI assistant, RolePocket connects to Claude, ChatGPT and other MCP compatible assistants, so you can assess a saved role against your search and prepare your application in conversation, with your own tracker as the source. Adding a role is a supporting convenience, not the main point: instead of typing a posting into a sheet, you save it in one click with the RolePocket Chrome extension, and AI extracts the title, company, salary, closing date and full details into your private workspace.
RolePocket is a paid tool: 12.99 EUR per month, or 24.99 EUR per 3 months, tax included, with every feature in both plans. If your search is three applications long, a spreadsheet is genuinely fine. If it is a focused search over weeks or months, the board, with its dates, reminders and AI assistant access, usually pays for the first month in time saved.
A simple weekly routine, whichever tool you use
- Review every role in Applied that has had no reply for seven to ten days. Send the follow ups that are due.
- Check Saved roles against their closing dates. Apply, or close them honestly.
- For anything in Interviewing, open the saved posting and the CV you sent. Prepare from those, not from memory.
- Close what is finished. A short, current board is worth more than a complete archive.
Ten minutes, once a week, and your search stays legible. That is all a tracker has to do: keep the whole search in front of you, in a form you trust.
Track your job search with your AI assistant: rolepocket.com