Back to Blog

Recruitment Tracker Template: Free Excel & Sheets (2026)

Get a free recruitment tracker Excel download after email signup. Four templates cover candidates, open roles, interviews and a dashboard. Import into Sheets.

Janis Kolomenskis

10 min readUpdated
Share

To use the free recruitment tracker, enter a requisition and candidate in the workbook’s matching tabs, copy the sample formulas into new rows, and check that the Dashboard ranges still include your records. The workbook is an Excel file that can also be imported into Google Sheets; the email form reveals the download.

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

  1. Open the downloaded file in Excel. For Sheets, choose File → Import → Upload and create a new spreadsheet. See Google's Excel import instructions.
  2. Read the Read Me tab. Replace the fictional sample inputs without clearing the formula cells in Pipeline column L or Requisitions columns J–L.
  3. Enter dates as recognised spreadsheet dates. Add one test candidate and confirm that days in pipeline and the role's candidate count update.
  4. Use identical job titles in Pipeline and Requisitions: candidate counts match on title, not Req ID. Give two different client roles distinct titles.
  5. 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.
  6. 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:

ColumnTypeNotes
Candidate NameTextFull name
EmailTextPrimary contact
PhoneTextMobile preferred
Role AppliedTextMust match the Job Title in Requisitions
SourceDropdownLinkedIn / Indeed / Referral / Direct
Date AppliedDateWhen they entered pipeline
StageDropdownNew → Screening → Interview 1 → Interview 2 → Offer → Hired → Rejected
Stage UpdatedDateLast stage change date
Assigned RecruiterTextTeam member name
NotesTextKeep it brief
Salary ExpectationCurrencyAnnual figure
Days in PipelineFormula=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.

ColumnPurpose
Req IDUnique identifier (e.g., REQ-2026-001)
Job TitleRole name
Department / ClientWho it's for
Hiring ManagerDecision maker
PriorityHigh / Medium / Low
Date OpenedWhen req was approved
Target Fill DateWhen they need someone
StatusOpen / On Hold / Filled / Cancelled
Salary RangeBudget approved
Total CandidatesFormula: =COUNTIF(Pipeline!D:D, [Job Title])
Active CandidatesFormula: excludes Rejected/Hired
Days OpenFormula: =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.

ColumnPurpose
DateInterview date
TimeStart time (include timezone)
Candidate NameEnter the same name used in Pipeline; no automatic lookup
RoleWhich position
Interview TypePhone / Video / In-person / Panel
InterviewersNames of panel members
Meeting Link / LocationZoom link or office address
Confirmation SentYes/No — have you sent the confirmation?
OutcomeAdvance / Reject / Hold / No-show
Feedback DueDate 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.

Worked example: follow one vacancy across the workbook

Use a test role first to confirm that the workbook’s formulas and matching job titles behave as expected. This fictional example uses the existing Pipeline, Requisitions, Interviews and Dashboard tabs and does not add new workbook features.

On smaller screens, scroll the table horizontally.

A fictional role moving through the four existing tracker tabs
TabSample entryCheck before relying on the count
RequisitionsJob Title: Field Service Engineer — Rotterdam; enter Department / Client, Hiring Manager and StatusUse the same job title in Pipeline; the existing candidate count matches by title, not Req ID
PipelineCandidate Name: Mila de Vries; Role Applied: Field Service Engineer — Rotterdam; Source: Referral; Stage: Screening; Assigned Recruiter: NoorEnter Date Applied and Stage Updated as dates; retain the sample formula in Days in Pipeline and copy it down
InterviewsAdd a scheduled first interview using the workbook’s existing interview fieldsEnter the interview manually; this tab has no calculation formulas. Check that the Dashboard interview total includes the row.
DashboardReview the current stage, source and selected counts after the test records are enteredCandidate and interview totals include rows through 201; requisition totals include rows through 101 unless ranges are extended

This tracker is a shared record, not a complete event history: Days in Pipeline reflects elapsed time from Date Applied, and the current-stage offer-to-hire figure is not a historical acceptance rate. Before using it for a team review, check formula copies, date recognition, title consistency and the dashboard ranges.

Yena: approve a profile and review a shortlist

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.

Why is a candidate missing from the requisition count?

The workbook matches candidates to requisitions using the Job Title text. Check that Role Applied in Pipeline is identical to Job Title in Requisitions, then confirm the calculation formula is present and the dashboard range includes the row.

Some of our customers

Try it with your team

Compare a real search with your tracker workflow

The Yena profile screen shows the role criteria used before a search. In the trial, approve a real brief and review the returned shortlist; compare the handoff with the records your team keeps in its tracker.

  1. Approve the actual role criteria
  2. Review the returned shortlist against the brief
  3. Record the next owner and action in your tracker
Search profile
RoleRegionCriteria
Yena search profile with role, region, experience, and must-have and nice-to-have criteria

Visually prepared product view. View the original ↗

See the sourcing workflow

Janis Kolomenskis

March 19, 2026

Share
Yena

Turn a role brief into a qualified shortlist.

Describe who you need. Yena finds and ranks candidates, explains why they fit, surfaces available contact details for review, and keeps outreach in the same recruiting workspace.