Skills matrix template

Everyone agrees they need one and nobody starts, because the blank page is the hard part. Naming the competencies is 90 % of the work. Rating people is 10 %. This tool does the 90 % and hands you the grid, ready to fill in and paste into Excel.

Updated July 26, 2026

Separate them with commas. For example: Project lead, Technician, Coordinator.

Your competency families

Start with two families and five roles. A 40-row matrix nobody fills in is worth less than a 10-row one that gets used.

Your grid

Enter at least one role and keep one family ticked.

The grid shows the holes. It does not fill them.

Once the matrix is filled in, the question becomes who you train, who you hire, and in what order. A 30-minute call, free of charge.