9-Box Talent Matrix in Excel: Free Template Download

Download our free 9-box talent matrix template for Excel: enter ratings from 1 to 3 and the grid fills itself. Includes rating definitions and recommended actions for every box.

The 9-box talent matrix is a two-axis grid that HR and People teams use to rate employees on current performance and future potential and place each person in one of nine cells. This free Excel template does the placement for you: enter ratings from 1 to 3 for up to 26 employees and the grid fills itself, ready for calibration sessions and succession planning.

What the Template Contains

TabWhat it does
InstructionsFive steps, from reading the definitions to linking placements to development plans
DefinitionsWhat ratings 1, 2 and 3 mean on each axis, plus recommended development actions for all nine combinations
Employee DataName, department, role, both ratings and development notes for up to 26 employees; the box position is calculated. Five sample employees are filled in for you to overwrite
9-Box GridPlaces names in the right box automatically, up to three per box, with a legend for four talent groups

Plan for one limit: each box displays the first three names. In a larger calibration, where several people often share the middle box, filter the Box Position column in Employee Data for the full list. The file is an .xlsx workbook. You can upload it to Google Sheets, but check the grid once after the import, because it relies on array formulas.

Once you repeat calibrations across teams, talent management software keeps ratings, evidence and history in one place.

The 9-Box Grid — Cells at a Glance

The grid places performance on the horizontal axis (low → high) and potential on the vertical axis (low → high). The nine resulting cells each call for a different talent action. The labels below are common names for the cells; the workbook shows the position as performance-potential, so 2-3 means medium performance and high potential.

Cell Label Recommended Action
High potential / Low performance Misplaced Talent Reassign; investigate blockers; targeted development plan
High potential / Moderate performance Emerging Talent Stretch assignments, mentoring, accelerated exposure
High potential / High performance Future Leader Succession pipeline; retain proactively; development fast-track
Moderate potential / Low performance Inconsistent Performer Performance improvement plan; regular coaching
Moderate potential / Moderate performance Core Contributor Develop within current role; recognise contributions
Moderate potential / High performance Strong Performer Prepare for next-level responsibilities; retention focus
Low potential / Low performance Underperformer Structured PIP; clarify expectations; escalate if no change
Low potential / Moderate performance Solid Contributor Appreciate stability; keep engaged; avoid forcing growth
Low potential / High performance Expert Specialist Retain and deepen domain expertise; consider specialist career path

Worked Example: How Ratings Become a Box Position

Each pair of ratings produces one box position. The sample employees in the workbook land like this:

Sample rolePerformancePotentialBox positionCell in the table above
Senior Software Engineer333-3Future Leader
Operations Manager232-3Emerging Talent
Account Executive222-2Core Contributor
Tech Lead313-1Expert Specialist

How to Use the Template

  1. Prepare ratings before the session. Each manager completes performance and potential ratings independently — with supporting evidence, not gut feeling.
  2. Calibrate in a group. Bring managers together. Present each employee, discuss the evidence, challenge outliers, and agree on a final cell placement.
  3. Record decisions. Use the Development Notes column to document the key reason for each placement, so you can still explain the decision a year later.
  4. Define actions per cell. For each box, agree on concrete next steps — a development conversation, a stretch project, a succession nomination, or a performance support plan.
  5. Follow up within 30–60 days. The grid is only valuable if actions happen. Schedule follow-up check-ins and revisit the matrix every 6–12 months.

Calibration Best Practices

A 9-box session is only as good as the calibration that goes into it. Three common failure modes to avoid:

Recency bias. Managers tend to overweight the most recent weeks of visible work. Counter this by anchoring ratings to the full review period and asking: "Is this consistent, or a recent spike?"

Halo and horns effects. One strong project can inflate the overall potential rating, and one rough quarter can suppress it unfairly. AIHR's guide to the 9-box grid warns against turning it into a labeling or forced-ranking exercise, so frame the session around development, not ranking.

Ignoring context. An employee in a newly merged team facing structural chaos may perform below their actual level. Ask: "What context explains the current performance, and is it temporary?"

For organisations in Germany with a works council (Betriebsrat), two rules matter. A uniform 9-box scale can count as general appraisal principles, which need the council's consent under § 94(2) BetrVG, even on paper. Software that can monitor performance falls under co-determination in § 87(1) no. 6 BetrVG. Involve the works council before your first software-supported talent review.

How the 9-Box Connects to Succession Planning

The top-right cell — Future Leaders — is your succession pipeline by definition. A common rule of thumb is to name at least two potential successors for each key role. If your top-right box is empty, that signals either a pipeline gap or an overly conservative calibration. Check both. Our succession planning template for SMBs turns the top-right box into a working plan.

