Tracking Applicants in a Spreadsheet: A Template and When to Stop

A spreadsheet can track applicants well for a few roles with modest volume. Use one tab per role, a row per candidate and columns for source, date applied, status, scores, reviewer, interview dates, decision with a one-line reason and a dated next step. Restrict access, limit personal data to what you need and delete it on a schedule. Move to software when volume climbs to dozens of applicants per role, several people review at once, versions drift or you need automatic communication and an audit trail. The sheet is a sound start, and its limits are predictable.

Many small teams run a good hiring process on a spreadsheet for years.

Setup: one workbook, a few tabs

Columns for the candidate tab

Use drop-down lists for stage and bucket, so that entries are consistent.

Rules that keep it clean

1. One owner per role, who maintains it.
2. Update it the same day something happens.
3. Do not store information about protected characteristics, and keep notes factual.
4. Use the same criteria for every candidate.
5. Lock the scorecard and the formulas.
6. Use filters or views, not a re-sorted master, so that rows stay stable.

Privacy and access

A spreadsheet holds personal data, so treat it that way.

• Share only with people involved in hiring, and use access controls.
• Avoid copies in email and on personal devices.
• Keep a retention date per row, and delete or anonymise on time. See GDPR and recruitment data and how long to keep candidate data.
• Respond to access and deletion requests. See candidate subject access requests and right to erasure for candidates.
• Do not put resumes in a shared folder with open permissions.

Handling the resume files

Store resumes in a folder with a naming pattern such as "RoleID-CandidateID.pdf", and link from the sheet. Keep the folder restricted. Do not forward resumes by email to many people. If you ask hiring managers to review, give them access to only that role's folder or view.

Where a spreadsheet struggles

None of these is a reason to avoid a spreadsheet at the start. They are signals for when to change.

When to move

Consider software when two or more are true:

• You regularly receive more than 50 applications per role.
• Three or more people review candidates.
• You have missed follow-ups or sent inconsistent messages.
• You need to show how decisions were made.
• You hire in several roles at once.

See spreadsheet vs ATS for a fuller comparison and applicant tracking system alternatives for small teams for options.

What software adds

A tool can take applications through a form per role, parse the resumes into structured fields, score them against your criteria, keep notes and decisions in one place and send messages. Resume World does this, with the evidence for each score shown, and it has a free plan to try; see AI resume screening software and job application forms. The best preparation for any tool is a good scorecard, which you can build in the spreadsheet first.

A sample row

"ID 0147 | Source: referral | Applied 12 Oct | Knock-outs: pass | Bucket: yes | Scores: 4, 3, 4, 2 | Reviewer: JT | Reason: led team of 6, owns billing escalations; no documentation evidence | Stage: phone screen | Next: call Tue 21 Oct | Delete by: 12 Apr."

A row like this tells anyone on the team what happened and what comes next, which is the whole point of a tracking sheet.