Free skills matrix templates by role
Excel workbooks that also open in Google Sheets and Numbers: people across the top, skills down the side, every rating colour-coded on one five-level scale. Pick the one closest to your team, replace the example rows, and fill it in together.
How to use a template
- Replace the names and the skills. The rows are a starting point taken from teams like yours, not a standard. Delete what your team does not do; add what it does, in the words the team uses.
- Rate on the scale, not by feel. 0 None, 1 Beginner, 2 Competent, 3 Proficient, 4 Expert — each level is defined on the Scale sheet by something you can watch a person do. The proficiency scale explains why.
- Leave a cell blank for a learning goal. A blank means “wants to learn this”. It is as useful as a rating: matched with a colleague's 4, it is a mentoring pair.
- Fill it in as a team. Self-ratings drift; ratings made in front of colleagues who have seen the work do not. A Market of Skills session does that in about an hour.
Software engineering skills matrix template
For a product or platform team of four to ten engineers. The rows mix the stack with the work around it — on-call, review, design, writing — because that is where the single points of failure usually hide.
Skills in the template
- Frontend (React)
- Backend (Node.js)
- SQL and data modelling
- Cloud infrastructure
- CI/CD pipelines
- Automated testing
- Application security
- Incident response
- Code review
- System design
- Technical writing
- Name the stack you actually run ("Postgres", "Kubernetes"), not a category. A team rates what it touches.
- Keep incident response and on-call in. A system only one person can bring back up is the most expensive gap on the sheet.
- Resist splitting by seniority. The matrix records skills; levels on a career ladder are a different document.
Customer support skills matrix template
For a support or success team. Rows cover product areas, channels and the human skills — de-escalation, writing — that decide whether a ticket closes well.
Skills in the template
- Ticket triage
- Billing and refunds
- Technical troubleshooting
- Integrations and API questions
- Escalation handling
- De-escalating upset customers
- Live chat
- Phone support
- Writing help articles
- German-language support
- Onboarding calls
- Add a row per product area that gets its own tickets. Coverage by product is usually the first question a lead asks.
- Languages belong here. A language only one person speaks is a coverage gap you solve with a rota or a hire, not training.
- Read the matrix against your schedule: a skill held only by people on the same shift leaves the other shift uncovered.
Manufacturing and operations skills matrix template
For a production cell, line or maintenance crew — where skills matrices started, as ILUO cross-training charts. Rows are stations, machines and procedures.
Skills in the template
- Line 1 operation
- Line 2 operation
- Machine setup and changeover
- Quality inspection
- Preventive maintenance
- Lockout / tagout
- Forklift
- 5S and workplace organisation
- Root-cause analysis
- Training new operators
- One row per station or machine, named the way the floor names it. Rate each person on what they can be seen doing there today.
- The scale maps onto ILUO: Beginner is "in training", Competent runs the station on routine work, Proficient handles the unusual cases, Expert trains others.
- Certifications that expire (forklift, first aid) need a date as well as a level. Keep it in the notes column, or a separate sheet.
General team template
For any other team — design, legal, research, a mixed project group. Six example skills, four people, the same scale and colours. The skills matrix guide walks through building one from scratch.
Download the general template (Excel)Choosing the skills for your rows
The template matters less than the rows you put in it. Three questions produce a good list in one meeting:
- What does our work need this quarter and next? Start there, not from a company-wide list.
- What would hurt if the one person who does it were away for a month? Those rows find your single points of failure.
- What do people want to learn? Skills nobody has yet still get a row — that is how a skills gap analysis starts.
Fifteen to twenty-five rows is plenty for one team. Past that, a matrix stops being read. If you need a wider framework of expected levels per role, that is a different tool — see competency matrix vs. skills matrix.
When the spreadsheet stops being enough
Kunska keeps the same matrix live for the whole team: everyone rates their own skills, changes show up as they happen, and the gaps and development plans come out of it. Free for teams.