Get a free recruitment tracker template for Excel, with four working tabs for candidates, open roles, interviews and a dashboard. Enter your email in the form below to reveal the .xlsx download on this page. You can also import that file into Google Sheets. There is no separate Sheets copy link or CSV pack.
The workbook includes sample records and formulas, but it still needs a little setup: replace the examples, copy calculation formulas into new rows and check the dashboard ranges as your list grows. It does not send reminders, enforce retention or keep a complete activity history.
Not every agency needs an ATS from day one. A shared tracker can be a practical starting point when someone owns its upkeep and everyone uses the same stage definitions.
Get the free recruitment tracker Excel download
Enter your email to reveal one .xlsx workbook with four templates and sample rows. Google Sheets users can import the file.
How to set up the Excel or Google Sheets tracker
- Open the downloaded file in Excel. For Sheets, choose File → Import → Upload and create a new spreadsheet. See Google's Excel import instructions.
- Read the Read Me tab. Replace the fictional sample inputs without clearing the formula cells in Pipeline column L or Requisitions columns J–L.
- Enter dates as recognised spreadsheet dates. Add one test candidate and confirm that days in pipeline and the role's candidate count update.
- Use identical job titles in Pipeline and Requisitions: candidate counts match on title, not Req ID. Give two different client roles distinct titles.
- Copy the sample-row formulas down as you add records. Review formulas that end at candidate/interview row 201 or requisition row 101 before exceeding those ranges.
- Share only with people who need access. Agree who updates stages, checks stalled candidates and removes records when they are no longer needed.
The column tables below describe the downloadable workbook. Suggested extra checks are labelled separately so you can distinguish existing features from changes you may want to make.
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 | Text | Must match the Job Title in Requisitions |
| 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 | Text | 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.
Optional conditional formatting rules to add:
- 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 | Enter the same name used in Pipeline; no automatic lookup |
| 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 — have you sent the confirmation? |
| 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.
The included Dashboard reads the Pipeline, Requisitions and Interviews tabs. It shows:
- Current pipeline: Candidate counts by stage, plus total, active and hired counts.
- Source mix: Counts of candidates by source, not a comparison of source-to-hire conversion.
- Elapsed time: Average days in the active pipeline and average days for open requisitions.
- Activity counts: Open requisitions and interviews entered in the schedule.
- Offer-to-hire ratio: Hired candidates divided by candidates currently marked Offer or Hired. This is a snapshot, not historical offer acceptance.
Not included: Historical time-to-hire, time-to-fill, cost per hire and offer acceptance need extra dates, spend or event records. A current stage alone cannot reconstruct that history. Choose definitions with the recruitment KPIs guide before adding calculations. For a separate reporting example, see the recruitment KPI dashboard template.
Want these templates pre-built?
Enter your email to reveal the same free .xlsx workbook. Four working tabs plus setup notes; import the file into Google Sheets if needed.
Google Sheets vs Excel: Which to Use?
Google Sheets is useful when your team already shares work in Google Workspace. Import the Excel file, then check that dates, dropdowns and sample calculations behave as expected in your account.
Excel fits teams already working in Microsoft 365. Supported versions allow co-authoring through OneDrive or SharePoint, so simultaneous editing is not exclusive to Sheets. Avoid circulating separate email copies.
Use the tool your team can maintain consistently. The file does not require macros, and neither application turns a spreadsheet into a complete ATS.
When Spreadsheets Stop Working
There is no universal role count or team size at which a spreadsheet stops working. Watch for recurring problems:
- Unclear ownership. Candidates go without follow-up because nobody knows who is responsible.
- Missing history. Recruiters overwrite context or contact the same person without seeing earlier 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.
- Access and retention controls. This workbook does not automatically restrict each consultant to their own candidates or delete records on a schedule.
- 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.
Don't change systems just because the spreadsheet looks basic. Change when its recurring upkeep or missing controls justify the cost, and test an export before committing.
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
Are these recruitment tracker templates free?
Yes. Enter your email in the form to reveal the free .xlsx download on this page. The workbook contains Pipeline, Requisitions, Interviews and Dashboard tabs, plus a Read Me. It is one Excel file, not separate CSV files or a hosted Google Sheets template.
Can I use the recruitment tracker in Google Sheets?
Import the downloaded .xlsx file into a new Google Sheets spreadsheet using File > Import > Upload. Check date recognition, dropdowns and formulas with a sample candidate before entering live information. No separate Google Sheets copy link is provided.
What does the recruitment tracker include?
The Pipeline tab has 12 columns for candidate contact details, role, source, application date, stage, stage update, recruiter, notes, salary expectation and days in pipeline. Requisitions counts candidates by job title; Interviews records scheduled interviews; Dashboard summarises stages, sources and selected counts.
Are the formulas ready for every new row?
Calculation formulas are present in the sample Pipeline and Requisitions rows. Copy them down when adding records. Some Dashboard totals stop at row 201 for candidates and interviews, and row 101 for requisitions; extend those ranges when needed. Role titles must match between Pipeline and Requisitions.
Does the workbook calculate time-to-hire or offer acceptance?
It measures elapsed days and current stage counts, not a full history of hiring events. Time-to-hire and time-to-fill need extra hire and closure dates. The existing offer-to-hire figure is a current-stage ratio, not a historical offer acceptance rate.
When should I move from a spreadsheet to an ATS?
Consider an ATS when duplicate candidates, missing history, access restrictions or manual client reporting repeatedly cause problems. There is no universal role count or month when every agency must switch. Test migration and permissions against your real workflow.