Free template
Interview scorecard template, with 12 VA interview questions
This free interview scorecard template is an Excel sheet with seven weighted criteria, a 1 to 5 score for up to three candidates, and a total out of 100 that ranks them automatically. A second tab holds 12 virtual assistant interview questions, each with what a strong answer includes and the red flag to listen for.
Opens in Excel, Google Sheets, Numbers and LibreOffice. No email required.
What's in the scorecard
1.Weighted criteria
Seven criteria with a description of what a top score looks like. Weights are editable and checked so they always total 100%.
| Criterion | What a 5 looks like | Weight |
|---|---|---|
| Written English | Replies a client could receive without edits | 20% |
| Tool experience | Daily use of most tools in the job post | 15% |
| Judgement | Knows when to act and when to escalate | 15% |
| Attention to detail | Trial task returned with zero errors | 15% |
2.Automatic scores and ranking
Enter 1 to 5 per criterion. Each candidate gets a weighted score, a score out of 100 and a rank, with a decision rule you can edit.
3.12 interview questions
Each question is tied to the criterion it tests, with what to listen for. Three examples:
| Question | Strong answer includes | Red flag |
|---|---|---|
| A client emails asking to change their bank details for invoices. What do you do? | Does not act; verifies by phone with a known contact | Updates the details straight away |
| Tell me about a mistake you caught before it reached a client. | Specific mistake, how it was caught, what changed after | Claims never to make mistakes |
| What hours can you cover in our time zone, and what's your backup if your internet drops? | Exact hours, a second connection | Vague hours, no backup |
Interview scorecard questions
What is an interview scorecard template?
It is a sheet that lists the criteria for a role, gives each a weight, and has interviewers score every candidate against the same scale. The interview scorecard template here does the weighting and ranking for you, so the decision rests on evidence instead of whoever interviewed last.
How do you score candidates on an interview scorecard?
Score each criterion from 1 to 5 straight after the interview, using the 'what a 5 looks like' column as the anchor. The sheet multiplies each score by its weight and gives a total out of 100.
What questions should I ask a virtual assistant in an interview?
Ask about real situations from the role: sorting a 200-email inbox, a request to change bank details, two urgent tasks at once. The template's second tab lists 12 virtual assistant interview questions with what a strong answer includes and the red flags.
Can I change the criteria and weights?
You can. Edit any purple cell. The weight check turns red if your weights stop adding up to 100%, so the totals never mislead you.
Does the interview scorecard work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; the formulas, dropdown checks and ranking all carry over.