Workplace training

Skills matrix template: build one in a spreadsheet

A free skills matrix template for Excel or Google Sheets: 8 column headings, a 0 to 4 rating scale and a filled-in example for a customer service team.

The words “Who can do what?” in large type, for an article on the skills matrix and a template to build in a spreadsheet

A skills matrix shows who can do what in a team: people in rows, the skills their jobs require in columns, and a level in each cell. Here is a skills matrix template to build in Excel, Google Sheets or any other spreadsheet. It's free, there's nothing to download, and it comes with a 0 to 4 rating scale and a filled-in example.

How do you build a skills matrix in Excel?

Type these 8 headings into the first row of your spreadsheet, one per cell. If you paste the line as is, the whole row will land in a single cell.

Employee; Job; Skill 1; Skill 2; Skill 3; Skill 4; Skill 5; Last updated

Replace "Skill 1" to "Skill 5" with the skills your team's jobs require. To find them, start from the job description. In France, you can also use the closest job profile in the ROME, France Travail's occupational framework (in French). Its profiles list the skills of each occupation: know-how, professional soft skills and knowledge.

Write each skill as an observable action: "handle a complaint by phone" rather than "customer relations". Add skills if you need to, but keep it to about ten so updates stay quick.

Below the headings come three kinds of rows:

  • One "Expected" row per job: the level the job requires, under each skill.
  • One row per person: their current level in each column, and the date of the last update.
  • One "Coverage" row at the bottom: under each skill, the number of people who handle every case on their own (level 3 or 4). Don't count the "Expected" rows.

Finally, color every level that falls below what the job expects. The gaps stand out at a glance.

What rating scale should you use?

We suggest a 5-level scale, from 0 to 4. Each level describes what the person does at work, and you can check it against a recent situation.

0: can't do it, or has never done it.

1: does it with help from a colleague.

2: handles routine cases alone.

3: handles every case alone, including the hardest ones.

4: masters every case and can train a colleague.

Leave the cell empty when the job doesn't require the skill. A 0 signals a need; an empty cell signals none.

For a foreign language, use the 6 levels of the Common European Framework of Reference for Languages instead. The Council of Europe describes them from A1 to C2.

Skills matrix example: a small company's customer service team

Let's take a fictional company with 45 employees that distributes industrial supplies. Its customer service team has one manager and 3 agents. Here is their matrix, updated in November 2026. The levels are made up.

Customer service: the 5 skills

Orders: enter an order. Catalog: answer a customer's questions about the catalog. Delivery: track a delivery. Complaints: handle a complaint by phone. Credit notes: issue a credit note.

Expected, manager: Orders 3; Catalog 3; Delivery 3; Complaints 3; Credit notes 3.

Expected, agent: Orders 2; Catalog 2; Delivery 2; Complaints 2; Credit notes 1.

Manager: Orders 4; Catalog 3; Delivery 3; Complaints 3; Credit notes 4.

Agent 1: Orders 3; Catalog 3; Delivery 3; Complaints 1; Credit notes 0.

Agent 2: Orders 2; Catalog 2; Delivery 2; Complaints 1; Credit notes 0.

Agent 3: Orders 2; Catalog 2; Delivery 3; Complaints 1; Credit notes 0.

Coverage, level 3 or 4: Orders 2; Catalog 2; Delivery 3; Complaints 1; Credit notes 1.

In the "Complaints" column, all 3 agents are at level 1 against an expected 2. This shared gap becomes a line in your training plan. It's also the need worked through in the example of our training needs analysis template.

The "Credit notes" column reveals another risk. Only the manager can issue a credit note, and no one takes over when she's away. At level 4, she can train the agents herself. The "Coverage" row puts a number on this lack of cross-training: a 1 flags a skill that rests on a single person.

Filling in the matrix, then building the training plan

  1. Tell your teams what the matrix is for before you fill it in. Show each person their own row, and keep the full matrix for the manager and HR.
  2. Fill in each row with the person, based on recent situations. They rate themselves, their manager does too, and then you compare. The meta-analysis by Heike Heidemeier and Klaus Moser (2009) pools 128 samples. On average, employees rate their job performance higher than their supervisors do. If your ratings differ, settle it with a dated example.
  3. Copy each gap you keep into your plan: one line per skill, with the number of people below the expected level.
  4. Update a person's row 3 months after their training, once the new level shows on the job. Review the whole matrix once a year, before you prepare the plan.

When several people need to improve the same skill, Complement's AI authoring tool generates a module from your documents. An AI avatar presents the content, quizzes the learner and gives spoken feedback on their answers. The dashboard shows who has completed the module. Only an observed work situation changes a level in the matrix.

To prepare a module on a shared gap in your matrix: 7-day free trial, no credit card required.