Skills Matrix Template for Managers (Skills and Interests Matrix)
Free Resources › Understand your team
A skills matrix is a simple table that maps what each person in your team can do, what they're working on and what they want to do next. It shows you strengths, gaps and hidden potential at a glance, so you can put the right people on the right work.
The short version: list each team member in a row, then add columns for current skills, skills they're working on, current and past work, career goals, interests and a stretch goal. Fill it in through your 1:1s, not a form, and use it whenever you staff a project, plan development or decide who to hire next.
Why add interests, not just skills
Most skills matrices only record what people can do. That tells you who is capable, but not who is motivated. Adding interests and career goals changes the question from "who can do this?" to "who can do this and wants to?", which is the difference between a stretch that develops someone and one that burns them out.
The skills and interests matrix template
Copy these columns into a spreadsheet. The example rows show how it looks once filled in.
| Name | Skills | Working on | Current work | Past work | Career goals | Interests | Stretch goal |
|---|---|---|---|---|---|---|---|
| Aisha | Data analysis, SQL, stakeholder reporting | Presenting to senior leaders | Monthly KPI pack | Customer insights | Lead a small analytics team | Automation, mentoring | Present Q3 results to the leadership team |
| Tom | Customer onboarding, process design | Project management | Onboarding programme | Support team lead | Move into operations | Tools and workflows | Own the CRM migration project |
| Marta | Copywriting, social media | Data-led campaign planning | Content calendar | Agency account work | Marketing manager in 3 years | Video, brand | Plan and report on one paid campaign end to end |
How to build it
- Get to know your team first. The best information comes from regular one-on-ones and working alongside people, not a self-assessment form.
- Ask about career goals directly. "Where do you want to be in two or three years?" and "What would you like more of in your work?"
- Fill it in, then check it with them. Share each person's row in a 1:1 and ask what you have missed or got wrong.
- Add optional extras if useful. Personality or working-style insights, or a link to each person's My User Manual.
- Update it twice a year. Skills and goals change. A stale matrix is worse than none.
How to use your skills matrix
- Staffing projects. Find who is best suited, and who could take it on as a development stretch rather than a struggle.
- Delegating. Match tasks to people who have the skill or want to build it.
- Development plans. The "working on" and "stretch goal" columns become each person's development plan.
- Hiring. Gaps across the whole team show which skills your next hire needs, and which they can be weaker in.
- Succession. See who could step into key roles, and what they would need first.
- Getting the right people in the right roles. Someone struggling may simply be in the wrong role. The matrix often shows a better fit.
Common mistakes
- Treating it as a rating exercise. It is a planning tool, not a performance score. Keep it separate from reviews.
- Building it alone. Without each person's input you will miss interests and hidden skills.
- Only listing technical skills. Facilitation, mentoring and stakeholder management matter just as much.
- Filling it in once and forgetting it. Review it before every planning cycle.
The Skills and Interests Matrix is 1 of 52 tools in The Leader's Toolkit
Every tool on this site comes from The Leader's Toolkit: 52 practical cards for 1:1s, feedback, delegation, retention and team problems, each linked to the tools that work with it. Keep the whole system on your desk instead of in browser tabs.
Get The Leader's ToolkitBrowse all free toolsTools that work well with this one
FAQs
What is a skills matrix?
A table that shows each team member's skills, development areas and goals side by side, so a manager can see strengths, gaps and potential across the whole team.
What should a skills matrix include?
At minimum: name, current skills and skills being developed. A more useful version adds current and past work, career goals, interests and a stretch goal for each person.
What is the difference between a skills matrix and a competency framework?
A competency framework defines what good looks like at each level of a role. A skills matrix records where each person in your team actually is today. You can use the framework to decide what goes in the matrix.
How often should you update a skills matrix?
Every six months, or whenever someone changes role, finishes a big project or a new person joins.
Should you share the skills matrix with the team?
Share each person's own row with them and agree it together. Whether to share the full matrix depends on your team's culture; many managers keep the full view private and share the skills inventory openly.