For a broader framework, see our 9-box talent matrix templates and calibration guide, the comparison of talent management systems, our talent management RFP with 120 vendor questions and these talent management strategies for high potentials.

Frequently Asked Questions

How often should we run a 9-box calibration?

Once a year, aligned with the performance review cycle, is a sensible default. If you are growing fast or actively planning succession, twice a year can make sense. Quarterly is usually too frequent unless headcount is small.

Should employees see their own 9-box placement?

This is contested. A common approach is to keep placements internal at first, then communicate directional feedback — "we see high potential and want to invest in your development" — without sharing the exact cell label. Transparency about development intent matters more than the label itself. In Germany, this approach has legal limits: employees can ask to discuss their performance appraisal and development (§ 82(2) BetrVG), inspect their personnel file (§ 83 BetrVG) and generally request access to the personal data held about them (Art. 15 GDPR). Word every placement as if the employee will read it.

Can we use the 9-box for a team of 10 people?

Yes, but calibration is less meaningful with very small groups because the sample is too small to compare meaningfully. Use it as a thinking tool rather than a formal process for very small teams.

What's the difference between performance and potential?

Performance is what someone has delivered in the current role over the review period — measurable, evidence-based. Potential is an assessment of their capacity to grow into roles of greater scope or complexity. They are distinct: a highly-performing specialist may have low interest in or aptitude for leadership, while a newer employee may have high ceiling despite an average start.

Is the 9-box compatible with objectives-based performance systems?

Yes. Many organisations feed OKR achievement scores or goal completion rates directly into the performance axis. The potential axis then remains a qualitative, calibrated judgment — which is appropriate, since potential is harder to quantify than goal attainment.

How many employees fit in the template?

The Employee Data tab has calculated rows for 26 employees, and each box in the grid shows up to three names. For larger groups, use one copy of the file per department, or filter the Box Position column to see everyone in a box.

The 9-box talent matrix is a two-axis grid that HR and People teams use to rate employees on current performance and future potential and place each person in one of nine cells. This free Excel template does the placement for you: enter ratings from 1 to 3 for up to 26 employees and the grid fills itself, ready for calibration sessions and succession planning.

What the Template Contains

TabWhat it does
InstructionsFive steps, from reading the definitions to linking placements to development plans
DefinitionsWhat ratings 1, 2 and 3 mean on each axis, plus recommended development actions for all nine combinations
Employee DataName, department, role, both ratings and development notes for up to 26 employees; the box position is calculated. Five sample employees are filled in for you to overwrite
9-Box GridPlaces names in the right box automatically, up to three per box, with a legend for four talent groups

Plan for one limit: each box displays the first three names. In a larger calibration, where several people often share the middle box, filter the Box Position column in Employee Data for the full list. The file is an .xlsx workbook. You can upload it to Google Sheets, but check the grid once after the import, because it relies on array formulas.

Once you repeat calibrations across teams, talent management software keeps ratings, evidence and history in one place.

The 9-Box Grid — Cells at a Glance

The grid places performance on the horizontal axis (low → high) and potential on the vertical axis (low → high). The nine resulting cells each call for a different talent action. The labels below are common names for the cells; the workbook shows the position as performance-potential, so 2-3 means medium performance and high potential.

Cell Label Recommended Action
High potential / Low performance Misplaced Talent Reassign; investigate blockers; targeted development plan
High potential / Moderate performance Emerging Talent Stretch assignments, mentoring, accelerated exposure
High potential / High performance Future Leader Succession pipeline; retain proactively; development fast-track
Moderate potential / Low performance Inconsistent Performer Performance improvement plan; regular coaching
Moderate potential / Moderate performance Core Contributor Develop within current role; recognise contributions
Moderate potential / High performance Strong Performer Prepare for next-level responsibilities; retention focus
Low potential / Low performance Underperformer Structured PIP; clarify expectations; escalate if no change
Low potential / Moderate performance Solid Contributor Appreciate stability; keep engaged; avoid forcing growth
Low potential / High performance Expert Specialist Retain and deepen domain expertise; consider specialist career path

Worked Example: How Ratings Become a Box Position

Each pair of ratings produces one box position. The sample employees in the workbook land like this:

Sample rolePerformancePotentialBox positionCell in the table above
Senior Software Engineer333-3Future Leader
Operations Manager232-3Emerging Talent
Account Executive222-2Core Contributor
Tech Lead313-1Expert Specialist

How to Use the Template

  1. Prepare ratings before the session. Each manager completes performance and potential ratings independently — with supporting evidence, not gut feeling.
  2. Calibrate in a group. Bring managers together. Present each employee, discuss the evidence, challenge outliers, and agree on a final cell placement.
  3. Record decisions. Use the Development Notes column to document the key reason for each placement, so you can still explain the decision a year later.
  4. Define actions per cell. For each box, agree on concrete next steps — a development conversation, a stretch project, a succession nomination, or a performance support plan.
  5. Follow up within 30–60 days. The grid is only valuable if actions happen. Schedule follow-up check-ins and revisit the matrix every 6–12 months.

