How to Create a Recruitment Tracker in Excel (Step-by-Step)
A practical walkthrough for building a recruitment tracker in Excel — the right columns, the formulas for time-to-hire and source-of-hire, and the moment to graduate to a real ATS.
What a recruitment tracker actually needs
A recruitment tracker in Excel needs to answer four questions: who's in our pipeline, what stage are they at, how long have they been there, and where did they come from. Anything that doesn't help answer one of those is noise.
Step 1 — Set up the columns
Open a fresh workbook. Row 1: Candidate Name, Role, Source, Date Applied, Stage, Stage Updated, Days in Stage, Owner, Next Step, Next Step Date, Outcome, Notes. Freeze the top row (View → Freeze Panes → Freeze Top Row).
Make Stage a dropdown: Data → Data Validation → List → 'Applied, Screen, Interview, Offer, Hired, Rejected'. Same for Source. Dropdowns are what keep the data clean six weeks in.
Step 2 — Add the formulas
Days in Stage: =TODAY()-F2 (where F is Stage Updated). Conditional-format anything over 10 days amber and over 20 days red.
Time to hire: in a separate summary sheet, =AVERAGEIFS(TrackerSheet!G:G, TrackerSheet!E:E, "Hired") gives you average days-to-hire across closed roles.
Source of hire: =COUNTIFS(E:E, "Hired", C:C, "LinkedIn") and repeat per source. After ten hires you'll know which channels actually convert.
Step 3 — Build the dashboard
On Sheet 2, add a pivot table from the tracker range. Rows: Stage. Values: Count of Candidate Name. You now have a live pipeline-by-stage chart.
Add a second pivot: Rows = Source, Values = Count. That's your source mix. Refresh manually after every batch of edits (PivotTable → Refresh).
What breaks at scale
Excel recruitment trackers break at three points: two people opening the file at once (no real concurrency), candidate notes spilling beyond one cell (Excel hates wrapped text), and the moment you want a kanban view of your stages.
When you hit one of those, the upgrade is a real applicant tracking system that imports your existing Excel sheet without a rebuild. Recruit Flow auto-maps your columns — Name, Role, Stage, Source, Date Applied — and your manual conditional formatting becomes built-in stage-aging alerts.
Run this pipeline in RecruitFlow
A calm, focused hiring tracker for recruiters and small teams. Table and Kanban views, real candidate timelines, stale-stage alerts — no configuration project required.
Sign up to RecruitFlowCreate your account · verify your email · choose a plan · move in today.
Useful next steps
Related posts
The applicant tracking spreadsheet, done properly (free template + when to upgrade)
A practical guide to the applicant tracking spreadsheet: the six columns small teams actually use, a free Excel and Google Sheets template, and the honest moment to switch to a recruiting candidate tracker.
Candidate Tracking Spreadsheet: Simple Guide
A practical guide to building a candidate tracking spreadsheet — the columns that matter, where spreadsheets break, and when it's time to move to a simple hiring tracker.
Recruitment Pipeline Template: A Free Framework You Can Set Up Today
A practical recruitment pipeline template covering every stage from sourcing to placement, plus when to graduate from a spreadsheet to real tracking software.
Recruitment Metrics and Hiring KPIs That Matter
How to track recruitment metrics like time-to-hire, stage conversion, and source quality once you move off a spreadsheet — and which KPIs are worth the effort.
Job Application Tracker in Google Sheets (Free Template + Setup)
A free Google Sheets job application tracker template, plus the exact columns, formulas, and conditional formatting that make it actually useful past week two.
Boolean Search for Recruiters: A Practical Guide With Real Examples
Boolean search still outperforms most "smart search" tools when built correctly. Here's how the syntax actually works, with real sourcing string examples.