TemplateRead at source, 9 September 2026
Recruitment Tracker Template: Build It Here, Download the CSV
A recruitment tracker is one row per candidate, one column per thing you need to know, and one column almost every template leaves out: how long that candidate has been sitting where they are. Build yours below and download it as a CSV that opens in Excel, Numbers or Google Sheets. No email, no sign-up, no watermark. The reason the days-in-stage column earns its place is in the federal data: across the whole economy there are currently about 7.2 million open positions against 5.2 million hires a month, which works out to roughly six weeks of average life for an opening. Six weeks is far longer than a good candidate stays interested, and a sheet that cannot show you who has been waiting is a list rather than a tracker.
What a tracker is for, and what it is not
An applicant tracking system stores applications. A tracker answers a different question: what is stuck, and for how long. Those overlap enough that plenty of teams with a perfectly good ATS still keep a sheet, and the reason is usually that the ATS reports by requisition while the work happens by person. If you are a small team hiring for a handful of frontline roles, a sheet you can see in one screen beats a system you have to run a report out of.
The tracker stops being the right tool at a fairly clear line, and we would rather say so than sell you a spreadsheet you will outgrow next quarter. Once more than two or three people are updating it, once you need an audit trail of who moved whom, or once candidates arrive faster than someone can paste them in, the sheet becomes the bottleneck it was meant to remove. Until then it is genuinely better, because it is faster to change than any system.
Build your tracker
Put your open roles in, adjust the stage names to match how you actually work, and download. The file has one blank candidate row per role so the columns are already right when you open it, plus a small block at the bottom recording your stages and openings so whoever inherits the sheet can see what it was set up to do.
Recruitment tracker builder
| Role | Openings | Applicants per hire |
|---|
What the sheet has to hold
—
The columns, and what each one is actually for
Most tracker templates are a list of nouns. These eleven columns each exist to answer a question somebody will ask you on a Tuesday.
| Column | The question it answers | What goes wrong without it |
|---|---|---|
| Candidate | Who is this | Nothing. Everyone has this one. |
| Role | Which opening are they for | Strong candidates for a filled role get archived instead of redirected to the next one |
| Source | Where did they come from | You cannot tell which channel is worth its budget, so next year’s spend is a guess |
| Date applied | How long have we had them | The oldest applications quietly become the least likely to answer the phone |
| Stage | Where are they now | Two people call the same candidate; nobody calls the next one |
| Date entered stage | When did they get there | Without it the days-in-stage column cannot exist |
| Days in stage | What is stuck | The single most useful number in the sheet, and the one templates omit |
| Next action | What happens next, specifically | “Follow up” is not an action; “call Thursday am” is |
| Owner | Whose job is that | Shared ownership is the reliable way to make sure nobody does it |
| Outcome | How did it end | You lose the only record of why good people said no |
| Notes | Everything else | People invent extra columns for one-off facts and the sheet sprawls |
Days in stage is the column that pays for the sheet
There is no federal statistic for how long it takes to fill a job, and anybody quoting one to two decimal places is quoting a vendor survey. What the federal data does give you is a rough ceiling. The Job Openings and Labor Turnover Survey counts open positions as a stock and hires as a monthly flow, so dividing one by the other approximates how many months an opening lives.
The number peaked at about 7.6 weeks in 2022 and has settled around six weeks since. That is the market you are hiring into, and it is an average across an economy that includes roles taking six months to fill. For a frontline opening the useful reading is not the number itself but the gap between it and how long a good frontline candidate stays available, which is days rather than weeks. Every one of those days is visible in one column and invisible everywhere else.
The weekly ritual that makes a tracker worth keeping
Sort by days in stage, descending. Look only at the top of that list. For each one, either move it or kill it — make the call, book the interview, send the offer, or mark the outcome and let the person go. Ten minutes a week, and it is the entire discipline. A tracker nobody sorts is a graveyard with columns.
Applicants per hire is a number to measure, not to borrow
The builder asks for applicants per hire because that is what turns openings into the number of rows your sheet has to hold, but we have deliberately not filled it with a benchmark. The ratio is a property of your process, not of your industry: it moves with how tightly you screen, how fast someone calls back, and whether the role has a hard credential gate. Two employers advertising the same job in the same city routinely differ by a factor of three.
Measure your own this way. Take the last three roles you filled, count every application that came in for each of them, divide by one, and average the three. Do it again next quarter. That is a real number about your business and it is worth more than any figure we could publish. What we can tell you is the input side: across the 891 campaigns in our 2026 Social Job Advertising Benchmark, apply rates by role family ran from 5 percent for therapy roles to 31 percent for caregiver and home care, which is why an advertising budget built on someone else’s ratio goes wrong so quickly. What each metric decides, and where its number actually lives, is on recruiting analytics.
Frequently asked questions
What is a recruitment tracker?
A recruitment tracker is a spreadsheet with one row per candidate that records which role they applied for, where they came from, what stage they are at, how long they have been there and what happens next. Its job is to show you what is stuck. That is different from an applicant tracking system, which stores applications and reports by requisition.
Is this recruitment tracker template free, and do I have to give you my email?
It is free and there is no email gate. The builder runs in your browser, nothing you type is sent anywhere, and the CSV is generated and saved locally by your browser.
What columns should a recruitment tracker have?
Candidate, role, source, date applied, stage, date entered stage, days in stage, next action, owner, outcome and notes. The two most often missing are date entered stage and days in stage, and they are the pair that turns a list of names into something that tells you what to do next.
Can I open the CSV in Excel or Google Sheets?
Yes. It is a plain comma-separated file with a standard header row, so Excel, Numbers, LibreOffice and Google Sheets all open it directly. In Google Sheets use File then Import and choose to replace the current sheet.
How do I calculate days in stage?
Subtract the date the candidate entered their current stage from today. In Excel or Google Sheets, put =TODAY()-F2 in the days-in-stage cell, where F2 is the date-entered-stage cell for that row, and format the result as a number rather than a date. The file ships without the formula so it opens cleanly everywhere.
How long does it take to fill a job?
There is no federal time-to-fill statistic. An approximation from the BLS Job Openings and Labor Turnover Survey, dividing open positions by monthly hires, puts the average American opening at about six weeks of life in 2026, down from about 7.6 weeks in 2022. That is an economy-wide average across roles that vary enormously, so treat it as context rather than as a target.
When should I move from a tracker to an ATS?
When more than two or three people need to update it at once, when you need a record of who moved which candidate and when, or when applications arrive faster than someone can paste them in. Below that line a sheet is usually faster and easier to change than any system.
How many applicants do I need per hire?
It depends on your own screening and speed far more than on your industry, so measure it rather than borrowing a figure: count the applications for the last three roles you filled and average them. As a sense of the input side, apply rates in our 2026 benchmark ranged from 5 percent for therapy roles to 31 percent for caregiver and home care work.
The sheet shows you what is stuck. We fill the top of it.
Bring your open roles and how long they have been open. We will show you what applicant flow costs in your market and how fast it arrives.
Book a Demo