Applicant Tracking Spreadsheet for Small Business

The first role I hired for, I tracked candidates in my inbox. Forty-one applications arrived over three weeks, mixed in with invoices and supplier email. Two good people never got a reply because their messages slid down the page, one candidate received the same rejection note twice, and when a colleague asked me where we stood on the shortlist, the honest answer was that I would have to go and read my inbox to find out.

The fix was not a better inbox. It was a file with one row per application, a column saying which stage that person was in, and a column saying what had to happen next. That is the whole idea behind an applicant tracking spreadsheet, and for a small business filling a handful of roles a year it is usually enough.

There are six workbooks here: a master applicant tracker, a multi-role pipeline, an interview schedule with scorecards, a source and cost per hire tracker, a funnel and time to offer sheet, and a records and retention log. Each downloads as an editable Excel file with worked sample rows, free, with no email form in the way.

What an Applicant Tracking Spreadsheet Does

An applicant tracking spreadsheet is a file with one row per job application, holding the candidate, the role, where they came from, the stage they are in, and what has to happen next. It answers two questions in a few seconds: where does every candidate stand, and what am I late on.

It is a working queue, not an archive. The rows people actually use are the active ones, sorted by whoever has been waiting longest, and the value comes from the file being current rather than complete. A tracker updated once a week is a report. A tracker updated the same day a decision is made is a hiring process.

What it will not do is the automation. It does not receive applications, remove duplicates, parse a resume, send a rejection, or remind you that a candidate has been waiting six days. All of that stays manual, which is the real cost of running hiring in a spreadsheet. Applicant tracking is coming soon to FirstHR.

The Eleven Columns That Matter

Eleven columns cover almost every small business hiring situation: candidate, role, source, date applied, stage, status, rating, next step, next step date, owner, and notes. Everything beyond those is usually a column somebody adds once and never fills in again.

The pairing that does the real work is stage and status. Stage says where the candidate is in your process; status says who owes the next move. A candidate can sit in the interview stage for a week either because you have not scheduled anything or because they have not replied to you, and those two situations need completely different actions from you on Monday morning.

Which Template Should You Use?

Start with the master tracker; it is the one that fits a single open role and does most of the job. Add the multi-role pipeline once you have two or three roles running at once, and the others when you hit the specific problem they solve.

6 Free Applicant Trackers to Download

Download all six as one bundle or take individual workbooks. Each opens in Excel, Google Sheets, or Numbers, and every one ships with sample rows so the structure is obvious. Delete the samples and enter your own candidates.

Template 1: Master Applicant Tracker

The default tracker: one row per application with stage, status, rating, owner, and the next step, plus a stage key with exit criteria and target days, and a status key naming who acts next. This is the one to use if you download only one.

Template 2: Multi-Role Hiring Pipeline

For two or more openings at once. An open roles tab with hiring manager, pay range, and target start date, a pipeline tab grouped by role showing days in stage, and a stage count tab that tells you where the active candidates are sitting.

Template 3: Interview Schedule and Scorecards

A schedule with interviewers, confirmation, and whether the scorecard came back, plus a scorecard log rating every candidate on the same four criteria out of five. Pair it with a structured interview so the scores compare across people.

Template 4: Source Tracking and Cost per Hire

A source log filled in the day an application arrives, a performance tab comparing applicants, interviews, and hires by channel, and a cost input tab that turns what you actually spent into a cost per hire figure you can defend.

Template 5: Hiring Funnel and Time to Offer

Stage counts per role so you can see where the hiring funnel narrows, a log computing days from application to offer and offer to start, and a weekly snapshot that turns single moments into a trend.

Template 6: Applicant Records and Retention Log

The tab most people skip: a disposition log capturing the job-related reason and the date the candidate was told, a retention schedule with the federal clocks written out, and a weekly audit that catches blank stages and forgotten rejections.

Stages and Statuses That Do Not Drift

Fix your stage names before the first application arrives and put them in a dropdown list, because a stage column that people type into freehand ends up holding four spellings of the same thing and cannot be counted. Ten stages cover a small business process: seven that a candidate moves through and three that end the row.

