Candidate Tracking Spreadsheet: Simple Guide

Why hiring usually starts in a spreadsheet

Hiring usually starts simple. One open role. A few names. A Google Sheet. Maybe a color-coded column called 'Status.' Maybe a note that says 'strong candidate??' next to someone you meant to email three days ago.

At first, a candidate tracking spreadsheet feels perfect. It is free, flexible, familiar, and easy to share. But after a few applicants turn into twenty, then thirty, then fifty, the spreadsheet starts doing what spreadsheets always do: it becomes the place where important things slowly disappear.

A candidate moves from 'Applied' to 'Phone Screen,' but nobody remembers who spoke to them. Someone else is marked 'Interview,' but there is no note about which interview. A good applicant waits too long for a follow-up. A referral gets buried under newer names. Suddenly the hiring process is not really a process anymore. It is a list.

What is a candidate tracking spreadsheet?

A candidate tracking spreadsheet is a simple table used to manage job applicants as they move through your hiring process. Most teams use it to track candidate names, contact information, the role applied for, application source, current hiring stage, interview dates, notes, follow-up status, and final hiring decision.

For small teams, founders, agencies, local businesses, and early-stage startups, a spreadsheet can be a good first step. It gives you one place to see who applied, where they came from, and what needs to happen next.

But a spreadsheet is not the same thing as a hiring workflow. It stores information. It does not automatically remind you who is waiting, which candidates are stale, which source brings the best applicants, or whether your team is following the same process. That is the difference between tracking candidates and managing candidates.

The columns that actually earn their place

A good applicant tracking spreadsheet should be simple enough to use every day. If it has too many columns, people stop updating it. If it has too few, you lose important context. Start with Candidate Name — use the full name so the sheet is easy to search. Add Email Address in its own column, never buried inside notes. Phone Number is optional but useful for phone screens or local hiring.

Role Applied For is essential if you're hiring for more than one position — without it, your sheet quickly becomes one mixed list of people who belong to different processes. Candidate Source (Referral, LinkedIn, Indeed, Company website, Cold outreach, Recruiter, Job board) is more valuable than it looks — over time it tells you which channels actually produce good candidates. Maybe LinkedIn brings the most applicants, but referrals produce the most hires. You won't know unless you track it.

Current Stage is the most important column. A simple pipeline: Applied, Phone Screen, Interview, Offer, Hired, Rejected. Don't create too many stages at the beginning. Date Applied helps you measure how long candidates have been waiting — hiring speed affects candidate experience, and good candidates often have other options.

Last Contacted Date is the most underrated column. A candidate can look active in your spreadsheet while actually being ignored. If you only add one column to your current sheet today, add this one. Next Step prevents the worst hiring problem: vague status. 'Interview' is not a next step. 'Send interview feedback to hiring manager' is a next step.

Owner names the person responsible for moving the candidate forward — without ownership, everyone assumes someone else followed up. Notes should be short and factual: 'Strong portfolio, especially mobile work' beats 'Good' or 'Maybe.' A simple 1–5 Rating or label (Strong, Maybe, Not a fit, Backup) helps you sort, but don't turn it into a complicated scoring system. Decision (Hired, Rejected, Withdrew, No response, Keep warm) closes the loop and keeps the sheet clean.

A simple template you can copy

Use one row per candidate with these columns in order: Candidate Name, Email, Role, Source, Stage, Date Applied, Last Contacted, Next Step, Owner, Notes, Decision.

A row might read: Jordan Patel · jordan@email.com · Product Designer · Referral · Interview · June 1 · June 5 · Send portfolio task · Brittney · Strong visual work · Pending. Another: Sam Okafor · sam@email.com · Backend Engineer · Company Site · Applied · June 3 · June 3 · Review CV · Hiring Manager · Python experience · Pending.

This is enough for a small hiring process. The mistake many teams make is adding too much too soon — twenty columns, complicated formulas, color rules, hidden tabs, dropdowns nobody updates. A hiring tracker is only useful if people actually use it.

