OmniDocApplicant Tracking Spreadsheet Template for Excel
Build a candidate pipeline spreadsheet in Excel with the right stages, columns, and checks, and learn how to open and edit the file in OmniDoc.
If you are hiring for more than one role, a shared inbox and a pile of resume files will not tell you who is waiting for feedback or which candidates have already been rejected. An applicant tracking spreadsheet template solves that problem by giving every applicant one row and every hiring step one column. You can start with a blank workbook, but most of the work is deciding which stages and fields to track before you type a single name.
This guide is for hiring managers, recruiters, and small business owners who want a simple candidate pipeline in Excel without buying a full recruiting system. You will get a column layout you can copy, a stage list that keeps the data consistent, and a set of checks that catch common errors. The steps are general Excel methods, so they work in any spreadsheet program that supports dropdown lists and filters.
Which applicant tracking spreadsheet template works for a small team? The short answer
A single workbook with one tab per open role, a fixed set of stages, and a dropdown for each candidate's current stage works well for a small team. Add a second tab for interview scheduling only if you run many interviews at once.
| Your situation | What to do | Why |
|---|---|---|
| One or two open roles | Use one sheet with a Role column and filter by role | Keeps everything in one place and avoids duplicate tabs |
| Several roles at the same time | Create one tab per role, copying the same column layout | Each role has its own counts, and the layout stays identical |
| Many interviewers involved | Add an Interviewer column and a Score column with a fixed scale | Lets you compare feedback without reading long notes |
| Hiring is occasional | Keep the stage list short, five to seven stages | Fewer stages means less data entry and fewer mistakes |
| Several people update the file | Save it in a shared location and lock the header row | Prevents accidental changes to the structure |
📊 The template at a glance
The template has four parts: the candidate record, the pipeline stage, the next step, and the decision. Keep each part in a clear group of adjacent columns so you can filter and sort quickly.
| Part | What goes in it | Suggested length |
|---|---|---|
| Candidate record | Candidate ID, name, role, source, applied date | 5 columns |
| Pipeline stage | Current stage (dropdown), stage date | 2 columns |
| Next step | Next action, next action date, interviewer | 3 columns |
| Evaluation and decision | Score, decision, decision reason, notes | 4 columns |
How to write each part
Candidate record
Give every applicant a unique ID, such as a number that increases with each application. Use the ID, not the name, as the key when you link to other files, because two applicants can share a name. Record the source (job board, referral, direct application) so you can see which channels produce candidates.
Example row: "C-014 | [candidate name] | Support Specialist | Referral | [date applied]"
Pipeline stage
Pick five to seven stages that match your real process. A common set is Applied, Screen, Interview, Assessment, Offer, Hired, and Rejected. Type the stages once in a separate list, then point the dropdown in the Stage column to that list. This keeps the spelling consistent, so a filter for "Interview" catches every interview candidate.
Add a stage date column next to Stage. When someone moves to a new stage, they update both cells. Over time, the gap between dates shows where candidates wait too long.
Example entry: "Stage: Interview | Stage date: [date moved]"
Next step
Every open candidate should have a next action, such as "Send phone screen questions" or "Collect references." Pair it with a next action date so the due date is visible. Filter by a next action date that is today or earlier to see overdue follow-ups.
Add an Interviewer column. If several people interview one candidate, separate their names with commas or add one column per interviewer.
Example entry: "Next action: Schedule panel interview | Date: [date]"
Evaluation and decision
Use a score with a fixed scale, such as 1 to 4, and write down what each number means on the template so every interviewer uses it the same way. Record a decision (Advance, Hold, Reject, Offer) and a short decision reason in the next column. A reason such as "Lacks required certification" is more useful later than a blank cell.
Use the notes column for details that do not fit a dropdown, such as availability or salary expectations. Keep the notes short and factual.
Example entry: "Score: 3 | Decision: Advance | Reason: Strong sample work, needs scheduling confirmation"
Format it in the editor
- Create a header row with the column names from the template and bold it.
- Freeze the top row so the headers stay visible while you scroll through candidates.
- Add a dropdown list to the Stage and Decision columns, pointing to a list of allowed values on a separate tab.
- Turn the range into a table or add filters to the header row so you can sort by stage, role, or next action date.
- Add conditional formatting to highlight rows where the next action date is earlier than today.
- Save the file, then check that the dropdowns, formulas, and filters still work after you reopen it.
If you want to open and edit the finished file in OmniDoc, the desktop client includes UniCell spreadsheets, so you can work with the workbook there. You can also upload an XLSX file on omnidoc.top if you need a translated copy for a candidate or hiring partner who reads another language. Check any formulas and dropdown lists after either step, because spreadsheet features can behave differently across programs.
Common mistakes
- Using free text for the stage, which creates variants such as "Interview," "interview," and "Int." and breaks counts.
- Storing applicants on paper and in the spreadsheet at once, so the two drift apart.
- Leaving the decision reason blank for rejections, which makes later reviews difficult.
- Adding too many stages, so people skip updates and the data stops being useful.
- Sharing the file with the whole company, even though it holds personal information about applicants.
- Keeping candidate records longer than your local hiring rules and your own retention policy allow.
❓ FAQ
1. Is a free applicant tracking spreadsheet template enough for a small company?
For a few open roles, a well-structured spreadsheet covers the basics: candidate records, stages, follow-ups, and decisions. When you have a large volume of applicants or need automated emails and calendar sync, a spreadsheet will require more manual work. Look for a template that is easy to change, so you can adjust stages to fit your process.
2. Should I put salary expectations in the applicant tracker?
You can record them in the notes column if your team needs them to decide. Keep the information limited to people who are involved in the hiring decision, and follow the pay transparency and data rules that apply where you hire.
3. How do I stop two people from editing the same candidate row?
Assign each person a set of rows or a role tab, and agree on who updates the stage. Save the file in a shared location that tracks changes, and check the file once a week to catch conflicts.
4. Can I use the same template for internships and contract roles?
Yes. Add a Role type column with values such as Full-time, Intern, or Contract, and filter by that column when you compare pipelines. The stages can stay the same.
📝 Summary
A good applicant tracking spreadsheet template uses one row per candidate, a fixed set of stages, and clear next steps with dates. Start with the columns in this guide, add dropdowns to keep the data consistent, and review overdue follow-ups each week. Protect the file, since it holds personal information about applicants.
