Free guide

Recruiting Pipeline Tracker in Excel: Free Template and Step-by-Step Setup

If you hire a few people a year, a full applicant tracking system (ATS) is often overkill: monthly fees, setup time and features you'll never use. But tracking candidates in your inbox is worse — people fall through the cracks, nobody knows who is waiting for feedback, and you can't tell which job board actually works. A well-built spreadsheet sits in the sweet spot. This guide shows you exactly how to set up a recruiting pipeline tracker in Excel or Google Sheets, including the columns, the stages, a few formulas that do the heavy lifting, and a simple dashboard.

What a pipeline tracker needs to do

A good tracker answers five questions at a glance:

1. Who is in the pipeline for each open role, and at what stage?
2. Who is waiting on us (feedback, scheduling, an offer)?
3. Where do our best candidates come from?
4. How long does it take to fill a role?
5. Where do candidates drop out?

If your spreadsheet answers these, it's doing its job. Everything else is decoration.

Step 1: Define your stages

Keep stages few and unambiguous. A typical small-company pipeline:

1. Applied / Sourced
2. Screen (CV review or short phone call)
3. Interview (one or more rounds)
4. Final / Work sample
5. Offer
6. Hired
7. Rejected / Withdrawn (with a reason)

Put the stage list on a separate "Lists" sheet and use Data Validation (Data → Data validation → List) so every row uses exactly the same spelling. Consistent values are what make counting possible.

Step 2: Set up the columns

Here is a free mini-template. Create these headers in row 1 of a "Candidates" sheet:

Format the range as a Table (Ctrl+T in Excel). Tables expand automatically, keep formulas consistent and make filtering trivial.

Step 3: Add formulas that save time

• Days to hire (column K): =IF(J2="","",J2-D2) — difference between hire date and application date.
• Days since last action (helpful extra column): =IF(OR(E2="Hired",E2="Rejected"),"",TODAY()-F2). Add conditional formatting to highlight anything above 5 days in red. This single column is the best defense against ghosting candidates.
• Count per stage (on a dashboard sheet): =COUNTIFS(Candidates[Role],$A2,Candidates[Stage],B$1).
• Hires by source: =COUNTIFS(Candidates[Source],A2,Candidates[Stage],"Hired").
• Average days to hire: =AVERAGE(Candidates[Days to hire]).

All of these work identically in Google Sheets if you replace structured references with normal ranges (e.g. E:E).

Step 4: Build a one-screen dashboard

On a "Dashboard" sheet, create three small blocks:

1. Pipeline by role: roles down the side, stages across the top, COUNTIFS in the grid. Add a clustered bar chart to visualize where each role is stuck.
2. Source effectiveness: for each source, count applicants, interviews and hires, then calculate hires ÷ applicants. You'll often find referrals convert several times better than job boards.
3. Speed and backlog: average days to hire, number of open roles, and number of candidates with more than five days since last action.

Keep the dashboard to one screen. If you have to scroll, nobody will look at it.

Step 5: Make it a habit

A tracker is only as good as its updates. Simple rules that work:

• Update the row the same day anything happens — a call, a rejection, a scheduled interview.
• Every active candidate must have a "next step" and an owner.
• Review the dashboard once a week for 10 minutes: what's stuck, who's waiting, which role needs more sourcing.
• Always fill in a reason when someone is rejected or withdraws. Over time this tells you whether your job ads, salary or process are the problem.

Spreadsheet vs. ATS: when to switch

A spreadsheet tracker comfortably handles a few roles and up to a few hundred candidates a year. Consider an ATS when you have many hiring managers who need separate access, high application volume needing automated screening, or compliance needs such as automated data-retention and consent tracking. Until then, a spreadsheet costs nothing per month and you fully control it.

Privacy and data hygiene

Candidate data is personal data. Store the file in an access-controlled location, share it only with people involved in hiring, and delete or anonymize rejected candidates' details after the retention period that applies in your country. Avoid recording anything irrelevant to the job.

A weekly 10-minute review routine

Open the dashboard every Monday and work through the same short list. First, filter for candidates whose "days since last action" is above five and send each one an update, even if it's only "we're still reviewing." Second, look at each open role's stage counts: a role with many applicants but nobody at interview stage needs faster screening, while a role with almost no applicants needs better sourcing or a rewritten job ad. Third, check the source table and pause spending on any paid channel that hasn't produced an interview in a month. Fourth, confirm that every active candidate has a named owner and a next step. Finally, archive closed roles to a separate sheet so the main view stays clean. This routine takes ten minutes, keeps candidates from being ghosted and turns the tracker from a record into a management tool. Over a quarter, the habit usually saves far more time than it costs, because problems are caught while they are still small and cheap to fix.

Frequently asked questions

Excel or Google Sheets? Either works. Google Sheets is easier for real-time collaboration; Excel has stronger tables and charts offline.

Should I track one role per sheet? No — keep all candidates in one table with a Role column. Separate sheets make reporting much harder.

How do I link interview scores? Enter the average from your interview scorecards into the score column so you can sort candidates objectively.

Prefer to skip the setup? The Recruiting Pipeline Tracker is a ready-made Excel file with stage dropdowns, automatic time-to-hire, stale-candidate alerts and a built-in dashboard. For the metrics behind it, see how to calculate time to hire.

← More hiring guides