Job Application Tracker: 12 Fields + Free Template (2026)

Q: What is the best free job application tracker?

For most candidates, a Google Sheets tracker with the 12-column structure in this guide is the best free option: unlimited free tier, full mobile editing, native CSV export, and no upgrade lock-ins. Teal and Huntr offer browser-extension auto-capture but cap their free tiers (5 saved jobs on Teal, 40 lifetime on Huntr). Notion and Airtable are strong free alternatives if you want a CRM-style layout.

Q: Should I use a spreadsheet or a tracker app like Teal?

Spreadsheet for searches under 30 applications; dedicated tool only when you find yourself copy-pasting JDs more than 10 times a week. Spreadsheets stay free forever, never hold your data hostage, and are stronger on mobile. Teal and Huntr are worth their paid tiers only if you value automatic JD capture from a browser extension and built-in AI keyword analysis.

Q: How many job applications should I track?

All of them. The average job seeker submits 32 to 200+ applications per search (per HiringThing and Zety aggregations, the median is around 180 apps for 1 offer). With an 8.3% application-to-interview rate, you cannot manage that volume from memory, and the analytics that come from a complete log (source-of-success, ghost rate, salary-band drift) only work if every entry is in.

Q: What fields are essential in a job application tracker?

Twelve: Company, Role, Source, Date applied, JD link, Resume version, Cover letter (Y/N), Referral (Y/N + name), Recruiter contact, Status, Next follow-up date, and Outcome / notes. Each maps to a downstream decision (which channel converts, which resume version is winning, when to follow up, when to mark a role as ghosted).

Q: How long should I keep tracker data after accepting an offer?

Archive, do not delete. Move the file to a private folder on a personal account (not work). Six months in, you will want to compare the next search against this one: which channels worked, which resume version converted, what salary bands were realistic. Redact recruiter names and confidential JD text before sharing the file with anyone.

Q: Can a tracker really speed up my job search?

Yes, in two ways. Candidates who track applications and follow up on schedule are 2.5x more likely to receive a response (LinkedIn Talent Solutions 2024). And tracker data lets you redirect time from cold applications (0.1% to 2% conversion) to referrals (30% conversion); one referral is worth 15 to 300 cold apps. Both effects compound over the average 19.9-week search (BLS 2024-2025).

Q: Is it worth paying for a job tracker app?

Usually no. For under 100 applications, a free Google Sheets tracker plus a separate ATS optimization tool delivers more flexibility than any paid tracker. Pay only if you want browser-extension auto-capture (Teal, Huntr) and you are submitting 40+ apps per month. Otherwise the spreadsheet route stays free forever and exports cleanly.

The average US job seeker spends 19.9 weeks searching for a new role and submits roughly 180 applications to land one offer (BLS 2024-2025; Interview Guys 2025 aggregation of HiringThing and Zety data). Candidates who track their applications and follow up on schedule are 2.5x more likely to receive a response (LinkedIn Talent Solutions 2024). A job application tracker is not a productivity ornament; it is the difference between guessing where your time is going and knowing exactly which channel, resume version, and follow-up cadence is producing interviews. In this guide we walk through the 12 fields every tracker must capture, share a copy-ready Google Sheets template structure, and compare spreadsheet trackers head-to-head with Teal, Notion, Airtable, and Huntr.

Why Track at All: 2.5x Response Rate, 19.9-Week Search

The case for a tracker is not paperwork; it is leverage. When 8.3% of applications result in an interview (HiringThing 2026; TeamStage 2024) and only 0.1% to 2% of cold online applications convert to offers compared with 30% of referrals (Ashby Talent Trends 2023), the candidates who measure their funnel can shift effort to the channels that actually convert. Without a tracker, you are running a multi-month campaign on memory.

BLS data shows the median unemployed job seeker takes 61 days to find work, the mean stretches to 139 days, and 41% land within one month while a growing 6% take three months or longer (BLS; Indeed Hiring Lab 2024). Average employer time-to-hire sits at 41 to 44 days (Ashby Talent Trends 2023; Workable 2024), so even a single application is in motion for six weeks before you hear yes or no. Multiply that by the 32 to 200+ apps the typical search produces, and the bookkeeping becomes its own job.