The target days are the interesting part. Add up the seven active stages and the template gives you 19 days from application to a hire handed over to onboarding, which is a deliberate default rather than a benchmark. Set your own numbers, then use them as an alarm: any row sitting past its target is the row costing you a candidate.

Closing a row properly matters as much as moving it. A rejected candidate needs a stage of Rejected, a date, a job-related reason, and an actual message sent, which is where a saved rejection email template earns its keep. Every complaint I have heard from a candidate about a small employer comes down to silence, and silence is a bookkeeping failure rather than a hiring one.

How to Build One Yourself

If you would rather build your own than download one, five decisions do most of the work: one row per application, dropdown lists for stage and status, a days in stage column, a next step with a due date, and one named owner for the file. Everything else is preference.

Mechanically, in Excel or Sheets: freeze the header row, turn on filtering across the header, put the stage and status lists on a second tab, and point data validation at those lists so the columns can only hold values you defined. Add a days in stage column computed from the date the row last moved, and use conditional formatting to color anything past your target. That combination is what makes the file sortable into a to-do list rather than a wall of text.

Two habits break more trackers than any formula. Merged cells, which destroy sorting and filtering the moment somebody uses them for a heading, and free text in a column you intend to count, which is how a source column ends up with twenty variants of the same answer. Keep countable columns closed to a short list of values and leave the prose in the notes column where it belongs.

Four Numbers Worth Counting

Four numbers are worth pulling out of a hiring spreadsheet: applied to hire rate by role, median days from application to offer, the age of the oldest open application, and hires by source with the money attached. Everything else is a nice chart that changes no decision.

Use the median rather than the average for anything time-based. With three or four hires a year, one role that dragged for two months pulls an average somewhere unrepresentative, and time to hire is a metric small businesses routinely misread for exactly that reason.

Cost per hire deserves an honest caveat. The templates divide cash spend by hires, which is easy to defend and produces a small number. Benchmark figures are much larger because they include internal time: SHRM benchmarking put the average cost per hire at nearly $4,700 (SHRM). If you want a comparable figure, add interviewer hours to the cost input tab.

What You Have to Keep, and for How Long

Applications from people you rejected are records you have to keep, generally for at least a year, and the reason each person was rejected is worth more than the resume itself. Four things sit outside the mechanics of the file and decide whether what is in it will hold up.

There is a second reason to keep applicant records that has nothing to do with an audit. The Uniform Guidelines on Employee Selection Procedures treat a selection rate for any race, sex, or ethnic group below four-fifths of the highest group's rate as evidence of adverse impact (29 CFR 1607.4). You cannot look at your own selection rates at all without a record of who applied and what happened to them, which is exactly what the disposition log holds.

When a Spreadsheet Stops Working

The limit is not rows, it is upkeep. A spreadsheet stops working when the person who owns it can no longer update it the same day decisions are made, which for most small teams lands somewhere around three concurrent open roles or roughly fifty candidates in process.

The signals are consistent. A candidate goes a week without a reply because nobody moved their row. Two copies of the file exist with different stages in them. Someone asks where a candidate stands and the answer takes three tabs and a guess. A rejected applicant gets contacted again for the same role. None of that is a technical failure; it is a manual process quietly costing you people you wanted to hire.

When that point arrives, the options are a dedicated tool or a better process, and the process fix is often the cheaper one. Applicant tracking is coming soon to FirstHR.

From Accepted Offer to Day One

The stage almost every hiring spreadsheet handles worst is the last one. The row flips to Hired, the file goes quiet, and the work that decides whether the hire actually sticks (paperwork, equipment, a plan for the first week) happens somewhere else entirely, or not at all.

Close the loop deliberately. When a row reaches Hired, the same day, send the offer letter for signature and open a new hire checklist with a start date on it. Everything you already know about that person (their source, their start date, the notes from the interview) should carry across instead of being retyped.

That handoff is where FirstHR is built to help today: onboarding with e-signature for the paperwork, task workflows so the first week is planned rather than improvised, and an employee record that starts from the moment the offer is accepted rather than from the first payroll run. FirstHR is an onboarding and HR platform, not a payroll provider or a law firm, so pair it with your payroll provider and a qualified attorney where those calls belong. Applicant tracking is coming soon to FirstHR.

Frequently Asked Questions