Recruitment tracker template

What a recruitment tracker is for

A hiring tracker answers three questions on any given Monday: what jobs are open, where every candidate sits, and who is stuck. Most teams that run hiring from a spreadsheet fail on the third question. They log applicants but never record when someone entered a stage, so a candidate can sit at "Interview" for two weeks and nobody notices until they accept another job.

That is why this template stores a date for every stage change and calculates days in stage. If you only add one thing to an existing candidate tracker in Excel, add that column.

The tracker also feeds your reporting. The stage dates give you time to hire, the source column gives you source-of-hire, and the offer columns give you acceptance rate. Those are the inputs for a monthly recruitment metrics report template, so you do not have to rebuild numbers from email threads at month end.

Why two tabs instead of one

A single sheet with one row per candidate looks simpler, but it breaks the moment one job has 12 openings or one candidate applies to two roles. Splitting requisitions from candidates fixes both. Openings, pay range, target date and hiring manager live once on the requisition row. Candidates link to it by ID.

The practical rule: one row per candidate per requisition. If Maria Lopez applies for both the day-shift and night-shift picker roles, she gets two rows with two IDs. Her outcome for one job does not overwrite the other.

Keep stage names short and fixed. Ten stages is plenty. Teams that let recruiters type free text end up with "phone screen", "Phone Scrn", "screened" and "PS done" in the same column, and every COUNTIF breaks.

Disposition reasons and compliance

Every candidate who does not get hired needs a disposition reason. This matters for two reasons. First, it tells you where the funnel leaks: if 30% of declines say "Pay expectations", your range is the problem, not your sourcing. Second, if you are a federal contractor or ever face a discrimination charge, you need to show the job-related reason each applicant was not selected.

Federal rules under Title VII and the ADA require employers to keep application and hiring records for at least one year from the record date or personnel action, and federal contractors covered by the veterans' (VEVRAA) or disability (Section 503) rules keep them for two years if they have 150 or more employees and a contract of at least $200,000 (VEVRAA) or $150,000 (Section 503). Do not delete rows from the tracker when a requisition closes. Archive the file instead.

Keep demographic data out of this sheet. Voluntary self-identification responses belong in a separate, access-restricted file, not next to the recruiter's notes. Retention and privacy rules vary by state and country, so check yours if you hire in California, Illinois or outside the US.

Running a weekly pipeline review from the tracker

A 30-minute weekly review with each hiring manager is where the tracker earns its keep. Sort the Candidates tab by requisition, then by stage. Walk through three lists: candidates waiting on the manager (interview feedback not in, final decision pending), candidates waiting on the recruiter (screens not booked, offers not drafted) and requisitions past their target fill date.

Agree on a service level for each stage. A common benchmark for hourly roles is screen within 2 business days of applying and interview feedback within 24 hours. For salaried roles, 3 to 5 days per stage is typical. Use conditional formatting to turn a row amber at the limit and red at twice the limit.

Score candidates consistently so the tracker shows quality, not just volume. A short candidate evaluation form gives each interviewer the same 1 to 5 scale, and the overall score goes in the tracker column.

When a spreadsheet stops working

A spreadsheet tracker is fine for a team of one to three recruiters filling a few dozen roles a quarter. It strains past that. The signs are familiar: two recruiters editing the same row, candidates emailed twice, managers asking for a copy that is out of date by lunch, and no record of who changed what.

Volume is the other limit. A contact center hiring a 30-person class every month typically needs 250 to 400 applicants per class. That is several thousand rows a year, each touched five or six times. At that point you want stages that update when a candidate books an interview or completes an assessment, not when a recruiter remembers to type a date. Visual hiring pipelines and a searchable candidate directory replace the two tabs here, and the column list in this template is a good starting spec for the fields you will need there.

Common mistakes with hiring tracker templates

• No stage dates. Without them you cannot calculate time to hire or spot stalled candidates.
• Overwriting history. If you change the stage and clear the old date, you lose the record. Keep one date column per milestone.
• Free-text sources. "Indeed", "indeed.com" and "IND" will report as three sources. Use a drop-down and a separate detail column.
• Sensitive notes. Recruiters sometimes type comments about age, family plans or accent into notes. Anything in the tracker can be requested in litigation. Train people to write only job-related observations.
• One shared file with no owner. Name one person who owns the structure, the drop-downs and the monthly archive.