Employee Scorecard Template (Excel + Google Sheets, Free)
What's inside the employee scorecard template
The template is a single Scorecard sheet built as a weighted matrix, pre-filled with seven common review competencies: job knowledge, quality of work, productivity, communication, teamwork, initiative, and reliability. Every competency label can be renamed to match your own review framework.
Employee names go on the Name row, and each employee is scored 1-5 against every competency. Because the competency weights and the scoring grid are already laid out, the same sheet works whether you're reviewing two employees or several — you're not redesigning the format for each review cycle.
What calculates automatically: weighted scores across employees
Once your competency weights sum to 100% and each employee is scored, the weighted score row multiplies scores by weights and totals them per employee automatically. That means two employees with different strengths (one strong on productivity, one strong on communication) still land on one comparable number instead of a set of scores you have to interpret by eye.
Because the calculation is already built in, you can reuse the exact same scorecard across review cycles — enter this quarter's scores over last quarter's and the weighted totals recalculate instantly, which makes it straightforward to track how an employee's score moves over time.
Why this beats a blank spreadsheet
Building a weighted scorecard from scratch means deciding on competencies, writing the weighted-average formula correctly, and re-doing that work for every review cycle. This template starts with the structure and the formula already in place, so you're entering weights, names, and scores rather than building the sheet.
It also standardizes the review: because every employee is scored against the same weighted criteria on the same sheet, managers compare like for like, rather than each review reading like a different free-form writeup.
How to use it
- List the competencies you evaluate and weight them so they sum to 100%.
- Put each employee's name on the Name row.
- Score each employee 1-5 per competency.
- Check the weighted score row to compare employees on the same scale.
Download the free Employee Scorecard Template (Excel + Google Sheets, Free)
No spam — template updates and new free templates only. Unsubscribe anytime.
PTO & Leave Tracker — with Automatic Accrual
Once review scores are in, the PTO Tracker covers the other side of employee administration: automatic PTO accrual per pay period or month, across up to three leave policies with tenure tiers and capped carryover, with no macros.
See the full versionFrequently asked questions
Does this employee scorecard work in Google Sheets?
Yes. Upload the file to Google Drive, open it, then choose File > Save as Google Sheets. The weighted scoring formulas carry over.
Is the template free?
Yes. You give an email address to receive the download link, and the file itself has no cost.
Can I change the competencies?
Yes. The seven pre-filled competencies are a starting point — rename any of them to match your own review criteria.
Can I reuse this scorecard across review cycles?
Yes. Enter each cycle's scores in the same layout and the weighted totals recalculate, so you can compare an employee's scores over time.
Does this track headcount or leave for the employees I review?
No. This scorecard is for performance review scoring only. For headcount planning, see the workforce planning template; for PTO accrual, see the PTO Tracker.
What license comes with the free template?
It's licensed for personal use or use within one business. Reselling or redistributing the file itself isn't covered.