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
Keep reading
The Recruitment Process, Step by Step: How Agencies Actually Get From Job Order to Placement
A clear breakdown of every step in the agency recruitment process — from intake to placement — and where most agencies lose time without realizing it.
Recruitment Agency vs. In-House Recruiter: How Companies Should Actually Decide
The agency-vs-in-house decision isn't about cost alone. Here's the actual framework companies should use, and why most end up needing both.
What Is RPO? Recruitment Process Outsourcing Explained
RPO is often confused with staffing agencies and in-house recruiting. Here's what it actually is, how it differs, and when it's the right model.