Performance Review Template in Excel: Goals, Competencies, Scores and a Development Plan
Build a performance review template in Excel for a small team: a goals section and a competencies section with weights, a 1–5 rating scale with descriptions, self-assessment, automatic overall score and rating, and a development plan.
A performance review template in Excel combines two weighted sections: goals for the review period (what was achieved) and competencies (how the work was done), both rated on the same 1–5 scale. The sheet calculates the overall score and rating automatically and ends with a short development plan. Built well, it turns the annual review into a conversation about evidence instead of impressions. This guide covers the rating scale, layout, formulas and how to run the review meeting.
Why goals and competencies
Rating only results rewards hitting numbers at any cost; rating only behavior loses sight of what the role is for. Many small businesses weight goals at 60% and competencies at 40%, adjusted by role: results weigh more in sales, competencies more in customer-facing roles.
A rating scale with descriptions
| Rating | Meaning |
|---|---|
| 5 | Consistently and clearly exceeds expectations; a model for others |
| 4 | Exceeds expectations in important areas |
| 3 | Fully meets expectations for the role |
| 2 | Partly meets expectations; specific areas need improvement |
| 1 | Does not meet expectations |
For each competency, also describe what a 3 and a 5 look like in that role. Without descriptions, every manager rates on their own scale and reviews cannot be compared.
Layout of the sheet
- Header: employee, role, manager, review period, meeting date.
- Goals: each goal with its weight, measure, target, result, rating and comment.
- Competencies: each competency with weight, self-rating, manager rating and one concrete example.
- Summary: section scores, overall score and rating label.
- Development plan: two or three actions with owners and dates.
Restrict ratings to 1–5 with data validation and lock the formula cells.
Formulas
- Section score:
=SUMPRODUCT(Weights,Ratings)/SUM(Weights) - Overall score:
=GoalWeight*GoalScore+CompetencyWeight*CompetencyScore - Rating label:
=IF(Overall>=4.5,"Outstanding",IF(Overall>=3.5,"Exceeds expectations",IF(Overall>=2.5,"Meets expectations","Needs improvement"))) - Self vs. manager gap:
=[@Manager]-[@Self]; gaps of 2 or more are the first topics for the meeting.
Example: customer success specialist
| Item | Weight | Result | Rating |
|---|---|---|---|
| Customer satisfaction score of 4.6 or higher | 40% | 4.7 average | 4 |
| Renewal rate of 92% | 30% | 90% | 3 |
| Rebuild the onboarding guide | 30% | Done early, adopted by the team | 5 |
| Goals section (60%) | 4.00 | ||
| Communication / Problem solving / Collaboration / Time management | 25% each | Examples recorded | 5 / 4 / 4 / 3 |
| Competencies section (40%) | 4.00 | ||
| Overall | 4.00 – Exceeds expectations |
Time management at 3 and renewals slightly below target point to the same root cause: renewal calls slipping when support tickets pile up. The development plan blocks two hours a week for renewal outreach and adds a time-boxing workshop before mid-year.
Running the review meeting
- Share the template with the self-assessment a week ahead.
- Start with strengths and examples, then discuss the biggest rating gaps.
- Agree the development plan and next period’s goals together; the OKR template helps link individual goals to company goals, and the goal planning worksheet breaks them into weekly actions.
- Record what was agreed in the sheet or with the meeting minutes template.
Fairness and limits
Use the same criteria for everyone in the same role, and compare ratings across managers before sharing them so consistently generous or harsh raters can be calibrated. If reviews affect pay or promotion, publish the rules before the period starts and apply them consistently, in line with employment law and your policies. Keep reviews in a restricted folder. New hires can get a shorter version at the end of their first 90 days as part of the onboarding checklist. More guides are in Operations & HR.
Frequently asked questions
How often should performance reviews happen?
Commonly once a year with a mid-year check-in, plus a review at the end of a probation period.
How many goals and competencies should a review include?
Three to five goals and four to six competencies per role; more dilutes each one.
Is a self-assessment necessary?
Not required, but it improves the conversation by showing how the employee sees their own work.
Does it work in Google Sheets?
Yes. SUMPRODUCT and IF work the same; share each review only with the employee and manager.