When a spreadsheet works well

A spreadsheet can work if you have one open role, fewer than 20–30 candidates, one person owning the hiring process, no need for reminders, no need for candidate history, no real team collaboration, no multiple pipelines, and no source-reporting requirements.

For very small hiring processes, a spreadsheet is often enough. There is no need to buy software before you have a real problem. But once hiring becomes active, the spreadsheet starts to show its limits.

Where spreadsheets quietly break

A spreadsheet usually breaks in quiet ways. It does not announce that it is failing. It just becomes less reliable. First, nobody knows who needs follow-up — a candidate can sit in 'Phone Screen' for days without anyone noticing. If you have to manually scan rows to find neglected candidates, the spreadsheet is no longer helping enough.

The status column becomes messy. Clean stages give way to 'interviewed,' 'Interviewed,' '1st interview,' 'interview done,' 'call scheduled,' 'maybe,' 'pending,' 'follow-up,' 'waiting,' 'not sure.' Now your pipeline is a collection of inconsistent labels, which makes filtering, reporting, and decisions harder.

Candidate notes get lost. A hiring process needs a timeline — what happened, when it happened, what should happen next — but spreadsheets compress all of that into one messy notes cell. Multiple people editing the same sheet make mistakes likely: wrong row edits, filters left on, overwritten notes, duplicates.

You cannot see the pipeline clearly. A spreadsheet shows rows; hiring is more naturally understood as movement. You cannot easily measure candidate sources — most teams track source but never turn it into useful insight, so they keep guessing about which channels are worth their time. And good candidates go stale. Spreadsheets can store dates but they don't alert you when someone has been waiting too long. In hiring, forgotten follow-ups are expensive — you lose momentum, trust, and good people.

Spreadsheet vs simple hiring tracker

A candidate tracking spreadsheet is best for storing applicant information. A simple ATS is best for managing the hiring workflow. Both store candidate names and let you import and export CSV. Both can hold notes.

The differences show up where hiring actually fails: a hiring tracker shows the pipeline visually, has built-in follow-up reminders, makes source tracking easier, handles team collaboration cleanly, and keeps a real candidate timeline. The key question isn't 'Do I need software?' The better question is: 'Are we losing track of candidates?' If the answer is yes, the spreadsheet has done its job — it helped you start. Now you need a cleaner system.

The best hiring pipeline stages for small teams

If you are building your first candidate tracker, keep the stages simple. Applied means the candidate has applied, been referred, or been added manually — next step is usually to review the CV, resume, portfolio, or profile. Phone Screen is an early conversation for checking basic fit, availability, salary expectations, and interest.

Interview is the main evaluation process — technical interview, portfolio review, manager interview, trial shift, writing task, or team conversation depending on the role. Offer means you're preparing or discussing an offer — watch this stage carefully, offer-stage candidates need fast communication. Hired is signed and joining; keep notes for onboarding context. Rejected does not always mean bad — they may not fit the role, timing, salary range, location, or experience level.

An optional Keep Warm stage is extremely useful for small teams. A good candidate may not fit today's opening but could be perfect later.

How to keep your hiring spreadsheet clean

If you are staying with a spreadsheet for now, a few rules help. Use dropdowns for stages — don't let everyone type their own stage names. Add a Last Contacted column so you can quickly find candidates who may need a follow-up. Keep notes short and factual; instead of 'Seemed really nice and might be good but need to talk to Sarah and then maybe send another email,' write 'Strong call. Sarah to review portfolio. May have another offer.'

Review the sheet daily during active hiring — a five-minute scan can prevent missed follow-ups. Ask: who applied since yesterday, who has not been contacted, who needs a decision, who is waiting on us, who should be rejected respectfully, who should move forward. Archive closed candidates so the active pipeline stays focused. Track source from the beginning, not later. Use one row per candidate — don't create separate rows for every interview.

When to move from a spreadsheet to a hiring tracker

