The spreadsheet isn't your problem. Your process is fine — until a client says they don't want someone actively looking, they want the best person in the market whether or not that person has applied anywhere. At that point, your tracking sheet becomes an expensive notebook. It logs whoever you've already found. It can't help you find anyone new.
That's a real structural limit, and it's worth naming early. This guide gives you a genuinely useful applicant tracking spreadsheet structure — the columns that hold up under pressure, the stage definitions that don't drift, the formulas worth copying. And then, honestly, the signal that tells you when a spreadsheet has done its job and you need something different. For the broader view across template types, the free recruitment tracker templates guide covers the full range from spreadsheets to purpose-built tools.
What should an applicant tracking spreadsheet actually track?
An applicant tracking spreadsheet should track five things: who the candidate is, where they came from, where they are in the pipeline, when each stage happened, and what the next action is. Stage dates matter most — without them, you can't calculate time-to-shortlist or identify where candidates consistently go quiet in your process.
Most agencies start by tracking too much. A 30-column spreadsheet looks thorough until week three, when half the columns are empty because they're too time-consuming to fill in consistently. The columns that actually get used are: candidate identity and contact, which role they're being tracked for, current pipeline stage, when they got there, and what happens next. Everything else — CV quality notes, client reaction, compensation expectations — lives in a single free-text notes field.
There's also a GDPR angle worth thinking through early. Under GDPR, you're required to inform candidates what personal data you hold, how long you're keeping it, and to delete it on request. A spreadsheet doesn't handle any of that automatically. You need a manual retention schedule and a deletion log alongside the sheet. CIPD's guidance on employment data notes that most small agencies underestimate the compliance burden of manual candidate records. Manageable at low volume, genuinely burdensome once you have hundreds of rows.
The free template: columns and stages that actually work
The most practical applicant tracking sheet uses 10 columns: candidate name, role, source, stage, application date, last-action date, interview date, recruiter initials, quality score (1–5), and notes. The stage column — Sourced, Screening, Interview, Offer, Placed, Declined — is the axis everything else rotates around, so define those labels before you add the first row.
| Column | Field | What to track |
|---|---|---|
| A | Candidate Name | Full name |
| B | Role | Position title being tracked |
| C | Source | LinkedIn / Referral / Job Board / Direct Outreach |
| D | Stage | Sourced — Screening — Interview — Offer — Placed / Declined |
| E | Application Date | Date candidate entered the pipeline |
| F | Last Action Date | Updated on every touch — flags stale entries |
| G | Interview Date | Scheduled date, if applicable |
| H | Recruiter | Initials of the responsible recruiter |
| I | Score (1–5) | Subjective quality rating after first CV review |
| J | Notes | Free text — observations, objections, follow-up context |
Stage definitions matter more than column names. "Interview" is ambiguous by itself — is it a recruiter screening call, a first client interview, or a final round? Stage drift, where one recruiter's "Screening" is another's "Interview," silently corrupts pipeline analytics within weeks. Create a locked reference tab with your exact stage definitions and require consistent label use from day one.
The score column (1–5) is underused in most agency templates. A rating at the point of first CV review lets you sort the shortlist instantly and surface candidates worth reactivating when a similar role opens later. Five seconds at review time saves hours of re-reading old notes six months down the line.
The best applicant tracking spreadsheet is the one your team updates every single time. Optimise for consistency over completeness — ten columns filled in on every touch tells you more than twenty columns with chronic gaps.
Three formulas worth copying into your tracking sheet
Three formulas do most of the analytical work in an applicant tracking spreadsheet: a COUNTIF to measure stage volumes, a date subtraction to flag stale candidates, and a COUNTIFS to count placements per source. None requires advanced spreadsheet knowledge — and together they give you a basic hiring funnel that answers most of the reporting questions clients actually ask.
Stage count — how many candidates at each stage:=COUNTIF(D:D,"Interview")
Change "Interview" to any stage label you've defined. Run this for each stage and you have a live funnel view: how many in Screening, how many in Interview, how many pending an offer. At a glance, you can see where candidates are piling up or where the funnel is running dry.
Days in pipeline — staleness detector:=TODAY()-E2
Subtract the application date (column E) from today. Any result above 14 is a candidate who needs a follow-up. Apply conditional formatting to highlight cells where the value exceeds 10 days — it takes three clicks in Google Sheets and turns your sheet into an early-warning system for stalled candidates before clients start asking.
Placements by source — which channels are producing results:=COUNTIFS(C:C,"LinkedIn",D:D,"Placed")
This tells you how many placed candidates came from a specific source. Swap both strings for any source-stage combination and run it monthly. SHRM's talent acquisition research consistently shows that agencies tracking source-to-placement conversion identify underperforming channels significantly faster than those only monitoring total application volume.
Where applicant tracking spreadsheets break down
Applicant tracking spreadsheets break down in four situations: multiple recruiters editing simultaneously (data collision), candidates tracked across multiple roles (duplication confusion), passive candidate sourcing (the sheet has no search capability), and GDPR compliance (no automatic data-retention controls). The first two are solvable with process discipline; the last two require a different tool entirely.
Data collision is the earliest and most frustrating failure mode. Google Sheets handles concurrent editing reasonably well for small teams, but when two recruiters update the same candidate row at the same moment, one change is silently lost. There's no merge resolution and no audit trail. You discover the problem weeks later when a candidate's stage has mysteriously reverted, or when you realise the follow-up that was supposedly logged never happened.
The passive sourcing ceiling is structural, not a process failure. A spreadsheet has no mechanism to search for candidates who haven't applied to anything. You can track outreach you've already sent, but you can't generate the list of who to reach. LinkedIn Talent Solutions research consistently shows that roughly 70% of the global workforce is passive — open to opportunities but not actively applying. A spreadsheet, by construction, only reaches the remaining 30%.
A spreadsheet is a log, not an engine. It records what happened. It can't help you decide what to do next or surface the candidate who doesn't know they're a match yet.
| Agency situation | Spreadsheet fit | Signal to switch |
|---|---|---|
| Solo recruiter, under 15 placements/yr | Strong fit | Volume grows past 30/yr |
| 2–3 recruiters, inbound-led | Workable with discipline | Data collisions become weekly |
| Active passive-candidate sourcing | Wrong tool | Any passive mandate |
| GDPR-regulated EU agency | High compliance risk | Immediately, if unaddressed |
When to graduate from your spreadsheet to AI sourcing
Graduate from your applicant tracking spreadsheet to AI sourcing when you're consistently losing candidates between stages, when more than 20% of your mandates require proactive passive-candidate outreach, or when your team has grown past two recruiters. These aren't signs you need a bigger spreadsheet — they're signs you need a different kind of infrastructure.
The most common hesitation is cost. Purpose-built ATS tools with AI sourcing typically run €49–99 per user per month. But the math tends to favour switching earlier than agencies expect. A recruiter spending three hours a week managing spreadsheet gaps — chasing missing data, cross-referencing roles manually, re-searching for candidates already found once — burns roughly €300–400 per month in time at conservative rates. That's before you count missed placements from tracking gaps.
Gartner's HR technology research notes that the average agency waits 12–18 months longer than optimal before switching from manual tracking to purpose-built tools — precisely because the spreadsheet works well enough until the cost of that adequacy becomes measurable in lost placements.
If passive sourcing is already part of your business model, the free AI recruiting tools guide covers what's available without a large upfront commitment. And if you want to understand what AI-native sourcing actually does that a spreadsheet structurally cannot, Yena's sourcing overview explains the find-rank-reactivate model: turning your existing candidate database into an active pipeline rather than a static log.
The spreadsheet isn't the enemy. It's the right tool for the right stage. Knowing when you've outgrown it is the skill — and most agencies figure that out about six months after the data has already told them.
FAQ
What columns should an applicant tracking spreadsheet include?
An applicant tracking spreadsheet needs columns for candidate name, role, contact email, application source, current stage, interview date, interviewer, a numeric quality score, and next action. Ten columns is the practical ceiling — beyond that, the sheet becomes harder to maintain than the process it's supposed to track.
Is Google Sheets or Excel better for applicant tracking?
Google Sheets is better for teams with two or more recruiters because it supports real-time collaboration without versioning headaches. Excel suits solo recruiters who need complex pivot tables or offline access. For most small agencies, Google Sheets with protected ranges is the faster, lower-friction starting point.
What is the biggest limitation of an applicant tracking spreadsheet?
Spreadsheets track candidates who have already applied — they can't proactively find passive candidates who haven't raised their hand yet. The moment sourcing passive candidates becomes part of the workflow, a spreadsheet becomes a logging tool for a process that actually needs active search infrastructure instead.
When should a recruiting agency switch from spreadsheets to dedicated software?
Switch when two or more recruiters share candidate data and edits collide, when candidates fall through stage gaps regularly, when passive-candidate sourcing becomes a mandate priority, or when GDPR data-retention compliance becomes a real risk with manual records. Any one of these signals is strong enough to justify migrating.
Can I track passive candidates in a spreadsheet?
You can log passive candidates in a spreadsheet, but you can't source them there. A spreadsheet has no way to proactively scan for people who match a new role — it records outreach, it doesn't generate it. That structural gap is why sourcing-led agencies outgrow spreadsheets quickly. Yena's AI resume parser explains how automated CV parsing connects to the sourcing engine that makes passive-candidate discovery possible at scale.