HR articles

Skills matrix template

Skills matrix template
SHORT ANSWER

A skills matrix is a table that maps employees against the skills a team needs: people in columns, skills in rows and a proficiency rating in each cell. It shows at a glance who can do what, where the gaps are and who needs training. A training matrix builds on it by tracking which training each person has to complete.

Free template: open a copy (Google Sheets — downloadable as Excel)

Course on this topic: Learning and Development Course

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:
  1. By row. A capability where only one person is rated high is a risk: if that person leaves, the skill leaves too.
  2. By column. A person with low ratings in the capabilities their role depends on needs a development plan.
  3. 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

  1. Fill in the name of the team or project.
  2. Enter the names and roles of the team members.
  3. Enter the capabilities the team or project needs. Start with 6–10.
  4. Read the proficiency and interest descriptions next to the table.
  5. 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.
  6. 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.
FAQ

Frequently asked questions

What is a skills matrix?

A skills matrix is a table with employees in columns, skills in rows and a proficiency rating in each cell. It gives a manager one view of the skills the team has and the skills it lacks.

What is the difference between a skills matrix and a training matrix?

A skills matrix shows the current skill level of each person. A training matrix shows which training each person must complete and its status. The first finds the gaps, the second tracks how they are being closed.

How do you create a skills matrix?

List the skills the team needs, define a simple rating scale, rate every employee on every skill together with their manager, then review the gaps and decide who needs training or who can back up whom. Update the matrix regularly.

What rating scale should a skills matrix use?

A simple scale of four or five levels works best, from no experience to expert. Describe each level in one sentence so that all managers rate in the same way.

Can I use the template in Excel?

Yes. The template opens as a copy in Google Sheets, and you can download it as an Excel file from the File menu.