The compounding effect. Tracking does three things at once: it reminds you to follow up (the LinkedIn 2.5x lift), it keeps you from re-applying or contradicting yourself across rounds, and it generates the data you need to redirect effort from cold applications (0.1% to 2% conversion) to referrals (30% conversion). One spreadsheet, three forms of leverage.

The 12 Fields You Must Track (and Why Each Matters)

Most templates online give you 6 or 7 columns and call it a day. That is enough to log an application; it is not enough to learn from one. The 12 fields below each map to a downstream decision: which resume version is winning, which channel is wasting your time, which roles are getting ghosted, and where you owe a follow-up.

12 Tracker Fields and Their Analytic Use

#	Field	Example value	What it powers downstream
1	Company	Stripe	Duplicate-application check; recruiter cross-reference
2	Role / Title	Senior Backend Engineer	Title-level response rate (titles you actually convert on)
3	Source	Referral / LinkedIn / Company site / Indeed	Source-of-success ranking (cold-app vs referral 0.1% vs 30%)
4	Date applied	2026-04-22	Time-in-stage; ghosting cutoff calculation
5	JD link / saved JD text	https://…/jobs/12345	Reference for the screen call; keyword re-extraction
6	Resume version	v3-backend-fintech	Which resume variant is producing interviews (the average candidate maintains 2.7 versions per search; TopResume 2023)
7	Cover letter (Y / N + version)	Y, v2-eng-mgr	Whether CL inclusion correlates with replies for your roles
8	Referral (Y / N + name)	Y, Priya R.	Referral-channel performance vs cold
9	Recruiter / contact	jordan@stripe.com	Direct follow-up; thank-you note routing
10	Status	Recruiter screen	Pipeline view; days-in-stage benchmark check
11	Next action / follow-up date	Send thank-you 2026-04-30	2.5x response lift on actual follow-ups (LinkedIn 2024)
12	Outcome + notes	Offer / Rejected / Ghosted; salary band	Salary-band drift detection; rejection-rate by source

Two fields trip up most candidates. The first is Resume version: most people send whichever PDF was on the desktop that morning, then cannot answer why one application turned into a screen call and another did not. The second is Source: lumping LinkedIn Easy Apply, company-site direct, recruiter cold-outreach, and referrals into one bucket hides the single most actionable fact in your search.

Free Google Sheets Template You Can Copy

Below is the structure we recommend. Open a fresh Google Sheet, paste the headers in row 1, and use the dropdown values listed in the Notes column for the Source, Status, and Outcome columns (Data → Data validation → List of items). Conditional formatting on Status (green for advanced stages, red for rejected, gray for ghosted) keeps the pipeline visible at a glance.

Job Application Tracker, copy-ready column structure

Col	Header	Type	Notes / dropdown values
A	Company	Text	Free text
B	Role	Text	Use the JD title verbatim
C	Source	Dropdown	Referral, Company site, LinkedIn, Indeed, Recruiter outreach, Other
D	Date applied	Date	YYYY-MM-DD
E	JD link	URL	Or paste full JD into a Notes tab
F	Resume version	Text	Filename or label, e.g. v3-backend-fintech
G	Cover letter?	Dropdown	Yes / No
H	Referral?	Dropdown	Yes / No (+ contact name in I)
I	Recruiter / contact	Text	Name + email
J	Status	Dropdown	Saved, Applied, Recruiter screen, Hiring manager, Onsite, Offer, Rejected, Ghosted, Withdrawn
K	Next follow-up	Date	Conditional format: highlight if < today
L	Outcome / notes	Text	Salary band, rejection reason, recruiter comments

Add three calculated cells at the top of the sheet. =COUNTIF(J:J,"Applied") for active apps, =COUNTIF(J:J,"Recruiter screen")+COUNTIF(J:J,"Hiring manager")+COUNTIF(J:J,"Onsite") for in-pipeline interviews, and =COUNTIF(J:J,"Offer")/COUNTIF(J:J,"Applied") for your application-to-offer rate. Those three numbers, refreshed weekly, are the dashboard.

