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.
Build your pipeline in Recruit Flow
A calm, focused hiring tracker for recruiters and small teams. Table and Kanban views, real candidate timelines, stale-stage alerts.
Try Recruit Flow freeUseful next steps
Keep reading
Applicant Tracking Systems for Small Teams
A grounded look at choosing an applicant tracking system when your team is five people, not five hundred — what to keep, what to skip, and how to avoid enterprise sprawl.
Recruitment Pipeline Stages: The Five That Matter
Forget the fifteen-stage funnel. A practical recruitment pipeline has five stages that everyone on the team can name, apply consistently, and trust.
Why a Candidate Timeline Beats Recruiter Notes Every Time
Recruiter notes drift, get lost, and stop being useful by week three. A timestamped candidate timeline is how small hiring teams keep their context.