Download a hiring analytics dashboard for Excel
Use this free workbook to track open requisitions, candidate movement, interviews, recruiter workload, source performance, and hiring bottlenecks in one spreadsheet. It includes a dashboard plus structured tabs for requisitions, pipeline data, reference values, today's interviews, and recommendations.
Hiring teams often have the data they need, but it is scattered across emails, interview notes, ATS exports, and recruiter spreadsheets. This free Hiring Analytics Excel template gives that information a cleaner operating system: one workbook for requisitions, candidate pipeline status, interview activity, funnel conversion, stale candidates, open roles, and source performance.
The workbook is designed for recruiting teams that want useful hiring visibility without waiting for a full BI setup. Keep the input sheets updated, then use the dashboard to spot where candidates are slowing down, which sources convert, which roles are still open, and where recruiters or hiring managers need to take action.
How to use the hiring analytics spreadsheet
The workbook works best when you treat it as a weekly recruiting operating view, not a one-time report.
- 1
Update requisitions first
Add each role to the Requisitions tab with role title, department, hiring manager, priority, location, open positions, budget, target close date, candidate counts, fill rate, days open, and comments.
- 2
Maintain the candidate pipeline
Use the Candidate Pipeline tab to track each candidate's applied date, current stage, screening result, interview round dates, offer status, joining status, compensation notes, source, and recruiter ownership.
- 3
Review the dashboard and act
Open the Dashboard and Recommendations tabs to review funnel drop-offs, stale candidates, open roles, recruiter workload, source effectiveness, priority distribution, and bottleneck alerts.
Getting Started
The spreadsheet is designed as a lightweight applicant tracking system. Follow this workflow to keep hiring data accurate and dashboard metrics reliable.
1. Start with requisitions
Create or update every open role in the Requisitions tab. Capture role title, department, hiring manager, recruiter, priority, location, budget, target close date, status, and comments. Each requisition should have a unique Req ID that is reused throughout the workbook.
2. Add candidates to the pipeline
Enter candidates in the Candidate Pipeline tab and connect them to the correct Req ID. Track source, recruiter ownership, interview dates, stage outcomes, offer status, joining status, and notes.
3. Update stages consistently
Use the predefined dropdown values for Screening, Interview Rounds, Offer Status, and Joining Status. Dashboard calculations depend on consistent values, so avoid custom spellings or manually typed alternatives.
4. Record dates for every completed stage
Whenever a candidate clears or exits a stage, update the corresponding date column. This powers the Today’s Interviews sheet and helps measure time spent in each stage.
5. Review dashboard insights weekly
Use the dashboard to monitor open positions, stale candidates, funnel conversion, recruiter workload, pending offers, source performance, and bottlenecks across active requisitions.
What the Excel file provides
The file includes six tabs: Dashboard, Today's Interviews, Requisitions, Candidate Pipeline, Reference Data, and Recommendations.
Executive hiring dashboard
Track total requisitions, open positions, filled positions, total candidates, average days open, candidates awaiting screening, stale candidates, average days in pipeline, and pending offers.
Hiring funnel and drop-off view
See how candidates move from applied to screening, interview rounds, final round, offer, and hired so you can find the stage where momentum is leaking.
Requisition and priority tracking
Monitor open, filled, cancelled, and on-hold roles by priority, department, location, hiring manager, recruiter, target close date, and days open.
Candidate pipeline tracker
Capture candidate profile details, tech stack, experience, location, compensation, notice period, source, round outcomes, offer status, joining status, and notes in one structured sheet.
Interview schedule for today
Use the Today's Interviews tab to see candidate names, roles, tech stack, experience, interview round, interview date, hiring manager, CV link, and feedback sheet link.
Bottleneck alerts and recommendations
Use built-in views for candidates stuck more than seven days, requisitions open more than 45 days, unfilled high-priority roles, pending offers, on-hold roles, and quick diagnostic benchmarks.
Best practices for maintaining a hiring tracker
- Always use the dropdown values provided in the workbook instead of typing custom stage names.
- Keep Req IDs consistent between the Requisitions and Candidate Pipeline tabs.
- Update candidate stages immediately after screening calls and interviews.
- Record interview dates to keep the Today’s Interviews view accurate.
- Avoid editing formula-driven dashboard cells or calculated columns.
- Review stale candidates and open requisitions every week to identify bottlenecks.
- Update offer and joining status as soon as decisions are made so hiring metrics remain accurate.
When this spreadsheet is useful
- You manage several open roles and need one recruiting dashboard for weekly review.
- You want to measure hiring funnel conversion without building a BI dashboard from scratch.
- Your ATS does not give recruiters and hiring managers an easy operational view.
- You need a simple candidate pipeline tracker for small teams, agencies, or startup hiring.
- You want to spot stale candidates, slow roles, pending offers, and recruiter workload issues quickly.
- You are preparing a hiring update for founders, HR leaders, department heads, or clients.
Frequently asked questions
- How do I track candidates through interview stages?
- Use the Candidate Pipeline tab and update each candidate through Screening, Round 1, Round 2, Round 3, Final Round, HR Round, Offer Status, and Joining Status. Record dates for completed stages to keep dashboard metrics accurate.
- Why are dashboard numbers incorrect?
- The most common causes are mismatched Req IDs or stage values entered outside the workbook dropdowns. Use the predefined options and ensure every candidate is linked to the correct requisition.
- Can I customize interview stages and dropdown values?
- Yes. Update the Reference Data sheet before adding new values. If you change stage names, ensure any dependent formulas, dashboards, and validations are updated as well.
- Does the workbook include an interview schedule view?
- Yes. The Today’s Interviews sheet automatically displays interviews scheduled for today and the following two days based on dates entered in the Candidate Pipeline tab.
- What is included in the hiring analytics Excel template?
- The workbook includes a Dashboard, Today's Interviews, Requisitions, Candidate Pipeline, Reference Data, and Recommendations. Together, these tabs help you track requisitions, candidates, interview stages, source performance, recruiter workload, bottlenecks, and hiring outcomes.
- Do I need advanced Excel skills to use it?
- No. Start by updating the Requisitions and Candidate Pipeline tabs. The dashboard is designed to summarize the hiring data for you, so most teams can use it as a practical tracker and review sheet without building formulas from scratch.
- How often should I update the spreadsheet?
- For active hiring, update candidate movement after every screening decision, interview round, offer update, or joining update. At minimum, refresh it before your weekly hiring review so the dashboard reflects current bottlenecks and priorities.
- Can this replace an ATS?
- It can work as a lightweight tracker for small teams, but it is not a full applicant tracking system. Use it to improve visibility, reporting, and recruiting discipline; use HireSort or your ATS for production candidate workflows at scale.
- Is the hiring analytics spreadsheet free?
- Yes. The Excel workbook is free to download and use. You can adapt it for your own roles, recruiters, interview stages, hiring managers, locations, and reporting cadence.
Related resources
- Resume Screening ToolScore a resume against any JD
- Rubric GeneratorTurn a JD into a weighted rubric
- Job Description GeneratorDraft a structured JD with AI
- Interview scorecardsStandardize interview feedback
- Screening rubricsUse consistent criteria for candidate review
- Recruitment softwareRun the full hiring workflow in HireSort