Job application tracker spreadsheet template

6 min readPublished

A job application tracker spreadsheet keeps every role, deadline, and follow-up in one place so nothing slips through the cracks.

This guide gives you the exact columns to include, a ready-to-copy template structure, and an honest look at where spreadsheets break down and what to do instead.

Why a tracker matters before you apply to your tenth job

Most job seekers apply to 20 to 80 roles before landing an offer. Without a tracker, you will forget which version of your resume you sent, miss a follow-up window, or accidentally apply to the same role twice. Recruiters notice duplicate applications and it rarely helps.

A spreadsheet costs nothing and takes about 15 minutes to set up. The return is a clear picture of where you stand at any moment: how many roles are active, which ones need a nudge, and which ones you should stop waiting on.

The columns every job application tracker needs

Keep the column count manageable. Too many fields and you will stop filling them in after the first week. The list below covers everything that actually affects decisions.

  • Date applied: the exact date, not 'last week'. Use ISO format (2026-10-21) so sorting works correctly.
  • Company name: spell it exactly as the company does, so searches match.
  • Job title: copy it from the posting, not your own shorthand.
  • Job ID or URL: postings disappear; save the link and the ID from the URL.
  • Location or remote status: note whether it is on-site, hybrid, or fully remote, and the city.
  • Salary range: record what the posting listed, or leave blank if undisclosed.
  • Application method: company site, LinkedIn Easy Apply, Indeed, recruiter referral, etc.
  • ATS platform: Greenhouse, Lever, Workday, or other. Useful if you need to log back in.
  • Resume version: name the file you submitted, such as 'resume-v3-product-manager.pdf'.
  • Cover letter sent: yes or no.
  • Status: one of five values only: Applied, Screening, Interview, Offer, Closed. Keeping this simple makes filtering fast.
  • Next action: the specific thing you need to do next, such as 'follow up by 2026-10-28'.
  • Notes: anything that does not fit elsewhere, such as the recruiter's name or a referral contact.

A ready-to-copy template structure

Open a new Google Sheet or Excel workbook. Row 1 is your header row. Freeze it so it stays visible as you scroll. Use the column names below in this order.

  1. Date Applied
  2. Company
  3. Job Title
  4. Job ID / URL
  5. Location / Remote
  6. Salary Range
  7. Application Method
  8. ATS Platform
  9. Resume Version
  10. Cover Letter
  11. Status
  12. Next Action Date
  13. Notes

How to use the tracker without letting it become a second job

Update the tracker the moment you submit an application, not at the end of the day. Memory fades fast when you are applying to multiple roles.

Set a weekly review time, 20 to 30 minutes on a fixed day. Sort by Next Action Date and work through anything due that week. Archive rows where the status has been Closed for more than two weeks so the active list stays short.

For follow-ups, a safe rule in the US, Canada, the UK, and Australia is to wait five to seven business days after applying before sending a brief email to the recruiter or hiring manager. Note the follow-up date in the Next Action Date column the moment you apply.

  • Do not follow up more than once per stage unless the recruiter invites it.
  • Keep follow-up emails to three sentences: who you are, the role you applied for, and one specific reason you are interested.
  • If a posting is taken down within 48 hours of your application, mark it Closed and move on. It was likely filled internally.

Where spreadsheets break down

A spreadsheet tracks what you tell it. It does not know when an employer replies, when an interview is scheduled, or when a deadline passes. You have to check your email, update the sheet, and remember to look at both.

The bigger problem is inbox fragmentation. Replies from Greenhouse come to your email. LinkedIn messages arrive in LinkedIn. Workday sends notifications through its own portal. Keeping a spreadsheet in sync with four or five inboxes is a real maintenance burden, and it is where applications get lost.

Break-In Bad brings employer replies into one inbox with interview alerts and day-before reminders, so you do not have to cross-reference a spreadsheet with multiple platforms. Omar, the AI assistant, also applies on Greenhouse, Lever, Workday, and other employer sites and saves a screenshot as proof of each submission, which means your tracker starts with a verified record rather than a self-reported one. If you are already applying at volume, that combination replaces most of what a manual spreadsheet does.

Keeping your resume versions organised alongside the tracker

The Resume Version column only works if your file naming is consistent. A simple convention: 'resume-[role-type]-v[number].pdf', for example 'resume-data-analyst-v2.pdf'. Store all versions in one folder named 'Job Search 2026' with subfolders by role type.

Never send a file named 'resume-final-FINAL.pdf'. Recruiters see hundreds of those and it signals disorganisation. Date-stamping the filename, such as 'resume-2026-10-21.pdf', is cleaner but makes it harder to match to a specific role type. The role-type plus version number approach is the most practical for a multi-month search.

Let Omar handle the tracking automatically

Break-In Bad applies to jobs on your behalf, saves a screenshot of every submission, and brings all employer replies into one inbox with interview reminders. You get 50 free credits when you sign up, no subscription required.

Start free

Questions people also ask

What is the best free tool for tracking job applications?

Google Sheets is the most practical free option because it is accessible from any device, supports dropdown validation, and is easy to share with a career coach or mentor. Notion and Airtable offer more visual layouts but have steeper setup times. A plain spreadsheet is faster to start and easier to maintain for most people.

How many job applications should I track at once?

Most career advisors suggest keeping 10 to 20 active applications at any time, meaning roles where you have applied and not yet received a final decision. Fewer than 10 limits your options; more than 20 makes it hard to personalise follow-ups and prepare properly for each interview.

Should I track jobs I have not applied to yet?

Yes. Add a status value called 'Saved' or use a separate tab for roles you are considering. This lets you compare opportunities before applying and ensures you do not lose a posting before you are ready. Note the application deadline if one is listed, since many roles close earlier than the posted date.