Download the recruitment tracker template if you need a simple way to see every candidate, role, interview, and hiring KPI in one place. The free Excel and Google Sheets version includes a candidate pipeline tracker, requisition tracker, interview schedule, and metrics dashboard. It is built for small recruiting teams that need structure now, before a full ATS is worth the cost.
A recruitment tracking spreadsheet template gives small teams a structured alternative to ad-hoc spreadsheets by providing pre-built columns for candidate stage, source, interview dates, and outcome — without requiring ATS software. According to SHRM's talent acquisition research, the average time-to-hire across industries is 44 days, and organisations that track pipeline metrics systematically reduce that figure by identifying bottlenecks at each stage. A well-designed recruitment tracker template — also called an applicant tracking spreadsheet — in Excel or Google Sheets captures the same pipeline data as entry-level ATS platforms at no cost, making it the right starting point for teams placing under 20 roles per month. For context on when a tracker outgrows a spreadsheet, see the key recruitment KPIs guide.
Not every agency needs an ATS from day one. If you're running a small recruitment desk — 5 to 15 open roles, maybe a team of two or three — a well-built spreadsheet can genuinely work. The key word being "well-built."
Skip the build — grab the ready-made templates
Get all 4 recruitment templates as Excel + CSV. We'll email them to you in 30 seconds.
Most recruitment trackers people build themselves are a mess within two weeks. Columns multiply. Data gets inconsistent. Nobody remembers what "Stage 3" means. So here are four structured templates that won't fall apart — with the formulas already set up.
Template 1: Candidate Pipeline Tracker
The core tracker. Every candidate, every role, every stage.
Columns:
| Column | Type | Notes |
|---|---|---|
| Candidate Name | Text | Full name |
| Text | Primary contact | |
| Phone | Text | Mobile preferred |
| Role Applied | Dropdown | Link to Requisitions sheet |
| Source | Dropdown | LinkedIn / Indeed / Referral / Direct |
| Date Applied | Date | When they entered pipeline |
| Stage | Dropdown | New → Screening → Interview 1 → Interview 2 → Offer → Hired → Rejected |
| Stage Updated | Date | Last stage change date |
| Assigned Recruiter | Dropdown | Team member name |
| Notes | Text | Keep it brief |
| Salary Expectation | Currency | Annual figure |
| Days in Pipeline | Formula | =TODAY()-[Date Applied] |
Tip: if your team has a dedicated sourcer alongside closers, add a second recruiter column — one for the person finding candidates, one for the consultant managing the offer.
Conditional formatting tips:
- Red highlight when "Days in Pipeline" exceeds 30 — stale candidates need action
- Green for "Hired" stage, yellow for "Offer" stage
- Bold red when "Stage Updated" is more than 7 days ago — follow up needed
Template 2: Requisition Tracker
Track every open role, its status, and key dates.
| Column | Purpose |
|---|---|
| Req ID | Unique identifier (e.g., REQ-2026-001) |
| Job Title | Role name |
| Department / Client | Who it's for |
| Hiring Manager | Decision maker |
| Priority | High / Medium / Low |
| Date Opened | When req was approved |
| Target Fill Date | When they need someone |
| Status | Open / On Hold / Filled / Cancelled |
| Salary Range | Budget approved |
| Total Candidates | Formula: =COUNTIF(Pipeline!D:D, [Job Title]) |
| Active Candidates | Formula: excludes Rejected/Hired |
| Days Open | Formula: =TODAY()-[Date Opened] |
Template 3: Interview Schedule Tracker
Keep interviews organised when you don't have scheduling software.
| Column | Purpose |
|---|---|
| Date | Interview date |
| Time | Start time (include timezone) |
| Candidate Name | Linked to pipeline tracker |
| Role | Which position |
| Interview Type | Phone / Video / In-person / Panel |
| Interviewers | Names of panel members |
| Meeting Link / Location | Zoom link or office address |
| Confirmation Sent | Yes/No — did candidate confirm? |
| Outcome | Advance / Reject / Hold / No-show |
| Feedback Due | Date by which interviewers must submit feedback |
Template 4: Hiring Metrics Dashboard
Track the numbers that actually matter.
Create a summary sheet that pulls from your pipeline and requisition trackers. Key formulas:
- Time-to-fill: Average of (Date Hired - Date Opened) for filled roles. SHRM benchmark: 44 days in Europe
- Time-to-hire: Average of (Date Hired - Date Applied) for hired candidates
- Source effectiveness: COUNTIF by source for hired candidates. Which channels produce hires, not just applicants?
- Pipeline velocity: Candidates per stage, updated weekly. Bottlenecks show up instantly
- Offer acceptance rate: Offers accepted / Offers made. Below 80% means your offers aren't competitive
- Cost per hire: Total recruitment spend / Number of hires (if you track spend)
According to CIPD resourcing research, only 37% of UK employers formally track recruitment KPIs. Even basic tracking puts you ahead of most. Pair this with the free recruitment KPI dashboard template to turn raw tracker data into a one-page weekly view.
Want these templates pre-built?
Excel + Google Sheets + CSV versions of all 4 templates, with the formulas already wired.
Google Sheets vs Excel: Which to Use?
Google Sheets wins for teams. Real-time collaboration, no version conflicts, accessible from anywhere. Free with a Google account. The built-in data validation (dropdowns) works well enough for recruitment stages and sources.
Excel wins for power users. Pivot tables, advanced conditional formatting, and VBA macros if you want to get fancy. Better for complex metrics dashboards. But file sharing becomes a nightmare when multiple people need to update simultaneously.
Our recommendation: start with Google Sheets. Move to something else when you hit a wall.
When Spreadsheets Stop Working
Spreadsheets break at predictable points. Watch for these signs:
- More than 20 open roles simultaneously. The tracker becomes unwieldy. You start missing candidates in the scroll.
- Three or more recruiters sharing the sheet. Version conflicts, overwritten data, "who updated this?" conversations.
- Clients asking for reporting. Generating weekly client reports from a spreadsheet is manual torture.
- Compliance requirements. GDPR requires you to delete candidate data after retention periods. Good luck enforcing that in a spreadsheet.
- You're copying and pasting between spreadsheet and email. If you're spending more time on admin than talking to candidates, the spreadsheet has become the bottleneck.
At that point, a proper ATS isn't a luxury — it's a time-saving investment. Yena handles pipeline tracking, interview scheduling, client reporting, and GDPR compliance in one place. Multi-client agencies often compare options like Yena vs Bullhorn at this stage. You can import your spreadsheet data during setup, so nothing gets lost in the transition.
But don't jump to an ATS because someone told you to. Jump when the spreadsheet starts costing you more time than it saves. For many small agencies, that tipping point comes around month 6 of growth.
If your growth is being driven by AI-augmented sourcing, the spreadsheet ceiling hits sooner. We've published a separate buyer guide for AI agents in recruiting covering what these systems actually deliver, what to demand from vendors, and how to test one in 14 days against your real desk.
Frequently Asked Questions
What should a recruitment tracker template include?
A solid recruitment tracker has columns for candidate name, email, phone, role applied, source, date applied, stage, stage-updated date, assigned recruiter, notes, salary expectation, and a formula for days in pipeline. Pair it with a requisition tracker (one row per open role) and an interview schedule sheet so the whole pipeline lives in one file.
Is Excel or Google Sheets better for a recruitment tracker?
Google Sheets wins for teams — real-time collaboration, no version conflicts, free with a Google account, and built-in dropdowns for stages and sources. Excel wins for power users who want pivot tables, advanced conditional formatting, and macros. Most small agencies should start in Google Sheets and switch only when they hit a wall.
How do I track a recruitment pipeline in a spreadsheet?
Use three linked sheets: a candidate pipeline tracker, a requisition tracker, and an interview schedule. Link candidates to roles with a dropdown, use formulas like =TODAY()-[Date Applied] for days in pipeline, and apply conditional formatting (red when a candidate sits over 30 days, or when the stage hasn't moved in 7 days) so bottlenecks surface automatically.
When should I move from a spreadsheet to an ATS?
Watch for predictable breaking points: more than 20 open roles at once, three or more recruiters sharing the file, clients asking for reporting, GDPR retention requirements you can't enforce manually, and time lost copy-pasting between the sheet and email. For most growing agencies that tipping point arrives around month six.
Are these recruitment tracker templates free?
Yes. All four templates — candidate pipeline tracker, requisition tracker, interview schedule, and hiring metrics dashboard — are free to download as Excel and CSV, with the formulas already wired so you can start tracking in seconds.