Line managers
Run honest 1-on-1s. Plan training that actually moves the needle. Hand over a fully-evidenced view of your team to your successor.
The method, in plain English
A skills matrix, explained.
A skills matrix is a simple grid: people down the side, skills across the top, ratings in between. But to actually drive better hiring, training, and team performance, you need a method. Here's the one this template is built on.
★★★★★ 5-star Google rated
Lifetime updates
148,000+ teams
Instant download
What it is
A skills matrix in one paragraph.
A skills matrix is a single, visual record of what your team can do. Each team member sits on one axis, each skill on the other, and the cell where a person meets a skill holds a rating that says, in a number, how capable that person is at that skill right now. Done well, it answers four questions every manager needs an answer to: who can do what, where are the gaps, who's at risk if a key person leaves, and where should we invest the training budget?
It sounds simple because it is. The hard part isn't the spreadsheet, it's the discipline behind it: defining the right skills, scoring them honestly, and updating them often enough to stay useful. That's what the template, and the four-step method below, are designed to make easy.
The method
Four steps. Repeated quarterly.
Most teams set up their first matrix in a single morning, then review it every quarter. Done consistently, this becomes the single most useful tool in your management routine.
Step 01
Define your team and the skills.
List every person whose capability matters. Then list every skill that matters for the work. Be specific. "Communication" is too broad. "Stakeholder presentations to executive level" is useful.
Aim for 15 to 30 skills per team. Fewer, and you'll miss the gaps. More, and you'll lose the audience.
Mix hard skills (technical, regulatory, tools), soft skills (coaching, conflict, communication), and leadership skills (delegation, vision, commercial awareness). All three matter.
Examples of well-defined skills
- SQL query writing for ad-hoc analysis
- Running 1-on-1s that produce action
- UK GDPR data handling
- Closing six-figure new business deals
- Coaching juniors through their first project
Step 02
Set the competency policy.
The 0-5 scale gives you precision Toyota's 1-4 didn't. At each level, define what "looks like" in your context. This is the single most important step in the whole method.
Once everyone agrees what "3" looks like for "stakeholder presentations", every rating in the matrix is comparable, defensible, and useful. Without this step, ratings are subjective opinions in a spreadsheet.
The 0-5 scale
- 0 · No exposure. Has not encountered this skill.
- 1 · Awareness. Knows what it is, can describe it.
- 2 · Supervised practice. Can do it with help.
- 3 · Independent. Performs the skill on their own.
- 4 · Strong performer. Reliably excellent.
- 5 · Trains others. Recognised as the go-to.
Step 03
Rate every person, against every skill.
Working with each individual (or with their line manager), score current capability against the agreed scale. Date the rating, so you know when it was last reviewed. Mark which skills are priority for the role.
The first round always feels uncomfortable. Some scores will be lower than people expected; some will be higher. That's the whole point. The matrix tells you what's actually true, not what you assumed.
Tips for honest scoring
- Score against the policy, not against other team members.
- If a person has never done it, score 0. Not 1.
- Make the conversation collaborative, not appraisal-style.
- Frame it as "where can I help you grow", not "here's your grade".
Step 04
Read the heat map. Build the plan.
Now the spreadsheet starts to earn its keep. The heat map shows you, in colour, where you're strong, where you're vulnerable, and where to invest.
Look for vertical red lines: skills no one in the team has. Look for single greens: critical skills only one person can do. Both are risks. Both are training opportunities.
Each individual gets an auto-generated roadmap: their current scores, their target scores, and a blank space for you to add training, mentoring, or stretch projects. Review it next quarter.
Patterns to look for
- Vertical red: A team-wide gap. Train widely.
- Single green: A key person risk. Cross-train.
- Horizontal amber: A struggling team member. Coach.
- Mostly green: A high-potential. Stretch them.
Who uses this
Built for anyone responsible for team capability.
If you're answerable for what a team can or can't do, you need a skills matrix. This is the role-by-role view.
HR business partners
Surface skills risks across the business. Build defensible training plans. Connect L&D budget to measurable capability outcomes.
L&D specialists
Stop running generic courses no one needed. Show, with data, exactly which training is closing exactly which gaps for exactly which people.
Operations leaders
Map capability against project requirements. Identify single points of failure before they cost you a delivery deadline or an audit.
Quality & compliance
Prove every team member is current on the training they need. Flag expiring competencies before the auditor asks.
Small business owners
Know what your tiny team can really do. Hire deliberately to fill the gaps. Grow on evidence, not gut feel.
Common mistakes
What we've seen go wrong.
After 20 years of helping teams adopt skills matrices, the failures fall into the same handful of patterns. Here's what to avoid.
Too many skills, too vague.
"Communication" isn't a skill, it's a category. Pick 15 to 30 specific skills. More, and the matrix becomes a chore no one updates. Less, and you'll miss real gaps.
Skipping the policy step.
If "3 out of 5" means different things to different raters, the matrix is just opinions in colour. Define what each level means before anyone scores anything.
Scoring against people, not policy.
"She's better than him, so she's a 4 and he's a 3." No. Score against the policy. Two people can both be at 4, or both at 2. The matrix isn't a ranking.
Building it once and forgetting.
A matrix that hasn't been updated in 18 months is fiction. Schedule quarterly reviews into your management routine. 20 minutes per person, four times a year.
Read the method.
Now run it.
The template comes pre-loaded with the policy, the 0-5 scale, the analytics, and the setup guide. All you bring is your team list. 30 minutes to first insight.
Get the template, £199 →