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 in one Excel file — formulas, dropdowns and a live dashboard pre-wired. Instant download, works in Google Sheets too.
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
An empty tracker helps nobody. If you still need candidates to put in it, the free resume search tools guide covers 12 no-cost candidate databases, and the free job posting sites guide ranks the boards that still deliver applicants without a budget.
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] |
One tip on the Target Fill Date column: for senior or niche roles, run a quick talent mapping exercise before committing to a date — pool sizing tells you upfront whether the timeline is realistic or whether you're promising a unicorn in three weeks.
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. And as the data accumulates, those same numbers become the raw material for talent intelligence — market-level insight you can take into client conversations.
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 — this is exactly what a client portal for recruitment agencies automates.
- 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, use the candidate tracking software requirements guide to decide whether you need an ATS alone or an ATS plus recruiting CRM. Yena keeps pipeline and relationship context together, while multi-client agencies may also compare options such as Yena vs Bullhorn. Test migration with a copy of the real sheet before committing.
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. When you do start evaluating, the best recruitment software for agencies comparison breaks down 12 platforms by price, AI capability, and GDPR readiness.
If your growth is being driven by AI-augmented talent 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.