People and role context
Employee ID and name, department, site, role, line manager and employment start date let you filter the same requirement across teams and locations.
Free employee training matrix template
Download a practical CSV for Excel or Google Sheets. It connects each role requirement to completion evidence, expiry logic, renewal windows, risk, next action and a named owner—with eight fictional worked rows so you can see how the system operates.
30 useful columns
8 worked examples
Live renewal formulas
No email gate
Published: 15 July 2026. Format: UTF-8 CSV. Works with Excel, Google Sheets and most spreadsheet tools.
What is inside the template
Requirement and risk
Training ID, category, requirement basis, role-required flag and risk level make it clear why the learning is assigned rather than merely whether it was completed.
Completion and evidence
Status, date, provider, method, assessment result, evidence URL and evidence checker distinguish attendance from verified completion.
Renewal and action
Validity, expiry, days remaining, renewal window, renewal status, next action, owner and due date turn the matrix into a working control.
Preview: the operational view
The file contains 30 columns and eight fictional examples, including current, in-progress, expired, no-fixed-expiry and not-required records.
| Employee | Training | Risk | Status | Expiry logic | Next action |
|---|---|---|---|---|---|
| EMP-001 | Emergency First Aid at Work | High | Complete | Completion + 36 months | Book skills refresher |
| EMP-004 | Lift Truck Operator Refresher | High | Expired example | Completion + 12 months | Reassess before equipment duty |
| EMP-007 | Responsible AI Use | Medium | Complete | No fixed expiry | Run quarterly role scenario |
- Current
- Renewal due
- Expired
- No fixed expiry
- In progress
- Not required
Expiry and renewal formulas
The formulas are already present in every example row. After adding your records, copy columns S, T and V down. The column letters below match the downloaded file.
Expiry date (column S)
=IF(OR(Q2="",R2=""),"",EDATE(Q2,R2))
Adds the validity period in months to the completion date. Leave Validity_Months blank when there is genuinely no fixed expiry.
Days to expiry (column T)
=IF(S2="","",S2-TODAY())
A negative value is overdue. Use conditional formatting to make negative values red and upcoming renewal windows amber.
Renewal status (column V)
=IF(L2<>"Y","Not required",IF(P2<>"Complete",P2,IF(S2="","No fixed expiry",IF(S2<TODAY(),"Expired",IF(S2<=TODAY()+U2,"Renewal due","Current")))))
Uses the role requirement, completion status, expiry date and renewal window to produce a plain-language status.
Save a working spreadsheet copy
A CSV preserves the data and formulas but not filters, cell colours, validation rules or protected ranges. Open the download, delete or overwrite the fictional examples, then save as an Excel workbook or native Google Sheet before adding formatting and access controls.
How to set reliable renewal dates
Do not apply one annual expiry rule to every course. Start with the authoritative requirement for the specific subject, then consider role risk, changes to equipment or work, incidents, observed competence, insurer or client conditions and organisational policy.
HSE guidance illustrates why context matters. Its workplace-transport guidance recommends a central employee training register and says refresher timing should depend on risk. Its first-aid guidance states that First Aid at Work certificates last three years while strongly recommending annual refreshers to maintain basic skills. A certificate date and a competence-maintenance action can therefore be different fields.
- Build the role-to-training requirement list before loading employee completions.
- Record the source of each requirement in
Requirement_Basis. - Set validity months and renewal windows requirement by requirement.
- Give high-risk overdue items an operational control, not just a red cell.
- Review the matrix when roles, work, equipment, guidance or risk assessments change.
Keep the matrix useful and proportionate
One row per person-requirement pair
A single employee will have multiple rows. This makes filtering, evidence checks and renewal calculations dependable.
Separate evidence from status
Only mark complete when the required evidence has been checked. Link to a controlled file rather than placing sensitive evidence in the CSV.
Limit personal data
The GOV.UK staff-record guidance says organisations should keep records secure, restrict access appropriately and retain information only while there is a clear business need.
Review ownership, not just percentages
Use the action owner and due date in team reviews. A 96% completion rate can still hide one severe competence gap.
Official guidance used for this resource
- HSE: initial training and central employee training records
- HSE: risk-based refresher training
- HSE: first-aid certificate validity and recommended refresher training
- GOV.UK: recruitment and staff-record data protection
This operational template is not legal, regulatory or health-and-safety advice. Confirm requirements for your workforce, location and sector.
Frequently asked questions
What should an employee training matrix include?
It should connect each employee and role to a defined requirement, status, completion and expiry dates, evidence location, risk level, renewal window, next action and accountable owner.
Can I use this in Excel or Google Sheets?
Yes. Open the CSV in Excel or import it into Google Sheets. Save a native working copy before adding filters, data validation, conditional formatting or protected ranges.
How often should employee training be renewed?
There is no safe universal interval. Use the applicable authoritative requirement and risk assessment, then review after material changes, incidents or evidence that competence has reduced.
Need one live view of workforce training risk?
TIQPlus helps training teams connect role requirements, learning, evidence, renewals and manager actions without relying on disconnected spreadsheets.