Calibration Best Practices

A 9-box session is only as good as the calibration that goes into it. Three common failure modes to avoid:

Recency bias. Managers tend to overweight the most recent weeks of visible work. Counter this by anchoring ratings to the full review period and asking: "Is this consistent, or a recent spike?"

Halo and horns effects. One strong project can inflate the overall potential rating, and one rough quarter can suppress it unfairly. AIHR's guide to the 9-box grid warns against turning it into a labeling or forced-ranking exercise, so frame the session around development, not ranking.

Ignoring context. An employee in a newly merged team facing structural chaos may perform below their actual level. Ask: "What context explains the current performance, and is it temporary?"

For organisations in Germany with a works council (Betriebsrat), two rules matter. A uniform 9-box scale can count as general appraisal principles, which need the council's consent under § 94(2) BetrVG, even on paper. Software that can monitor performance falls under co-determination in § 87(1) no. 6 BetrVG. Involve the works council before your first software-supported talent review.

How the 9-Box Connects to Succession Planning

The top-right cell — Future Leaders — is your succession pipeline by definition. A common rule of thumb is to name at least two potential successors for each key role. If your top-right box is empty, that signals either a pipeline gap or an overly conservative calibration. Check both. Our succession planning template for SMBs turns the top-right box into a working plan.

For a broader framework, see our 9-box talent matrix templates and calibration guide, the comparison of talent management systems, our talent management RFP with 120 vendor questions and these talent management strategies for high potentials.

Frequently Asked Questions

How often should we run a 9-box calibration?

Once a year, aligned with the performance review cycle, is a sensible default. If you are growing fast or actively planning succession, twice a year can make sense. Quarterly is usually too frequent unless headcount is small.

Should employees see their own 9-box placement?

This is contested. A common approach is to keep placements internal at first, then communicate directional feedback — "we see high potential and want to invest in your development" — without sharing the exact cell label. Transparency about development intent matters more than the label itself. In Germany, this approach has legal limits: employees can ask to discuss their performance appraisal and development (§ 82(2) BetrVG), inspect their personnel file (§ 83 BetrVG) and generally request access to the personal data held about them (Art. 15 GDPR). Word every placement as if the employee will read it.

Can we use the 9-box for a team of 10 people?

Yes, but calibration is less meaningful with very small groups because the sample is too small to compare meaningfully. Use it as a thinking tool rather than a formal process for very small teams.

What's the difference between performance and potential?

Performance is what someone has delivered in the current role over the review period — measurable, evidence-based. Potential is an assessment of their capacity to grow into roles of greater scope or complexity. They are distinct: a highly-performing specialist may have low interest in or aptitude for leadership, while a newer employee may have high ceiling despite an average start.

Is the 9-box compatible with objectives-based performance systems?

Yes. Many organisations feed OKR achievement scores or goal completion rates directly into the performance axis. The potential axis then remains a qualitative, calibrated judgment — which is appropriate, since potential is harder to quantify than goal attainment.

How many employees fit in the template?

The Employee Data tab has calculated rows for 26 employees, and each box in the grid shows up to three names. For larger groups, use one copy of the file per department, or filter the Box Position column to see everyone in a box.

More content
Free IDP Template (Excel): SMART Goals & Skills Assessment
Video
Templates
Free IDP Template (Excel): SMART Goals & Skills Assessment
Free 360 Degree Feedback Template (PDF): Open Questions
Video
Templates
Free 360 Degree Feedback Template (PDF): Open Questions
Free PIP Template (PDF): Simple Performance Improvement Plan
Video
Templates
Free PIP Template (PDF): Simple Performance Improvement Plan

Free one-page PIP template (PDF) for HR teams and managers: clear expectations, concrete measures and support, written with German employment law in mind.

Self-Evaluation Phrase Catalog: 200+ Free Phrases (Excel)
Video
Templates
Self-Evaluation Phrase Catalog: 200+ Free Phrases (Excel)
Free 360 Feedback Template: Ready-to-Use Excel Tool
Video
Templates
Free 360 Feedback Template: Ready-to-Use Excel Tool
Free BARS Performance Review Template (Excel Download)
Video
Templates
Free BARS Performance Review Template (Excel Download)
360-Degree Development Review Template (PDF, in German)
Video
Templates
360-Degree Development Review Template (PDF, in German)

A 360-degree development review template (PDF, in German) for focusing feedback on strengths and development potential.