Free download · Excel (.xlsx)
Free Rail Training Matrix Template
Download a free Excel training matrix framed for rail contractors — PTS / Sentinel-style access, plant and site cards as columns you can rename to match your gangs.
- Starting structure suited to rail contractor language
- Conditional formatting for expired and expiring dates
- Role requirements sheet for operatives and supervisors
- Evidence column for card photos and certificates
No email required. Free to use, including commercially. Rename columns for rail access and plant tickets your contracts assign.
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 |
Quick answer
A rail training matrix is a workers-against-requirements Excel grid that shows who holds which assigned access cards, plant tickets and site inductions — and when they expire. Download this free template, rename columns to match your contracts, and enter real dates. FieldClear can import the same sheet later for automatic status and reminders. It does not determine Network Rail or client rules for you.
What’s in the template
A practical Excel matrix for rail and rail-adjacent contractors who allocate trackside and compound work across mixed gangs — with automatic colour from today’s date.
- Worker rows with role and worker type (employee, subcontractor, agency).
- Conditional formatting for expired, expiring and current dates.
- Blank vs N/A so “not required for this grade” is not mistaken for missing.
- Evidence location so card photos sit with the date.
- A role requirements sheet for operative, lookout / COSS-style and supervisor grades you edit yourself.
Example columns to rename for rail work
Delete anything you do not assign. Examples only — not a mandatory list:
| Example column | Typical use | Watch-out |
|---|---|---|
| PTS / Sentinel-style access | Who can attend which possessions | Scheme names and grades vary by client |
| Plant / RRV category | If you allocate on-track plant | Do not merge categories into one tick |
| First aid / emergency | If assigned to the gang | Role and shift dependent |
| Working at height / harness | If your organisation assigns them | Keep separate from access cards |
| Client / site induction | Possession or compound briefings | Often renews on a short cycle |
How to use it for rail gangs
- Add operatives, lookouts and supervisors — including subcontractors who attend your possessions.
- Split access cards and plant categories into separate columns if different people hold them.
- Enter expiry dates as DD/MM/YYYY.
- Mark N/A for grades that do not need a column; leave blank only when the record is missing.
- Review before mobilising a shift — Excel will not email you.
- When colouring cells becomes the weekly job, run the matrix health check or upload for reminders.
Disclaimer
PTS, Sentinel-style access, plant categories and inductions appear as examples only. Requirements vary by client, route and possession. This is not legal or railway-rule advice. A green cell is not authorisation to enter the railway or operate plant.
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.
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.
Can I track subcontractors?
Yes. Workers can be recorded as employees, subcontractors, agency workers or other worker types, and you can filter the matrix by type.
Can I store certificates?
Yes. Attach supporting evidence such as PDFs and images to worker records, so the certificate sits alongside the expiry date rather than in a separate folder.
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.