How to Track Your Job Applications in a Spreadsheet

When applications arrive through portals, email and different employers’ websites, it is easy to forget which CV you sent or which deadline comes first. A simple tracker helps you answer both questions at a glance.

Set up one row for each vacancy

Use columns for employer, role, original advert link, deadline, date submitted, application channel, CV filename, status and next action. Add a reference number if the employer gives one.

Use a small set of statuses

Start with Saved, Preparing, Submitted, Interview and Closed. Filter by status when you plan the week. Sort open roles by deadline and put the next action in plain language, such as “Ask referee for permission”.

Record the version you submitted

Save a copy of each tailored CV and letter in a folder named for the employer and role. Link or record the filename so you can review it quickly if invited for an interview.

Review the tracker twice a week

Check deadlines, clear completed tasks and update interviews. Record confirmation emails or portal references without storing passwords or sensitive identity numbers in the sheet.

Explore more career guides on ExpressTZ.