Applicant tracking spreadsheet template (2026): free, and when to stop using it

A free applicant tracking spreadsheet layout you can copy into Excel or Google Sheets, plus an honest account of where spreadsheets break down as hiring grows.

Last updated 29 August 2026. Competitor pricing and plan limits are re-verified against each vendor’s own pages.

An applicant tracking spreadsheet is a simple way to track candidates for one or two roles: one row per candidate, columns for stage, source, dates and next action.

Spreadsheets stop working at roughly 30 to 50 candidates or two simultaneous roles, usually because two people edit at once, dates stop being updated, and nobody can tell who is waiting on a reply.

The column layout below is free to copy into Excel or Google Sheets.

What columns does an applicant tracking spreadsheet need?

Keep it to one row per candidate per role. The most common mistake is one row per candidate, which breaks the moment someone applies to a second job.

Copy this header row into Excel or Google Sheets

Candidate name | Email | Phone | Role | Source | Applied on | Stage | Stage changed on | Days in stage | Next action | Owner | Interview date | Outcome | Notes

Suggested values

Source:   Referral, Careers page, LinkedIn, Job board, Agency, Other
Stage:    Applied, Screening, Interview 1, Interview 2, Offer,
          Hired, Rejected, Withdrawn
Outcome:  Hired, Rejected - skills, Rejected - experience,
          Candidate withdrew, No response
Owner:    the person the candidate is currently waiting on

Two formulas worth adding

Days in stage:   =TODAY()-[Stage changed on]
Flag stalled:    =IF([Days in stage]>7,"CHASE","")

Two rules that keep it usable

1. One row per candidate PER ROLE. If someone applies to two jobs,
   they get two rows.
2. Update "Stage changed on" every time the stage changes. If that
   column is stale, every other number here is fiction.

Download the spreadsheet (CSV, opens in Excel or Google Sheets)

When does a hiring spreadsheet stop working?

Spreadsheets are genuinely fine for a single role with a handful of candidates, and it is worth saying so rather than pretending everyone needs software on day one.

They break in predictable ways, and usually all at once.

Two people edit simultaneously and one set of changes is silently lost.
Nobody updates the stage date, so days-in-stage becomes meaningless and stalled candidates go unnoticed.
Resumes live in a separate folder, an email thread, or someone's downloads, and matching them back to rows takes longer than reading them.
Candidate emails are sent from individual inboxes, so nobody else can see what was said or whether a reply arrived.
There is no record of who rejected whom or why, which is a problem the first time anyone asks.
Candidate personal data sits in a file that gets copied, emailed and downloaded, with no retention policy and no way to delete on request.

What replaces the spreadsheet?

The specific things a spreadsheet cannot do are shared editing with an audit trail, resumes attached to the candidate, email that the whole team can see, and automatic tracking of how long someone has been waiting.

ofper does those and is free, with unlimited jobs and candidates. Candidates move across a Kanban board, every move is recorded with who made it and when, resumes attach to the person, and rejection and interview emails go out through your own company mailbox.

One honest caveat: ofper has no CSV import, so moving an existing spreadsheet in is manual re-entry. Uploading each resume pre-fills most of the form from text extracted in your browser, but it is still work. For a spreadsheet with 200 rows, plan for it.

Questions, answered straight

Is there a free applicant tracking spreadsheet template?

Yes. The column layout above is free to copy into Excel or Google Sheets, with two suggested formulas for tracking days in stage and flagging stalled candidates.

How many candidates can you track in a spreadsheet?

In practice, around 30 to 50 for a single role. Beyond that, or across two simultaneous roles, the failure modes are concurrent edits, stale stage dates and resumes that live somewhere other than the sheet.

Is a spreadsheet good enough instead of an ATS?

For one role with a handful of candidates, often yes. It stops being adequate when more than one person needs to work the pipeline, when candidates need emailing at scale, or when you need a record of decisions.

Can I import my spreadsheet into ofper?

Not automatically. ofper has no CSV import, so candidates are added manually or by uploading a resume, which pre-fills the form from text extracted in your browser.