Skip Navigation

Spreadsheet

9-Box Talent Grid — Performance & Potential Matrix for Excel & Google Sheets

A 9-box talent grid for Excel & Google Sheets — score performance and potential, auto-place each person, and see succession risk on one grid.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • Score two axes (performance × potential) and each person is placed in the right box automatically
  • Live 3×3 calibration grid with a count in every box — the view for your talent review
  • Box-by-box counts, shares, and the named list of who is in each box
  • A suggested focus for every box, from develop and retain to coach and re-fit
  • One owned file — Excel, Google Sheets & LibreOffice, no per-seat fees

You already carry a rough map of your team in your head — who is flying, who is coasting, who could do far more if you gave them the chance. The 9-Box Talent Grid gets that map onto one page, in a shape you can talk through with other managers and act on with a clear head.

It’s the classic performance × potential 9-box, built as a workbook you own. Score each person on two axes and every name is placed automatically in the right box — from Talent Risk in the bottom-left to Star in the top-right. No dragging names around, no agonizing over where someone “belongs.”

New to the 9-box? Try the free single-team starter grid — plot one team by hand, then upgrade here for auto-placement, a live calibration grid, and named lists.

What is a 9-box talent grid?

A 9-box grid plots people on two scores. Across the bottom is performance — how well someone delivers in their role today (Below, Meets, or Exceeds expectations). Up the side is potential — how much more they could take on in future (Low, Growth, or High). The two scores cross into one of nine boxes, each with a name and a suggested focus, so a whole team becomes a single, readable picture of talent and succession risk.

Score two axes — the box fills in

On the Talent Grid tab, you list your people and pick a Performance and a Potential score from the dropdowns. That’s it. The box number, the box name, its zone, and a suggested focus all calculate for you and read from a single source of truth, so the grid always agrees with itself. You never place anyone by hand.

See your whole team on one calibration grid

The Calibration Grid tab lays the team out on the familiar 3×3, performance across and potential up, with a live count in every box pulled straight from your scores. It’s the view to project in a talent-review meeting — the conversation starts from the picture, not a spreadsheet. An empty top row is a succession gap you can name; a crowd in one box is a calibration prompt.

Counts and named lists, ready for the meeting

The Box Summary tab gives you one row per box: the headcount, the share of the team, a suggested focus, and the named list of exactly who is in it. Bring it straight into the calibration conversation — who are your Stars, who is a flight risk, who has been quietly overlooked.

What’s inside

  • Talent Grid — the working tab: two scores per person, auto-placed into a box.
  • Calibration Grid — your whole team on the 3×3 with a live count per box.
  • Box Summary — counts, shares, suggested focus, and named lists.
  • The 9 Boxes — what each box means and its zone (the reference the grid reads from).
  • Scoring Guide — how to score the two axes fairly, with an anchored definition for each level.
  • Review Log — a dated record of each talent review or calibration session.
  • Read Me — how the tabs fit together and where to start.
  • Four PDF guides — Start Here, the 9-box method & scoring guide, reading the grid & talent actions, and a printable wall chart & calibration sheet for the meeting.

Works in Excel, Google Sheets, and LibreOffice

One .xlsx that opens in Microsoft Excel and LibreOffice Calc — or, for Google Sheets, open the included one-click link and click Make a copy to drop a ready-made native version straight into your Drive, no importing and nothing to set up. It ships pre-loaded with a worked example — a fictional twelve-person organization that fills all nine boxes — so the method is obvious on open. Overwrite it with your own team, and add rows for a larger one. It’s an instant digital download: nothing ships, and the workbook and all four PDF guides are yours the moment you check out.

Own it, don’t rent it

This sits between a blank spreadsheet (free, but you build and maintain everything) and a per-seat talent-management platform (overkill for most teams, and a recurring bill). It’s the structure you keep: a connected, owned workbook, with no seats and no monthly fee. Track what your people can actually do, skill by skill, with the companion Skills Matrix, and find more people-ops tools in the full Ardent Workshop catalog.

What this is — and what it isn’t

The 9-Box Talent Grid is a talent-review and planning template — not HR, legal, or professional advice, and not an objective assessment of any real person. A box is a starting point for a conversation, not a verdict: never make a pay, promotion, or exit decision on the box alone. The example team and scores are fictional and illustrative. Keep your people’s data confidential to those who need it, the way your own privacy policy and local law require. The 9-box is a generic, widely-used talent model; this product is not affiliated with or endorsed by any consultancy or framework owner.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • Delivered as one spreadsheet that works in Microsoft Excel, Google Sheets, and LibreOffice Calc
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings (unlock with provided password)

In the download

This digital product is delivered as a zip file containing the following items:

  • 7-tab workbook (.xlsx): Read Me, Scoring Guide, The 9 Boxes, Talent Grid, Calibration Grid, Box Summary, Review Log
  • One-click Google Sheets copy — a ready-made native version (no import needed)
  • Start Here guide (PDF)
  • 9-Box Method & Scoring guide (PDF)
  • Reading the Grid & Talent Actions guide (PDF)
  • Printable 9-Box Wall Chart & Calibration Sheet (PDF)
  • Pre-loaded worked example you overwrite with your team

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Ready to start

Instant download · Free lifetime updates · Personal use license

$24.95 USD
Buy now

Pairs well with

From the Guides

Hand-picked reading on how to actually use a tool like this.