Hiring operations
October 17, 2026
What a recruitment spreadsheet should track before you move to an ATS
Use application IDs, owners, stage dates, and next actions to make a recruitment tracker usable. Keep sensitive notes and duplicate applications under control.
HRvana editorial team
2 min read
If your team is still using a recruitment spreadsheet, make the information easy to understand before replacing the tool. A clear tracker also makes a later ATS import easier to plan.
Use one row per application. When the same person applies for two roles, create two application rows and connect them through a candidate identifier. Otherwise, a decision on one vacancy can overwrite the status of the other.
Start with operational fields
| Field | Why it belongs |
|---|---|
| Application ID | Distinguishes one application from another |
| Candidate ID and name | Connects applications to a person |
| Job reference | Identifies the vacancy without relying on a changing title |
| Current stage and stage-entry date | Shows where the application is and how long it has waited |
| Owner | Names the person responsible for progress |
| Next action and due date | Makes the next handoff explicit |
| Outcome and outcome date | Separates finished work from active applications |
Add a restricted reference to documents rather than embedding resumes in a widely shared file. Review permissions on the linked folder too: protecting the spreadsheet does not automatically protect the attachments.
Keep values consistent
Choose a small set of stage names and use data validation where your spreadsheet supports it. Free-text variants such as "interview," "interviewing," and "first call" make reports difficult to interpret.
Use an unambiguous date format and agree which time zone applies when you record times. Do not use cell color as the only indicator of status; people should be able to read and filter the actual value.
Keep a separate job list with job references, owners, and open or closed status. This reduces the chance that an application points to a role nobody is recruiting anymore.
Limit what belongs in a shared tracker
Avoid broad columns for personal impressions or unrelated personal information. Store assessment evidence in the controlled location your organization has approved, and share only what each participant needs.
Define who can edit records, who checks duplicates, and how closed applications are handled under your records policy. A spreadsheet does not enforce those decisions for you.
Know when upkeep has become the problem
Keep track of time spent reconciling versions and correcting statuses. If colleagues routinely maintain their own copies or need manual reminders to find the next action, use those examples in an ATS evaluation.
The tracker should help the team coordinate current work. Once maintaining it becomes a separate recurring job, you have specific requirements to test in a replacement.
Further reading
- Free Recruitment Plan Template (Excel) | Pinpoint
- Board template - Pipelines | Tellent Recruitee | Help Center
Related guides
Related Articles
Hiring operations
Build a candidate communication timeline your team can keep
Plan application acknowledgments, interview updates, delays, and decisions with clear owners. Give candidates useful information without promising dates you cannot meet.
Hiring operations
How to update a candidate when a hiring decision is delayed
Write a hiring-delay update that explains the current stage, gives a realistic next contact date, and avoids suggesting an offer or decision that has not been approved.
Hiring operations
How to build a candidate review scorecard with usable evidence
Turn job requirements into observable assessment criteria. Use evidence, defined ratings, and a not-assessed option to make interview feedback easier to compare.
Ready to Transform
Your Career?
Create your profile, explore jobs, or find candidates. Start with HRvana today.