Tool · Excel template

Competence matrix template (Excel)

A competence matrix shows, for every role, the competence it needs and, for every person, whether they have it and the evidence. This Excel template gives you the roles sheet, the matrix with status codes and a completion percentage, and the training records an auditor asks to see. No sign-in and no e-mail address needed.

What is inside

  • How to use: a one-page guide to filling it in
  • Roles: each role, the competence it needs, the standard behind it and the training that provides it
  • Matrix: people against courses, with status codes (completed, in training, due, refresher due, not required) and a completion percentage per person
  • Records: one row per completion, with the date, the result, the certificate's verification link, the effectiveness check and the next refresher
Download the template (XLSX)

Excel workbook · no sign-in, no e-mail · prepared by the Sterling expert panel

Find the training each role needs →

What is a competence matrix?

A competence matrix is a table that lists the roles in an organisation, the competence each role needs, and the people in those roles with the status of their training. It turns a requirement found in every ISO management system standard into one record that managers can use and an auditor can sample: decide what competence each role needs, make sure people have it through education, training or experience, take action where they do not, check that the action worked, and keep evidence.

The matrix is not the training itself. It is the plan and the evidence: what each role needs, who is competent, who is due, and where the evidence is.

Why do auditors ask for it?

When a certification body auditor checks competence, they pick a role, then a person in that role, then ask three questions: what competence does this role need, how do you know this person has it, and where is the evidence? A competence matrix answers all three on one screen. Without one, the evidence sits in e-mails, training certificates in different folders and memories of who attended what, and the audit takes longer and finds more.

The same record serves internal auditors, management review and clients' supplier audits, which increasingly ask for training evidence by role.

How do you fill in the template?

Start with the roles, not the people. For each role, write the competence it needs in plain words, the standard or rule behind it and the training that provides it, at the right level: awareness for most staff, practitioner or internal auditor courses for people with a defined role in the system. Then list the people, and mark each course in the matrix with its status. Finally, record each completion in the records sheet with the date, the result and the link that lets anyone verify the certificate.

Review the matrix at each management review, when someone changes role, when a process changes and when a standard is revised. A new edition, such as ISO 9001:2026, is a common reason to plan refresher training across the matrix.

How do you show that training was effective?

Management system standards ask organisations to evaluate the effectiveness of the actions they take to build competence. A certificate shows that someone completed training and reached the pass mark; effectiveness shows that they can now do the job. Use the records sheet to note how you checked it, for example an observation at the next internal audit, a review of the person's first audit report, or a supervisor's sign-off after a set period, and when.

How does Sterling Academy fit in?

Sterling Academy courses are online and self-paced, and built by industry experts in the same content and format as Sterling's classroom training. Each ends with a final exam and a verifiable certificate with a QR code, so the verification link you paste into the records sheet lets an auditor check it in seconds. For a team, the client administrator sees everyone's progress and results in one place, which is the evidence behind each completed cell in the matrix. Use the training finder to see which courses each role needs.

Frequently asked questions

Questions about the template

Is a competence matrix mandatory for ISO certification?

The standards do not require a matrix by name. They require you to determine the competence each role needs, ensure people have it and keep evidence. A competence matrix is the most common way to show all three in one record.

Can I use the template for more than one standard?

Yes. Add a row per role and competence for each standard you are certified to, such as ISO 9001, ISO 14001, ISO 45001 or ISO/IEC 27001, and add courses as columns in the matrix.

Do I need to sign in or give an e-mail address to download it?

No. The download starts straight away from this page.

Which Excel versions does it work with?

It is a standard .xlsx file with simple formulas, drop-down lists and colour rules. It opens in current versions of Microsoft Excel, in Excel online and in other spreadsheet programs that read .xlsx files.

What is the difference between competence and awareness?

Awareness is what every person must understand about the system, such as the policy and their contribution. Competence is the ability to do a specific job to the required standard, built through education, training or experience, and it is what the matrix records by role.