The applicant tracking spreadsheet, done properly (free template + when to upgrade)

What an applicant tracking spreadsheet actually needs

An applicant tracking spreadsheet is the cheapest, fastest recruiting candidate tracker a small team can build. If you're hiring fewer than thirty people a year, a clean recruitment tracking sheet beats every enterprise ATS on speed-to-setup and beats most spreadsheets you'll find online on signal-to-noise. The trick is keeping the columns short.

The job applicant tracking spreadsheet most teams need has six columns: name, role, source, stage, date applied, and notes. Everything beyond that is optional and almost always becomes dead weight. We ship a free CSV with exactly those columns at our applicant tracking spreadsheet template — open it in Excel, Google Sheets, or Numbers.

The six columns that earn their keep

Name and role go together — one candidate per role per row, even if the same person applies twice. Source is how you found them: LinkedIn, referral, job board, inbound. You'll regret skipping this in three months when someone asks where your best hires came from.

Stage is the heart of the recruiting tracker. Use five values, no more: Applied, Phone screen, Interview, Offer, Hired. Anything richer than that belongs in notes, not in a column. Date applied is the anchor for time-to-hire math. Notes is free text — keep it timestamped if you can.

Skip: salary expectation column (put it in notes), résumé link column (use a folder), interviewer column (notes), rating column (notes). Every extra column is one more cell people forget to fill in, and an empty column trains the team to trust the sheet less.

Excel vs Google Sheets vs Airtable vs Notion

Excel and Google Sheets are equivalent for this use case. Google Sheets wins if more than one person updates the sheet — real-time sync is the only feature you'll miss in Excel. Both handle a few hundred candidates without breaking a sweat.

Airtable looks tempting because it gives you a board view. It also gives you per-seat pricing and a learning curve. For a team of two or three, a Google Sheet plus a Trello board is the same thing for free.

Notion is a great wiki and a mediocre recruiting tracker. The database is slow above a couple hundred rows and the lack of stage rules means stale candidates rot quietly. Use it for interview kits and onboarding docs, not for the candidate pipeline.

When the spreadsheet starts to hurt

There's a moment every applicant tracking sheet hits. Two people overwrite each other's edits. Someone moves a candidate to 'Offer' and forgets to tell the hiring manager. A great candidate sits in 'Phone screen' for three weeks because nobody owns the row. You start dreading the weekly hiring sync because the sheet is out of date.

That's the signal. Not because spreadsheets are bad, but because you've outgrown them — you now need stage-aging alerts, a candidate timeline, and a shared source of truth that two people can edit at once without a merge conflict.

From spreadsheet to candidate tracker without the rebuild

Recruit Flow is built for this exact moment. Upload your existing applicant tracking spreadsheet as a CSV — the column-mapper auto-detects name, role, stage, source, and date applied. Your five stages become a drag-and-drop board. Your notes column becomes a timestamped candidate timeline. Nothing gets renamed, nothing gets lost, and you can export the same CSV back out any time.

Flat $149/month, unlimited candidates, unlimited collaborators. No per-seat math, no per-job pricing, no quote calls. If you want to test the migration, grab our free candidate tracking template or applicant tracking spreadsheet template first — both are the exact CSV shape Recruit Flow imports.

Common questions about applicant tracking spreadsheets

How many candidates can a spreadsheet handle? Practically, a few hundred rows before navigation starts to hurt. The real cap is usually people, not rows — two editors is fine, four is chaos.

Do I need a separate recruitment tracking sheet per role? No. One sheet, one row per applicant, filter by role. Separate sheets per role are how teams lose track of cross-role candidates and miss source-of-hire patterns.

What about GDPR / EEO data? Don't put it in the spreadsheet. Sensitive demographic data needs access controls a Google Sheet can't give you. If you need EEO reporting, that's the moment to graduate to a real applicant tracking system.

Is Recruit Flow free? No — flat $149/month after a trial. The templates and tools (applicant tracking spreadsheet template, job application tracker, interview scorecard generator, offer letter generator, cost of hire calculator) are free forever with no sign-up.