Job application tracker template (free, for Sheets and Excel)
If you are running your job search from a spreadsheet, start with a template that holds the right things and nothing else. This one has 14 columns, each there for a reason, and it works in Google Sheets, Excel or Numbers. Copy it, use it for free, and keep it for as long as your search lasts.
how to keep track of job applications
The template
| Column | What goes in it | Why it earns its place |
|---|---|---|
| Company | The employer's name | Stops similar names blurring together |
| Role title | The title exactly as posted | What you search for when a recruiter calls |
| Posting link | The URL of the posting | One click back to the source |
| Source | LinkedIn, Indeed, company site, referral | Shows which channels actually produce replies |
| Location | Remote, hybrid or on site, and where | Filters out roles you would never take |
| Salary | The range as posted, if any | Keeps offers comparable |
| Closing date | The application deadline | The date most often missed |
| Date applied | The day you submitted | Starts the clock for follow ups |
| CV version used | The exact file you sent | Interview prep starts from what they read |
| Contact | Recruiter or hiring manager, if known | Puts a name to each conversation |
| Status | Saved, Applied, Interviewing, Offer, Closed | A fixed list you can scan and filter |
| Next step | Follow up, prepare, chase, or let go | Turns the sheet into a plan |
| Next step date | When that step is due | Sort by this column every Monday |
| Notes | Fit, conversations, anything unusual | Two lines, written while it is fresh |
The file that comes with this guide has the columns set up and two example rows showing how a real search fills in. Delete the examples once your first roles are in.
How to use it well
- Add roles when you find them, not when you apply. Closing dates belong to saved roles, and saved roles are the majority of any search.
- Save the posting text somewhere. Postings are taken down when roles close. A link alone will not survive to your interview. Paste the text into a note attached to the row, or save the page as a PDF.
- Keep the status list fixed. The five statuses above cover a whole search. Inventing new ones ("waiting on them", "chased") makes filtering useless within a fortnight.
- Sort by next step date once a week. Ten minutes. Send due follow ups, close what has gone quiet for five or six weeks, and check closing dates on everything still Saved.
- Name your CV files clearly. "CV Product v3" in the template only helps if the file itself carries that name.
follow up on a job application
Where a spreadsheet template stops being enough
A template organises what you type into it. It cannot type for you, and that is where searches leak time:
- Every posting is manual entry: title, company, salary, dates, link, and the posting text if you want it kept.
- Nothing reminds you. The next step date only works on the days you remember to open the sheet and sort it.
- The template lives apart from the postings themselves, so capture is a separate chore after every find, on every site, including LinkedIn, Indeed, Workday and Greenhouse.
If your search is short, none of that matters much, and this template is honestly all you need. If the search runs for months, the entry work compounds, and that is the problem RolePocket exists to remove.
The version that tracks it for you
RolePocket is a private board with the same fields this template asks for, plus status, notes, tags and follow ups, and the CV you used for that application. Connect it to Claude, ChatGPT or another MCP compatible AI assistant, and you can work through your saved roles in conversation, assessing fit and preparing applications against the actual posting text. Adding a role is a supporting convenience: the browser extension saves a posting in one click, and AI extracts the title, company, salary, closing date and full details.
RolePocket costs 12.99 EUR per month, or 24.99 EUR per 3 months, tax included, and both plans include every feature.
Use the template for as long as it serves you. When keeping it fed starts to feel like a second job, that is the signal.
Track your job search with your AI assistant: rolepocket.com