Pipeline Status Stages (and How Long Each Should Take)

The Status column matters most when you compare it against benchmarks. Average employer time-to-hire is 41 to 44 days end-to-end (Ashby Talent Trends 2023; Workable 2024), and that 41-day window is what each stage below has to fit inside.

Pipeline stage benchmarks

Stage	Typical days in stage	Action when exceeded
Saved	0 to 7	Apply or remove
Applied	5 to 14	Send follow-up; mark Ghosted at 21+
Recruiter screen	3 to 10	Email recruiter for next-step ETA
Hiring manager screen	5 to 14	Ping recruiter; ask for timeline
Onsite / final round	7 to 14	Send thank-you within 24h; chase decision at 7d
Offer	3 to 7	Negotiate; confirm in writing
Decision	1 to 5	Accept, decline, or counter

Anything sitting in Applied beyond 21 days is statistically a Ghosted; flip the status, log it, and free the mental space. Fortune 500 openings receive 180+ applications and only 25% of resumes get a human review (Jobscan 2023), so silent rejections are normal, not personal.

Spreadsheet vs Teal vs Notion vs Airtable vs Huntr

Spreadsheets win on flexibility and zero cost. Dedicated tools win on automatic capture and built-in CRM features. Below is the head-to-head matrix we use to advise candidates depending on search volume and tech comfort.

Tracker comparison: spreadsheet vs Teal vs Notion vs Airtable vs Huntr

Feature	Google Sheets	Teal	Notion	Airtable	Huntr
Free tier	Unlimited	Limited (5 saved jobs)	Generous personal plan	1,000 records / base	40 jobs lifetime
AI features (summary / keywords)	None native	Yes, AI resume scoring + match	Notion AI add-on	AI add-on (per credit)	AI tailoring on paid
Browser extension (auto-capture JD)	None	Yes	Web Clipper (manual)	Web Clipper (manual)	Yes
Custom fields	Unlimited	Limited preset fields	Unlimited	Unlimited	Limited
Mobile	Sheets app, full edit	Web only on free	Strong mobile app	Strong mobile app	Web only
Export (CSV / portable)	Native CSV	CSV on paid	CSV / Markdown	CSV native	CSV on paid

Decision tree: spreadsheet or dedicated tool?

Searching for < 30 roles total? Spreadsheet. The setup overhead of a dedicated tool will not pay back at low volume.
Applying to 30+ roles and do not want to copy/paste JDs? Teal or Huntr for the browser extension auto-capture.
Want notes, contact CRM, and document storage in one place? Notion (free) or Airtable (free up to 1,000 records).
Want AI keyword analysis tied to each application? Teal, or pair Sheets with Resume Optimizer Pro for per-application match scoring.
Mostly searching from your phone? Sheets or Airtable. Teal and Huntr are weaker on mobile.

Our default recommendation for a typical search (40 to 100 applications): start in Google Sheets using the structure above, and only graduate to Teal or Huntr if you find yourself copy-pasting JDs more than 10 times a week. The spreadsheet route stays free forever and never holds your data hostage at upgrade time. For a deeper Teal-specific comparison, see our Teal alternative guide.

How to Use Tracker Data Analytically: 3 Worked Examples

A populated tracker is a small dataset, and even three weeks of entries is enough to spot patterns. Below are three diagnostics we run on candidate trackers; each one points to a specific change in tactics.

Example 1: Diagnosing a low callback rate

A candidate logs 60 applications in 4 weeks and has 2 recruiter screens. That is a 3.3% application-to-interview rate against the 8.3% benchmark (HiringThing 2026). Filtering by Source reveals 54 of the 60 came through LinkedIn Easy Apply (cold) and only 6 from referrals or company sites. The 0.1% to 2% cold-app conversion rate explains the drop. The fix is mechanical: shift 50% of the next 4 weeks to referral outreach and direct company-site applications. With 30% referral conversion (Ashby Talent Trends 2023), 10 referrals will outproduce 100 cold apps.

