Free download · Excel (.xlsx)
Free Construction Training Matrix Template
Download a free Excel training matrix template set up for construction — CSCS, IPAF, PASMA, first aid and asbestos awareness columns already in place.
- Construction requirement columns already set up
- Conditional formatting for expired and expiring dates
- A role requirements sheet you can edit
- Guidance sheet explaining how to keep it accurate
No email required. Free to use, including commercially.
training-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 |
What’s in the template
Three sheets. The matrix itself, a role requirements sheet, and a page of guidance on keeping it accurate.
- Worker rows with name, role, worker type and team — so subcontractors and agency workers can be tracked alongside employees.
- Requirement columns for CSCS, IPAF, PASMA, first aid, asbestos awareness and manual handling, which you can replace with your own.
- Conditional formatting that colours expired dates red, dates within 60 days amber, and current dates green — automatically, based on today.
- A distinction between blank (no record held) and N/A (not required), because an ambiguous empty cell is where problems hide.
- An evidence location column, so the certificate can always be found from the matrix.
How to use it well
- Add your workers, including subcontractors and agency staff.
- Replace the requirement columns with whatever your organisation assigns to each role.
- Enter expiry dates as real dates in DD/MM/YYYY format — text such as “Aug 26” breaks sorting, filtering and the colour coding.
- Leave a cell blank where a record is genuinely missing, and enter N/A where the requirement does not apply.
- Record where each certificate is filed, so a date can always be backed up with evidence.
- Put a recurring reminder in your own diary to review it, because the spreadsheet will not remind you.
A note on what the template is not
It is a practical starting point, not legal or health and safety advice. It does not determine which training or qualifications are required for your workers or activities — your organisation is responsible for defining and reviewing its own requirements.
Questions people ask before signing up
Is the training matrix template really free?
Yes. Download the Excel file and use it however you like, including commercially. There is no obligation to try the software.
What is a training matrix?
A training matrix is a grid of workers against the training, qualifications and cards their roles require. Each cell shows whether that person holds that requirement and when it expires. It is the quickest way to see where the gaps are across a workforce.
Can I import my existing Excel training matrix?
Yes. Upload an Excel or CSV file, map the columns to workers, roles, qualifications and expiry dates, then preview the result. Nothing is created until you confirm the import.
Can I track CSCS card expiry dates?
Yes. Record the card type and expiry date against each worker, attach a photo or PDF of the card, and the matrix shows current, expiring, expired or missing automatically.
Does the software tell me which qualifications are legally required?
No. The system helps you track the requirements your organisation assigns. You remain responsible for determining what applies to your workers and activities. We do not provide legal or health and safety advice.
Outgrown your spreadsheet?
Upload the same file and turn it into a live matrix with automatic expiry reminders.
14-day free trial. No card required.