Job application tracker spreadsheet template
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.
- Date Applied
- Company
- Job Title
- Job ID / URL
- Location / Remote
- Salary Range
- Application Method
- ATS Platform
- Resume Version
- Cover Letter
- Status
- Next Action Date
- 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 freeQuestions 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.
Applying for jobs
How many jobs should you apply to per day?
The honest answer on daily application numbers, why most people apply to the wrong jobs, and the one number that actually predicts interviews.
Applying for jobs
ATS resume: what actually gets you past applicant tracking systems
How Greenhouse, Lever, Workday and other ATS tools really screen resumes, the myths about 'ATS-friendly' formatting, and the five things that decide whether a human sees your resume.
Applying for jobs
How to follow up after a job application or interview (with templates)
When to follow up, when not to, and short email templates for after an application, after an interview, and when you have another offer.
Applying for jobs
Auto apply to jobs: what it does, where it fails, and what good looks like
Auto-apply tools save time but often send generic documents. Learn what a job application agent should actually do before and after each submission.
Applying for jobs
Best auto apply job tools compared for 2026
Compare the top auto-apply job tools on eligibility filtering, resume tailoring, proof of submission, and pricing before you choose one.
Applying for jobs
Does mass applying to jobs work?
Mass applying to jobs produces very low response rates. Here is what the data shows and how a targeted approach gets better results.