Consider moving away from a spreadsheet when you have more than 20–30 active candidates, are hiring for multiple roles, have more than one person managing candidates, are missing follow-ups, are letting candidates sit too long in one stage, need to see a visual pipeline, want source reporting, want cleaner notes and candidate history, or are simply tired of manually updating the same sheet.

The point is not to make hiring complicated. The point is to make it visible. A good hiring tracker should feel like a cleaner version of the spreadsheet you already use, not a giant system you need training to understand.

What a simple hiring tracker should include

If you move beyond a spreadsheet, look for a tool that keeps the basics strong. You probably do not need a huge enterprise ATS if you are a small team. You need a candidate list with both table and board views, simple hiring stages, candidate notes, a candidate timeline, source tracking, follow-up reminders, stale candidate alerts, CSV import and export, search and filters, and simple collaboration.

Avoid tools that create more work than they remove. The best hiring software for a small team is the one people actually use.

Why follow-up is the real hiring bottleneck

Most small teams do not fail at hiring because they lack applicants. They fail because the process gets slow, unclear, and inconsistent. A candidate applies. Someone reviews them. Someone else says they look good. Then the conversation moves to email, Slack, WhatsApp, or a meeting. A few days pass. Nobody knows who owns the next step. That is how good candidates go cold.

The best hiring systems are not just databases. They protect momentum. They answer: who needs a reply, who has waited too long, who is ready for the next step, who needs a decision, who should we close out. This is why 'last contacted' and 'next step' are more important than most teams realize. A hiring process is not just a list of people. It is a list of promises you have made to people.

How Recruit Flow fits in

Recruit Flow is built for teams that have outgrown a messy hiring spreadsheet but do not want a complicated ATS. You can upload your candidate list, organize applicants into a clean pipeline, switch between table and board views, track where candidates came from, and see who may be going stale.

It is designed for the practical middle ground: more organized than a spreadsheet, simpler than a traditional ATS, built for small teams that need clarity fast. If your current hiring process lives in Google Sheets, email threads, and memory, Recruit Flow gives you one calmer place to manage it.

Frequently asked questions

What is the best way to track job candidates? Use a simple system with candidate name, role, source, current stage, last contacted date, next step, owner, notes, and final decision. For a very small process, a spreadsheet can work. For a growing pipeline, a simple hiring tracker is usually easier to manage.

Can I use Google Sheets as an applicant tracking system? Yes, if your hiring process is small — one role, one hiring owner, a limited number of candidates. Once you have multiple roles, several team members, or missed follow-ups, a dedicated hiring tracker becomes more useful.

When should I stop using a hiring spreadsheet? When candidates are getting lost, follow-ups are being missed, stage names are inconsistent, multiple people are editing the sheet, or you cannot easily see who needs action. These are signs that the spreadsheet is no longer managing the process clearly.

What is the difference between a candidate tracker and an ATS? A candidate tracker is usually a simple tool for organizing applicants, stages, notes, and follow-ups. An ATS is often a larger recruiting platform with job postings, workflows, compliance features, automations, and integrations. Small teams may only need a simple tracker, not a full ATS.

How do I know if a candidate is stale? When they have not been contacted or moved forward in too long. Many teams treat candidates as stale after several days with no update. Tracking the last contacted date makes them easier to spot.

What is the simplest hiring pipeline? Applied, Phone Screen, Interview, Offer, Hired, Rejected — with an optional Keep Warm stage for good candidates who may be useful for a future role.

Final thought

A candidate tracking spreadsheet is a good place to start. It gives structure to the early chaos of hiring. It helps you collect names, sources, notes, and decisions. It is familiar and flexible.

But the moment your team starts asking 'Did anyone follow up with her?' or 'Where is that great candidate from last week?' the spreadsheet is no longer enough. Hiring does not need to be complicated. But it does need to be clear. Start with a simple tracker. Keep your stages clean. Record the next step. Watch for stale candidates. Track your sources. Make sure every good applicant has an owner.

Because the best candidate in your pipeline is not always the newest one. Sometimes it is the one quietly waiting for a reply.