Guide · Updated 2026-10-02
What Columns Should a Training Matrix Have?
A usable matrix has identity columns, a role or worker-type field, then one column (or linked requirement) for each training item you actually assign — with space for expiry or completion dates and a pointer to evidence. Extra columns you never review become noise.
Quick answer
Include: worker name, unique ID, employer/company, worker type (payroll / agency / subcontract), primary role, then requirement columns for your baselines (for example CSCS, first aid, plant tickets, company induction). Add project inductions as separate, archivable columns. Prefer dates over traffic-light-only cells.
Core identity columns
| Column | Why it exists |
|---|---|
| Name + unique ID | Stops duplicate-row chaos |
| Employer / company | Subcontract and agency clarity |
| Worker type | Filter and ownership |
| Role | Drives which requirements apply |
| Site / gang / project tags | Monday mobilisation filters |
Requirement columns
- One requirement name people recognise at the gate
- Expiry or completion date as a real date cell
- Evidence link or filename note
- Not required marked explicitly — never a fake date
- Optional issue date if your audits ask for it
- List roles and the baseline requirements each needs.
- Delete columns nobody owns or reviews.
- Add site-specific columns only for live projects.
- Test the sheet against one real Monday crew list.
Honest limits
FieldClear and templates help you structure columns; they do not mandate a universal legal set. Your organisation chooses assignments. Not legal advice.
Free download
Need a training matrix template?
Download our free Construction Training Matrix Excel template. Worker rows, requirement columns, expiry dates and conditional formatting already set up.
Already have one?
Turn your spreadsheet into a live matrix with automatic expiry reminders.
Upload my matrixtraining-matrix-template.xlsx
| Row number | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Name | Role | CSCS | IPAF | PASMA | First Aid | Asbestos |
| 2 | Ahmed Khan | HVAC Engineer | 12/08/2028 | 25/08/2026 | 03/02/2028 | 19/09/2027 | — |
| 3 | John Smith | Site Supervisor | 04/06/2029 | 22/01/2028 | 18/09/2026 | 18/09/2026 | 11/11/2027 |
| 4 | Sarah Jones | Electrician | 28/10/2028 | 16/05/2028 | 16/05/2028 | 02/12/2027 | 09/07/2028 |
| 5 | Peter Brown | General Operative | 06/08/2026 | 14/04/2028 | — | — | 21/01/2028 |
| 6 | Grace Okafor | Electrician | 17/03/2029 | 27/09/2026 | 08/08/2028 | 23/06/2028 | 05/05/2028 |