The Candidate Tracking SpreadsheetA free template, the columns that matter, and when to walk away from it

Why a spreadsheet is a reasonable first move

Let me defend the spreadsheet for a moment, because the rest of this article is going to be hard on it. When you have one role open and one person doing the hiring, a spreadsheet is genuinely the right tool. It costs nothing. It opens in two seconds. You can reshape it on a whim without filing a support ticket or learning a new interface. There is no onboarding, no per-seat license, no migration.

Most founders and first hiring managers do not have a volume problem yet. They have a clarity problem. They want to see who applied, where each person stands, and what happens next. A clean spreadsheet answers all three. You do not need a platform to do that for your first two hires, and anyone who tells you otherwise is selling something.

The mistake is not starting with a spreadsheet. The mistake is staying on one past the point where it stops helping. To know where that line sits, you first need to build the thing properly. So here is the layout.

Making it readable

Set up stages with a dropdown, not free text

The single biggest reason hiring spreadsheets become unreadable is the stage column. Left as free text, it rots fast. One person types "Interview", another types "interview", a third writes "1st round", and within a week you cannot filter your own pipeline. Fix this on setup day with a data-validation dropdown.

In Google Sheets, select the stage column, open Data, then Data validation, and add a dropdown with a fixed list: Applied, Screen, Interview, Offer, Hired, Rejected. In Excel it lives under Data, then Data Validation, then List. Now every cell offers the same six options and nothing else. The pipeline becomes filterable, sortable, and countable. You can build a one-line pivot that shows how many people sit in each stage, which is the closest a spreadsheet gets to a real recruitment funnel view.

Two more formatting moves earn their keep. Add conditional formatting on the last-contact column so any date older than five days turns amber and anything past ten turns red. That single rule has saved more candidates from going cold than any reminder I ever set for myself. And color the stage cells by value so the sheet reads at a glance instead of forcing you to squint at text.

One last thing on tooling: use Google Sheets, not Excel, if more than one person will ever touch this. Real-time co-editing is the whole game when two people are hiring together. Excel still fights you over who has the file open. The U.S. Bureau of Labor Statistics keeps reporting millions of open jobs across the market, and in a tight race for talent the last thing you want is two recruiters overwriting each other's updates.

If you recognize two or three of those, the spreadsheet has already become a tax. The math is simple. Add up the hours your team spends each week copying applicants in, writing one-off emails, chasing feedback, and rebuilding the same pivot table. If that number is bigger than the cost of a tool, the spreadsheet is the expensive option. It just hides the bill inside everyone's evenings.

There is also a quality cost that never shows up in a cell. Decades of hiring research, including Google's widely cited work on structured interviewing, points to consistency as the thing that actually predicts good hires. A spreadsheet does nothing to enforce consistency. It will happily let one candidate get four interviews and another get two, with no record of why. A real system makes the process the same for everyone, which is both better hiring and safer ground under the EEOC guidance on selection procedures.

Making the move

How to move off a spreadsheet without losing anything

The good news is that a well-built tracker makes migration painless, because your columns already map to the fields a real system expects. Candidate, role, source, stage, and rating are standard everywhere. Most tools let you import a CSV directly, so your history comes along for the ride. You are not starting over. You are upgrading the engine under the same data.

Pick the moment deliberately. The cleanest time to switch is at the start of a new role rather than mid-pipeline, so candidates do not get caught between two systems. Export your sheet, import it, recreate your stages as pipeline columns, and run the next opening entirely in the new tool. Keep the spreadsheet read-only for a couple of weeks as a safety net, then archive it.

On what to choose, you do not need an enterprise platform to leave Excel behind. Plenty of free ATS software exists, and there are solid options built specifically for small businesses that price near what a spreadsheet costs in saved hours. If you are still fuzzy on what these tools even do, our primer on what an applicant tracking system is covers the basics without the jargon.

Whatever you pick, the test is the same one you should have applied to the spreadsheet: does it remove manual work, or just move it around? A tool that makes you maintain it as carefully as a spreadsheet is a spreadsheet with a worse interface. The point of leaving is to stop being the automation, so you can spend your attention on the part that needs a human. That is the conversation with the candidate, not the data entry after it.