Recruitment Pipeline Template: A Free Framework You Can Set Up Today

Define the stages before you track them

Before you can track a pipeline properly, you need to know what stages actually belong in it. A lot of recruiting spreadsheets fail not because spreadsheets are the wrong tool, but because the pipeline itself was never clearly defined — stages get invented ad hoc, different recruiters use different labels, and nothing lines up when it's time to report.

The core pipeline stages

1. Sourced — a candidate has been identified but not yet contacted. This stage matters because it separates "people we know about" from "people we've actually engaged."

2. Contacted — outreach has been made, but no response yet.

3. Responded / Engaged — the candidate has replied and expressed some level of interest. This is your first real signal of pipeline health for a role.

4. Screened — an initial conversation has happened to confirm basic fit, availability, and interest before investing further time.

5. Submitted to client — the candidate has been formally presented to the client or hiring manager for a specific role.

6. Client interview scheduled — worth tracking separately from "submitted," since the gap between submission and interview is itself a useful metric.

7. Interviewing — active interview stage; track how many rounds and where the candidate currently sits.

8. Offer extended — an offer has been made but not yet accepted.

9. Offer accepted / placed — the candidate has accepted and the placement is confirmed.

10. Not progressing — keep candidates here with a reason code (not qualified, withdrew, chose another offer, timing). This is the data you need later to spot patterns in why candidates fall out.

Fields to track for every candidate

Beyond the stage itself, a usable pipeline needs: candidate name and contact info; role(s) they're associated with; source such as referral, job board, outbound, or database; date entered current stage; last contact date; next follow-up date; a running notes and history log; and the client or requisition they're attached to.

Setting this up in a spreadsheet

A simple version: one row per candidate, one column per field above, with "Stage" as a dropdown using the ten stages listed. Add a second tab per open role if you want role-level views, or use a filter view on the master sheet.

This works — for a while. The limitations show up fast once more than one person is updating it: two recruiters editing simultaneously, stage definitions drifting between people, and "last contact date" quietly going stale because updating it is an extra manual step nobody remembers.

When to move past the spreadsheet

This template is a genuinely solid starting point for a solo recruiter or a very small team. The signs you've outgrown it: more than one person needs to update the same pipeline; you want automatic reminders for follow-ups instead of relying on someone checking a column; you need reporting (time in stage, drop-off by reason) without manually building a pivot table; or candidates in the "Not Progressing" stage need to be searchable and resurfaced for future roles.

At that point, the stages above map directly onto what recruitment tracking software does automatically. RecruitFlow uses this exact pipeline structure by default, so if you outgrow the spreadsheet version, the transition is mostly just importing your existing data rather than rebuilding your process from scratch.