Template Library
Structured Interview Scorecard Template
An Excel workbook for structured interviews: define weighted criteria and rating anchors, record independent ratings, and compare candidates by weighted score.
The Role Criteria tab lists up to eight job-related criteria, each with a weight, a standard question, and anchors that describe weak, adequate, and strong answers, and it checks that the weights total 100. The Interview Scores tab records each interviewer's 1 to 5 rating for each criterion, and the weighted score calculates automatically, handling any criteria left blank.
The Candidate Comparison tab shows, for each candidate, the number of interviews, the average weighted score, and the rank, with a chart. An example role (production supervisor) and two candidates with two interviewers each are included so you can see the formulas working before you replace them.
Download Structured Interview Scorecard Template Back to Templates
What Is Included in the Workbook
| Sheet | Purpose | What Teams Capture |
|---|---|---|
| How-To | Guidance and disclaimer | Steps, notes, and fairness and privacy guidance |
| Role Criteria | Criteria, weights, and anchors | Criterion, definition, weight, standard question, and anchors for ratings 1, 3, and 5; weights check |
| Interview Scores | Interviewer ratings | Candidate ID, interviewer, 1 to 5 ratings by criterion; weighted score calculates; recommendation and notes |
| Candidate Comparison | Comparison and chart | Interviews per candidate, average weighted score, rank, and a chart |
Key Features Inside the Template
Criteria Defined Before Interviews
Weights, questions, and anchors are set up front, which keeps the team focused on the job rather than on first impressions.
Anchored Rating Scales
Descriptions of weak, adequate, and strong answers make ratings more consistent between interviewers.
Weighted Scores Automatically
The score reflects the weights you chose and ignores criteria that were not rated, so partial interviews still work.
Side-by-Side Comparison
Average scores and ranks across interviewers make it easier to discuss candidates with evidence.
Best Use Cases
- Hiring for supervisor, technician, engineer, and office roles with a panel of interviewers
- Introducing structured interviewing to a team that has relied on informal conversations
- Documenting the basis for a hiring decision consistently
- Training interviewers on how to rate against defined criteria
How to Use the Template Effectively
- Define criteria and weights from the job requirements before looking at any candidate.
- Write one standard question per criterion, with anchors for weak, adequate, and strong answers.
- Ask every candidate the same questions, and score independently before discussing.
- Record ratings and a recommendation, and discuss differences between interviewers using evidence from the answers.
- Review the comparison, and check fairness of each step with your HR and legal advisers.
Who Should Use This Template
- Hiring managers and interview panel members
- HR staff supporting fair and consistent selection
- Trainers teaching structured interviewing
Common Mistakes to Avoid
- Changing criteria or weights after seeing the candidates
- Discussing candidates before rating, which anchors everyone on the loudest opinion
- Asking different questions of different candidates
- Treating the score as the decision, instead of as one input with the evidence behind it
Important Notes
Structured Interview Scorecard Template Frequently Asked Questions
Should the weights total 100?
Yes, the workbook checks that they do, which makes the weights easy to read as percentages. The weighted score divides by the weights of the criteria that were actually rated, so a missing rating does not lower a candidate's score unfairly.
How many interviewers should rate each candidate?
Use the same panel structure for every candidate where you can, often two to four interviewers, each rating independently. The Candidate Comparison tab averages across whatever interviews are recorded, so note if a candidate had fewer interviews.
Does a high score mean we should hire?
It is one input. Use the score to focus the discussion on evidence, but the decision should also consider the notes, references, and any concerns, and your HR and legal advisers can help check that the process is fair and consistent.