Example 2: Spotting a ghosting pattern

Filter the tracker by Status = Applied and Date applied > 21 days ago. If 35 of 50 entries qualify, you have a 70% ghost rate. Cross-tabulate against Cover letter (Y/N) and Resume version. If the ghost rate drops to 50% on entries with cover letters and to 40% on the v3 resume version, you have isolated two levers (always include CL; standardize on v3) that move the response rate measurably. Only 4% of candidates send a thank-you email after rejection (Greenhouse 2024); even fewer track the inputs that produce or prevent the rejection.

Example 3: Detecting salary-band drift

Log the listed or recruiter-quoted salary band for every role in the Outcome / notes column. After 30 applications, a candidate sees their average target band has slipped from $145K to $128K. The tracker exposes that the LinkedIn Easy Apply roles they have been chasing skew junior of their target. The fix is to filter searches to roles > $140K and to redirect referral asks toward senior contacts. Without the column, the drift is invisible.

The 4 ratios to compute weekly. (1) Application-to-interview % (target 8%+), (2) Interview-to-offer % (target 25%+), (3) Source-of-success ranking (referrals should dominate), (4) Average days-in-stage (under 21 in Applied; under 14 in any post-screen stage). When any ratio drifts below benchmark for two consecutive weeks, change tactics, not effort.

Tracker Hygiene: A Daily 15-Minute Review Routine

A tracker only generates the 2.5x response lift if it is actually maintained. The routine below takes 15 minutes a day and keeps the data clean.

Daily 15-minute tracker review

Log new applications (5 min). Every app from the last 24 hours. Resume version, source, JD link.
Advance pipeline statuses (3 min). Move screens that happened today; flip Applied rows older than 21 days to Ghosted.
Send the day's follow-ups (5 min). Filter by Next follow-up < today. Send the email; update the date.
Archive the dead (2 min). Move Rejected and Ghosted rows to an Archive tab so the active sheet stays under 50 rows.

The Sources Audit: Where You Are Wasting Time

The single highest-leverage analysis a tracker enables is the source audit. Cold online applications convert at 0.1% to 2%. Referrals convert at 30% (Ashby Talent Trends 2023). The math is brutal: one referral is worth 15 to 300 cold applications. Yet most candidates spend 80% of their time on cold apps because cold apps feel productive (lots of clicks, lots of submissions) while referrals feel awkward.

After 30 logged applications, sort your tracker by Source and count how many of each source produced a recruiter screen or further. If LinkedIn Easy Apply is 60% of your volume but 20% of your screens, halve your time there. If referrals are 10% of your volume but 60% of your screens, double the referral asks. The data will not be subtle. The fix, week over week, is to drag the Time Spent column toward whichever source has the highest screen-per-application ratio.

Resume tailoring + tracker. Tailored resumes lift interview rates significantly, and a tracker with a Resume version column tells you which tailored variant is actually winning. See our guide on how to tailor resumes for jobs for the per-application workflow that pairs with the tracker.

Privacy and What to Do When You Accept an Offer

A tracker accumulates sensitive data: salary expectations, recruiter names, internal notes, sometimes confidential JDs. Three rules keep it safe. First, do not store the tracker on a work device or work account; use a personal Google account. Second, redact recruiter emails and rejection reasons before sharing the file (with a coach, mentor, or peer). Third, when you accept the offer, archive the tracker in a private folder rather than deleting it. Six months in, you will want to compare a future search against a past one.

For deeper follow-up tactics tied to tracker data, see our resume application follow-up strategies guide; the cadence there pairs directly with the Next follow-up column.

The Bottom Line

A tracker is a 15-minute-a-day habit that does three things no other tactic in your search does at once: it triggers the follow-ups that lift response rates 2.5x, it isolates which channels and resume versions are actually producing interviews, and it converts an emotional 19.9-week slog into a measurable funnel you can adjust. Start with the 12-column Google Sheets template. Add a tool only when the spreadsheet stops scaling. And treat the data as a steering wheel, not a scorecard.