Download for Excel or Google Sheets
An interview scorecard records what a single interviewer learned about a candidate against criteria the team agreed before the interview. Each interviewer fills in their own copy, so their evidence is captured before the group discussion.
- Excel interview scorecard workbookAn editable scorecard and a completed synthetic example. Formulas calculate the weighted rating, exclude unassessed criteria and flag invalid inputs. No macros or signup.
- Interview scorecard templateSix example criteria across three categories, each with a question, an evidence anchor and a weight. Opens in Excel, Google Sheets or Numbers.
How to use it in Excel or Google Sheets
- 01
Open the file.
Open the XLSX workbook in Excel for the formula-based scorecard and worked example. For a plain table in Google Sheets or Numbers, import the CSV; choose comma as the separator if asked.
- 02
Replace the examples.
Swap the sample criteria, questions and evidence anchors for the role you are hiring. Keep the 1–5 meanings, or edit the wording if your team already uses different ones.
- 03
Give each interviewer a copy.
Ask them to add ratings and notes on their own sheet, leaving unassessed ratings blank. In the workbook, edit the amber cells and keep the calculated columns intact. Collect the sheets before anyone discusses the candidate.
The criteria and questions in the file are examples for a general role. Replace them with requirements from your own job description before using the scorecard with a candidate.
Score what the role needs, not a general impression.
Start from the job description. List the few things a person must be able to do in the role, then turn each into a criterion an interviewer can observe in a conversation.
- Keep the list short. Four to six criteria per interview is usually enough. A long list spreads attention thin and the ratings become guesses.
- Pair each criterion with a question. Ask every candidate the same opening question for a criterion, then follow up on what they say.
- Write down what strong evidence looks like. An evidence anchor such as “a specific example with the candidate’s own contribution and the result” helps two interviewers rate the same answer the same way.
- Split criteria across the panel. When several people interview, give each person a defined area rather than asking everyone to cover everything.
Give every number a meaning.
A rating only compares across interviewers when everyone reads the scale the same way. The template uses a 1–5 scale with a written meaning for each point:
| Rating | Meaning |
|---|---|
| 1 | No evidence or a clear concern |
| 2 | Limited evidence; important gaps remain |
| 3 | Meets the requirement for this role |
| 4 | Strong evidence with specific examples |
| 5 | Exceptional evidence across the whole question |
Leave a rating blank when the interview did not cover that criterion. A blank is not a low score: it stays out of the weighted score entirely.
Interview scorecard examples by role
These are fictional roles the site already uses in its guides. Each criterion has an opening question and an evidence anchor. Rate answers from 1 to 5 with the meanings in the scale above. They are examples to adapt, not a finished score for a real candidate.
Customer Support Specialist
A fictional support role. Rate each criterion from 1 to 5 using the scale above.
| Criterion | Opening question | Evidence anchor |
|---|---|---|
| Handling escalations | Walk us through a customer issue that had already gone wrong. | Names the issue, their own action, and what changed for the customer. |
| Written updates | How do you tell a customer that something will take longer than they hoped? | A specific message they sent, and how the customer responded. |
| Passing work on | Tell us about a time you passed a repeated problem to another team. | What they recorded, who they told, and whether it happened again. |
| Ownership | Describe a queue or account you were responsible for. | The scope, how they prioritised, and a result they can point to. |
Operations Coordinator
A fictional operations role, on the same 1–5 scale.
| Criterion | Opening question | Evidence anchor |
|---|---|---|
| Planning the day | How do you decide what gets done first when several requests arrive together? | A real day, the order they chose, and why. |
| Following through | Tell us about a task that slipped and how you caught it. | How they noticed, what they did, and how they stopped a repeat. |
| Handoffs | Describe a handoff between two teams that you organised. | Who did what, and how they checked it was finished. |
| Accuracy | Walk us through how you check a list or a schedule before it goes out. | The check they actually run, and an error it has caught. |
Talent Acquisition Coordinator
A fictional recruiting-operations role, on the same 1–5 scale.
| Criterion | Opening question | Evidence anchor |
|---|---|---|
| Scheduling | How do you set up a panel interview when calendars do not match? | The constraints, what they tried, and when the interview happened. |
| Candidate updates | Tell us about a candidate who waited longer than you wanted. | What they told the candidate, and when. |
| Written notes | How do you record what a hiring manager said after an interview? | An example note that another person could act on. |
| Care with personal information | What do you leave out when you share a candidate update? | A specific choice about what not to forward. |
| Follow-through | Describe how you make sure feedback comes back before a debrief. | The reminder they sent, and whether the feedback arrived. |
A weighted score is a summary, not a decision.
Weights (1–5) say how much each criterion matters for this role. Weighted score = the sum of weight × rating, divided by the sum of the weights of the criteria that were rated. This fictional example uses the six criteria in the template:
| Criterion | Weight | Rating | Weight × rating |
|---|---|---|---|
| Core skill for the role | 5 | 4 | 20 |
| Problem solving | 4 | 3 | 12 |
| Collaboration | 3 | 4 | 12 |
| Ownership | 3 | 2 | 6 |
| Communication | 3 | 4 | 12 |
| Interest in the role | 2 | 3 | 6 |
The result is 68 / 20 = 3.4. That is close to “meets the requirement” overall, but the single 2 on ownership is the more useful signal: the panel should look at the evidence notes behind it before deciding whether it matters for this role.
Collect the sheets before anyone talks.
The value of a scorecard is independent evidence. Ask every interviewer to submit their ratings and notes before the debrief, then discuss the criteria where ratings differ most. Record the final recommendation as Proceed, KIV (keep in view) or Do not proceed, together with the reason.
A structured scorecard makes the evidence easier to compare. It does not make weak criteria fair or guarantee an unbiased result, and the hiring team remains responsible for the decision.
Use it in Talent Intelligence Lab
In Talent Intelligence Lab, ATS scorecard templates are organised into categories and questions. A question can be a 1–5 score, a single or multiple choice, or a written description, with an optional comment box. Every job requires a scorecard, and the interviews for that job inherit it.
Each interviewer submits their own scorecard. In weighted mode the verdict follows from the weighted average: by default Proceed from 3.5 and KIV from 2.5, with thresholds you can change. In manual mode the interviewer chooses the verdict. The candidate’s record then shows how many panelists have submitted and whether their decisions are split.
See how this fits the wider interview workflow on the structured interviews page.
