RolePocket

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

Download the template (CSV)

ColumnWhat goes in itWhy it earns its place
CompanyThe employer's nameStops similar names blurring together
Role titleThe title exactly as postedWhat you search for when a recruiter calls
Posting linkThe URL of the postingOne click back to the source
SourceLinkedIn, Indeed, company site, referralShows which channels actually produce replies
LocationRemote, hybrid or on site, and whereFilters out roles you would never take
SalaryThe range as posted, if anyKeeps offers comparable
Closing dateThe application deadlineThe date most often missed
Date appliedThe day you submittedStarts the clock for follow ups
CV version usedThe exact file you sentInterview prep starts from what they read
ContactRecruiter or hiring manager, if knownPuts a name to each conversation
StatusSaved, Applied, Interviewing, Offer, ClosedA fixed list you can scan and filter
Next stepFollow up, prepare, chase, or let goTurns the sheet into a plan
Next step dateWhen that step is dueSort by this column every Monday
NotesFit, conversations, anything unusualTwo 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