HR template
Recruitment Pipeline Tracker
Candidates by stage and source, aged against today, with the funnel conversion worked out.
- Live formulas
- 56
- Columns
- 9
- File
- 10 KB
$5
Checkout opening soonOr get it with all 66 paid templates in the complete pack — $45.
Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print landscape on one page wide.
About this Recruitment Pipeline Tracker template
Good candidates accept other offers while applications sit unanswered. This Excel recruitment pipeline tracker records every candidate's role, source, stage and application date, and counts the days they have been in the process.
Candidates waiting longer than your target are flagged as stalled, and the funnel summary counts candidates at each stage, the conversion from application to interview and from interview to offer, and the average days to hire.
Good for
- →Small businesses hiring without an applicant tracking system
- →Managing several open roles at once
- →Seeing which sources produce candidates who get hired
What it works out for you
Funnel
- →Candidates in total
- →Applied
- →Screening
- →First interview
- →Second interview
- →Offer
- →Hired
- →Rejected or withdrawn
- →Application to interview rate
- →Interview to offer rate
- →Average days in process
- →Average days to hire
- →Stalled candidates
- →Came from referrals
What you fill in
The table has 9 columns. Calculated columns fill themselves in; the rest are yours to type over.
- →Candidate
- →Role
- →Source
- →Stage
- →Applied
- →Days in process
- →Next step
- →Owner
- →Stalled?
Settings in the “Service level” box
- →Flag a candidate as stalled after (days)
How to use it
One row per candidate. Days in process runs from the application date to today, so stalled candidates surface without anyone chasing.
The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.
Shaded, boxed cells below the table are settings the formulas read from. Change those first — every row that depends on them updates at once.
Functions it uses
Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.
ANDAVERAGEAVERAGEIFCOUNTACOUNTIFIFIFERRORMAXTODAYQuestions about the Recruitment Pipeline Tracker
What makes a candidate stalled?
Someone still in the process — not hired, rejected or withdrawn — who has been waiting longer than the number of days you set.
How are the conversion rates calculated?
Application to interview is the share of all candidates who reached an interview or beyond. Interview to offer is the share of interviewed candidates who reached an offer or were hired.
Is it OK to keep candidate details in a spreadsheet?
Keep the file access-controlled and delete details you no longer need. Candidate information is personal data under UK GDPR.
