Skills Matrix Template — build a defensible training matrix for AS9100 & ISO 9001
A skills matrix is the fastest way to prove competence to an auditor — and the easiest thing to fake. This page gives you a free CSV template and the guide to make sure yours actually survives an AS9100, ISO 9001, or ITAR audit.
What a skills matrix is (and what auditors actually want)
A skills matrix — also called a training matrix or competency matrix — is a grid: employees down one axis, skills or tasks across the other, with a proficiency rating in every cell. In skilled-trades shops — machining, welding, automotive, electrical, HVAC, plumbing — it's the document an AS9100, ISO 9001, or ITAR auditor opens first to test clause 7.2 (Competence).
Auditors don't grade you on the spreadsheet's looks. They grade you on four things:
- Coverage — every required skill for every role is listed.
- Currency — ratings are recent and dated; nothing is silently stale.
- Attribution — every rating names the verifier and the method (observation, test, sign-off, evidence).
- Defensibility — no self-attestation, no edits without history.
Use the canonical 5-level proficiency scale
SkillCore (and most ISO-aligned shops) use these exact labels:
- Novice — aware of the task, cannot perform unaided.
- Developing — can perform under direct supervision.
- Proficient — performs independently to standard.
- Advanced — performs reliably on complex variants, troubleshoots.
- Expert — can train and sign off others.
Avoid vague labels like "none / foundational / intermediate" — they don't translate cleanly to an auditor's evidence test.
Step-by-step: build your first skills matrix
- List every job title in your shop.
- For each job title, list the skills, qualifications, and equipment required to perform it safely and to spec.
- For each employee in that role, fill in a proficiency level using the 5-level scale above.
- Add the date verified, the verifier's name, and the method (observation, written test, sign-off, evidence file).
- Add a next review date — most shops use 12 months for skills, sooner for safety-critical or regulated work.
- Calculate recency: Current (under 12 months), Refresh Recommended (12–18 months), Overdue (over 18 months).
- Review monthly. An out-of-date matrix is worse than no matrix in an audit.
The four ways a spreadsheet skills matrix fails an audit
An employee rated themselves. Auditors reject this on sight. A verifier must never be the person being verified.
The cell says "Proficient" but nothing shows how that was confirmed. Without method (test, observation, evidence), the rating is opinion.
Ratings from three years ago presented as current. AS9100 expects ongoing competence — not a one-time check.
Someone edited a rating and there's no record of who, when, or why. Auditors want an append-only trail.
When to graduate off the spreadsheet
A CSV is fine for a 5-person shop. Past that, recency tracking, verifier attribution, role-based access, and audit-pack export start eating an entire person's week. That's the problem SkillCore exists to solve: the same skills matrix model, but with automatic recency status, leader verification flows, append-only history, and a one-click audit binder export with full attribution.
FAQ
What is a skills matrix?⌄
Skills matrix vs training matrix vs competency matrix — what's the difference?⌄
Does AS9100 require a skills matrix?⌄
Is Excel good enough?⌄
Grab the template, then make it audit-defensible.
Download the free CSV below, or skip the spreadsheet pain and try SkillCore.