9-box grid
Paste a list with each person’s name, performance score and potential (you can copy it straight from Excel). The grid builds itself: you see who lands in each of the 9 boxes, how many there are and what to do with each group. Then download it as Excel.
One person per row. Paste straight from Excel, with or without headers.
Paste your list or use the example to see the grid.
Want to do this with your whole team?
In SurvIQ Performance Review each person enters their goals, their manager approves and reviews them, and the 9-box calibration builds itself from the results.
See Performance ReviewsThe grid is built in your browser. We don’t store names or scores.
How it’s calculated
Performance: use the final review score. It can be 1 to 5, a percentage (for example, 92%) or 1 to 3.
Potential: the manager’s and committee’s view of how much the person can grow. It is usually marked low, medium or high (1, 2 or 3), and you can type the words too.
Each axis splits into three levels with two cut-offs. On 1 to 5: medium from 3 and high from 4. In percent: medium from 80 and high from 95, matching the review template categories. You can change the cut-offs.
The box comes from crossing both levels. For example, high performance and high potential is “Star”; high performance and low potential is “Key expert”.
How to read the result
- Look at the overall shape first: most people should land in the center. If almost everyone is top right, scores are probably inflated.
- Compare by manager or department. If a whole team lands in one box, check how that manager reviewed before drawing conclusions.
- “Rough diamond” (low performance, high potential) is often someone new or in the wrong role. Talk before deciding.
- The grid is not for showing people their box. It is for deciding where to invest, whom to retain and who needs an improvement plan.
Frequently asked questions
- How do I measure potential?
- Define 2 or 3 questions the manager answers for each person, for example: do they learn new things fast?, do they look for more responsibility?, can you see them leading in two years? That turns potential from a hunch into something you can discuss.
- Can I paste data from Excel?
- Yes. Copy the name, performance and potential columns (and department if you like) and paste them. Semicolon-separated columns also work.
- Does the Excel file have formulas?
- Yes. The People sheet calculates each person’s level and box from the cut-offs at the top, and the Grid sheet counts how many people are in each box.
- Are the names I paste stored?
- Only in your browser, so you don’t lose them if you close the page. Nothing is sent to any server.
- When is the 9-box grid used?
- Usually in the calibration meeting, after managers finish their reviews and before feedback is delivered to each person.
Know what you want to ask?
Build the survey in SurvIQ, share it by link, WhatsApp or QR code, and watch results come in live. The Free plan is free forever.
Create a free survey