Free Call Center QA Scorecard Template (Excel)
What's inside the free call center QA scorecard
The file has two sheets. The first is a QA Scorecard matrix: five weighted criteria down the side, up to five calls across the top, and a score cell for each combination. The second is an Agent Log, where you record each scored call by agent, date and call ID.
The criteria are pre-built for a typical QA program — greeting and compliance, discovery and listening, solution accuracy, soft skills and tone, and wrap-up and documentation — with default weights you can adjust to match your own quality framework.
Weights, criteria, and how the score calculates
Each of the five criteria carries a weight (defaults: 20%, 20%, 25%, 20%, 15%), and the weighted total per call calculates automatically from your 1-5 scores. Change the weights to match how your program actually values each area — solution accuracy might matter more for a technical support team, soft skills more for a retention team.
In the Agent Log, each scored call's QA score feeds a Result cell that shows PASS at or above an 85% threshold and FAIL below it. If your program uses a different passing bar, you can edit the 0.85 in the Result formula after unprotecting the sheet (password: tt).
Scoring multiple calls and tracking pass rate
The QA Scorecard sheet handles five calls at a time — enough for a spot-check session or a single evaluator's weekly quota. Every call you log manually in the Agent Log gets its own row, so the history accumulates across agents and weeks rather than resetting each time.
The Agent Log's summary block counts total calls scored and calculates your overall pass rate — the percentage of logged calls that hit PASS — giving you the one number most QA programs report up to a manager or client.
Why a spreadsheet still works for call QA
Dedicated QA software adds features like screen recording playback and calibration workflows across dozens of evaluators — useful at real scale, but overkill if you're running QA for a small team or a handful of agents. This template gives you the actual math (weighted scoring, pass/fail threshold, pass rate) without a monthly subscription.
Because it's a standard spreadsheet, any evaluator can open it, score a call, and see the result immediately — no account setup, no per-seat licensing, and no vendor lock-in on your scoring history.
How to use it
- Score up to 5 calls per session on the 5 weighted QA criteria, using scores from 1 to 5.
- Adjust the criteria weights if your QA program values them differently — they should sum to 100%.
- Log each scored call in the Agent Log with the agent, date and QA score.
- Check the Result column and the summary's pass rate to see where coaching is needed.
Download the free Free Call Center QA Scorecard Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
Can I use this call center scorecard in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. The weighted scoring and pass-rate formulas keep working.
Is this template really free?
Yes. You give an email address to download it, and then it's yours to use with no further cost.
How do I turn a matrix score into the QA score percentage?
The scorecard matrix rates each call out of 5. To log that call in the Agent Log, divide the weighted total by 5 and enter it as a percent - for example 4.1 / 5 = 82%. The conversion is manual: there is no automatic link between the scorecard sheet and the log.
Can I change the pass/fail threshold?
Yes. Unprotect the sheet with the password 'tt' and edit the 0.85 value in the Result column formula to match your program's passing bar.
Is this the same as your employee performance review or sports scorecard templates?
No. This scorecard is built specifically for call QA evaluation — weighted criteria per call, pass/fail threshold, agent pass rate. It's a different structure from a competency review or a season record sheet.
How many calls can the scorecard matrix hold at once?
Five calls per QA Scorecard sheet. Every call you score also gets logged permanently in the Agent Log, so your history isn't limited to five.