Below: what the template includes, a filled-in example, the rating scale and how to complete it in Excel or Google Sheets.
What is a skills matrix?
A skills matrix is a table that shows which skills a team needs and how well each person has them. People go across the top, skills go down the side, and every cell holds a rating. One look tells a manager who can do what, where the team depends on a single person and which skills nobody has yet.
HR and team leads use a skills matrix to plan training, staff projects, prepare backups for key people and support promotion decisions with facts.
What the skills matrix template includes
The template has two sheets:
- Skills Matrix Template Example — a filled-in sample for a product management team of five, so you can see how a finished matrix reads.
- Skills Matrix Template — a blank copy of the same table for your own team.
Each sheet has the same parts:
- the name of the team or project;
- a column for every team member, with name and role;
- a row for every capability the team needs;
- two ratings per person for each capability — proficiency and interest — chosen from a drop-down list;
- a legend that explains each rating level.
Skills matrix example
The example sheet rates five people — a junior product manager, two product managers, a senior product manager and a VP of Product — on four capabilities: stakeholder management, product lifecycle management, agile methodologies and product roadmap planning.
Read the finished matrix in three passes:
- By row. A capability where only one person is rated high is a risk: if that person leaves, the skill leaves too.
- By column. A person with low ratings in the capabilities their role depends on needs a development plan.
- By interest. Someone with low proficiency and high interest is the first candidate for training. Someone with high proficiency and no interest is a poor choice for a long project that relies on that skill.
Skills matrix rating scale
The template uses five proficiency levels, scored 0 to 4:
- 0 — No experience or knowledge
- 1 — Limited experience or knowledge
- 2 — Reasonable experience or knowledge
- 3 — Considerable experience or knowledge
- 4 — Expert experience or knowledge
Interest has two values: 0 — has no interest in applying the capability, 1 — is interested in applying it.
How to fill in the skills matrix template in Excel or Google Sheets
- Fill in the name of the team or project.
- Enter the names and roles of the team members.
- Enter the capabilities the team or project needs. Start with 6–10.
- Read the proficiency and interest descriptions next to the table.
- Select a proficiency and an interest level for every person and capability from the drop-down list. Do it together with the person’s manager, not from memory.
- Review the finished matrix and mark the gaps.
The template opens as a copy in Google Sheets. To work in Excel, download it from the File menu.
Skills matrix vs. training matrix
A skills matrix shows the current level of each person. A training matrix shows which training each person has to complete and whether it is done. The first finds the gaps, the second tracks how they are being closed. If you need the second one, use the training matrix template.
If you are building a matrix from scratch and want the full method, read how to create a skills matrix.
From skills gaps to a training plan
A matrix is useful only when something happens after it is filled in:
- turn each gap into a line in a personal development plan, with a deadline and an expected result;
- choose the format for each gap: a course, mentoring by the person rated highest, or a project task. If you are weighing online course subscriptions to close these skill gaps, see how Pritula Academy stacks up against AIHR;
- update the ratings after training and at least twice a year;
- check whether the gap has closed and whether the work has improved.
We cover the whole cycle, from diagnosis to evaluation of results, in the
👀 Learning & Development Manager course.