Job Applicant Tracker Spreadsheet: Track Every Candidate from Application to Offer
Build a job applicant tracker spreadsheet for a small business: one row per application, hiring stages, a weighted interview scorecard, days-in-stage alerts, a funnel by source, and record-keeping and privacy basics.
A job applicant tracker spreadsheet logs every application on one row (the role, where the candidate came from, the current hiring stage, the date of each step, interview scores and the next action) so you always know how many people are at each stage, who is waiting to hear back and which sources bring candidates you actually hire. For a small business that hires a few times a year, it is a simple alternative to an applicant tracking system. This guide covers the tabs, the formulas, a scorecard and a complete hiring example.
The tabs
| Tab | One row per | Key columns |
|---|---|---|
| Openings | Open role | Job ID, title, hiring manager, date opened, target start date, status |
| Applicants | Application | Name, email, phone, job ID, source, stage, date of each stage, score, next step, reason closed |
| Scorecards | Interviewed candidate | Score per criterion, weighted total, interviewer |
| Dashboard | Opening | Funnel, time to hire, results by source |
Use drop-down lists for stage (Applied, Phone screen, Interview 1, Final interview, Offer, Hired, Rejected, Withdrew), source (job board, company website, referral, social media, school or program) and reason closed. Consistent values are what make the counts work.
Formulas that keep things moving
- Days in current stage:
=TODAY()-[@[Last stage date]], highlighted orange after 5 days so nobody is left without an answer. - Applicants per stage for one opening:
=COUNTIFS(Applicants[Job ID],$B$1,Applicants[Stage],A4) - Time to hire:
=[@[Hire date]]-[@[Date opened]] - Interviews by source:
=COUNTIFS(Applicants[Source],A2,Applicants[Interviewed],"Yes") - Offer acceptance rate: offers accepted ÷ offers made, worth tracking if candidates often turn you down.
A weighted interview scorecard
Before interviewing, agree four or five job-related criteria, their weights, and a 1–5 scale with a short description of what a 3 and a 5 look like. Every interviewer scores every candidate the same way, so decisions rest on evidence rather than the last conversation.
| Criterion | Weight | Candidate A | Candidate B |
|---|---|---|---|
| Front-desk or scheduling experience | 30% | 4 | 5 |
| Phone role-play with a patient | 25% | 5 | 3 |
| Practice software and insurance basics | 20% | 3 | 4 |
| Availability for early shifts | 15% | 4 | 4 |
| Written communication sample | 10% | 4 | 3 |
| Weighted score | 100% | 4.05 | 3.95 |
Total: =SUMPRODUCT($B$2:$B$6,C2:C6). The scores are close, and the role-play, the closest match to what the job involves every day, tips the decision to candidate A. Keep criteria tied to the job and apply them equally to everyone.
Example: front desk coordinator at a physical therapy clinic
| Stage | Applicants | Moved on |
|---|---|---|
| Applied | 95 | 25% |
| Phone screen | 24 | 38% |
| Interview 1 | 9 | 33% |
| Final interview and role-play | 3 | 33% |
| Hired | 1 |
Time to hire was 26 days. The source tab showed that a job board produced most applications, but two of the three finalists came from employee referrals and the local community college. For the next opening, the clinic will post internally and with the college first.
Records and privacy
Applications contain personal information. Collect only what you need to evaluate the role, limit who can open the file, and do not record information unrelated to the job, such as age, family plans or health. U.S. federal rules generally require employers to keep hiring records for a period after the decision, and state rules may add to that, so set a retention period and delete records once it ends. Check the requirements that apply to your business with an HR adviser.
A short, polite message to candidates you did not select protects your reputation as an employer; add a “Closed – notified” stage so you can see who still needs one.
After the hire
The new employee moves to the employee onboarding checklist, the employee schedule and the payroll template, and the org chart is updated. Agree the next opening’s criteria in a short kickoff and keep the notes with the meeting minutes template. More guides are in Recruitment & Applicant Tracking.
Frequently asked questions
What should an applicant tracker include?
Candidate name and contact, role, source, current stage with dates, interview scores, next action and the reason an application was closed.
How many hiring stages should a small business use?
Usually five or six: applied, screen, one or two interviews, offer and hired. Each extra round adds days, and strong candidates accept other offers.
When is it worth paying for an applicant tracking system?
When several roles are open at once, several people interview, or you want job posts and applications to flow in automatically.
Does the tracker work in Google Sheets?
Yes. COUNTIFS and SUMPRODUCT behave the same, and a Google Form can feed new applications into the sheet; restrict sharing because it holds personal data.