Free Training Matrix Template for Excel and Google Sheets

Building a training matrix from a blank spreadsheet is tedious. You spend the first hour setting up column headers, formatting cells, and trying to remember which training types apply to your sector. Then you spend another hour looking up renewal intervals. Then you realise your conditional formatting formula is wrong.

Skip all of that. Use our training matrix template generator to create a pre-structured template tailored to your sector and team size — ready for Excel or Google Sheets, free, no account required.

This post explains what the template includes, how to set it up, and where its limitations are.

What the template includes

The free training matrix template is structured around the core requirements that apply to UK businesses. It gives you:

A role-training mapping sheet. Rows for job roles, columns for training types. Each cell indicates whether that training is required, recommended, or not applicable for the role. This is the planning layer — it defines what your organisation needs before you start tracking individuals.

An employee tracking sheet. Rows for individual employees, columns for each training type. Each cell captures the completion date, calculated expiry date, and current status (compliant, expiring, or expired). This is the compliance layer — the document you hand to an inspector.

Pre-populated training types. Based on the sector you select in the generator, the template comes pre-filled with the training types most commonly required. For example:

All sectors: fire safety, first aid, manual handling, DSE awareness, health and safety induction
Care: medication administration, safeguarding adults, infection prevention and control, moving and handling of people, Mental Capacity Act awareness
Construction: CSCS card, working at height, asbestos awareness, confined spaces, temporary works
Food and hospitality: food hygiene Level 2, allergen awareness, COSHH, licensing awareness

Each training type includes the typical renewal interval and the regulatory basis (where applicable).

Conditional formatting. Traffic-light colour coding is pre-built. Green for current. Amber for expiring within 60 days. Red for expired. This gives you an instant visual overview of your compliance position.

A summary dashboard. A separate sheet that counts compliant, expiring, and expired entries across the entire matrix. It shows your overall compliance percentage and highlights the training types with the most gaps.

Setting up in Excel

Download the template from the template generator. Select your sector, team size, and required training types. The generator produces an .xlsx file.
Open in Excel (2016 or later recommended). The template uses conditional formatting and formulas that require a modern version of Excel. Older versions may not render correctly.
Edit the role-training mapping. On the first sheet, review the pre-populated roles and training types. Add, remove, or rename roles to match your actual organisation structure. For each role, mark whether each training type is Required (R), Recommended (O for optional), or Not Applicable (N/A).
Add your employees. On the tracking sheet, enter each employee's name, role, and start date. The template will automatically pull in the training requirements for their role from the mapping sheet.
Enter completion dates. For each training the employee has completed, enter the completion date. The expiry date calculates automatically based on the renewal interval for that training type.
Review the dashboard. Switch to the summary sheet to see your overall compliance position. The dashboard updates automatically as you add data.

Tip: Lock the formula cells before sharing the file. In Excel, select the cells containing formulas, right-click, choose Format Cells, go to the Protection tab, and tick "Locked." Then protect the sheet (Review > Protect Sheet). This prevents accidental overwrites — the single most common cause of spreadsheet training matrix failures.

Setting up in Google Sheets

Download the template as above, or select the Google Sheets option in the generator to get a direct link.
Make a copy. If using the direct link, click File > Make a copy to create your own editable version. Do not request edit access to the original.
Follow the same setup steps as Excel above. Google Sheets supports the conditional formatting and formulas used in the template.
Set sharing permissions carefully. If multiple people need access, share the sheet with specific email addresses rather than "anyone with the link." Use "Editor" access only for people who should be entering data. Everyone else should be "Viewer" or "Commenter."
Use version history. Google Sheets automatically saves a version history (File > Version history > See version history). If someone accidentally deletes data or overwrites a formula, you can restore a previous version. This is one genuine advantage Google Sheets has over Excel for shared training matrices.

Tip: Name your versions. After each major update (adding new employees, quarterly review), go to version history and name the current version (e.g., "Q2 2026 review complete"). This makes it much easier to find the right restore point if something goes wrong.

How to get the most from the template

The template gives you structure. What you do with it determines whether it actually keeps you compliant.

Fill it in completely. A half-populated training matrix is worse than none. It gives a false impression of compliance while hiding gaps. If you do not know an employee's completion date for a particular training type, enter "UNKNOWN" rather than leaving it blank. A blank cell is ambiguous — it could mean "not required" or "not recorded." Make the gap explicit.

Check it monthly. Set a recurring calendar entry — the first Monday of every month. Open the matrix, check the dashboard for expiring certificates, and book renewal training. This takes 15 minutes for a small team. Skipping it for three months turns 15 minutes into a morning of firefighting.

Update it when people join or leave. A new starter should appear in the matrix on their first day. A leaver should be archived (moved to a separate "leavers" tab, not deleted — you may need their training records for insurance or legal purposes for years after they leave).

For more examples of how training matrices work across different industries, see our training matrix examples post. And if you want to understand the inspection risks of Excel-based tracking, read our guide on whether your Excel matrix will survive an inspection.

What the template cannot do

Honesty matters here. A free spreadsheet template has real limitations, and pretending otherwise would waste your time.

No automated alerts. The template shows you which certificates are expiring. It does not email you, text you, or notify anyone. If nobody opens the file, nobody sees the red cells. For teams where this is a risk, our post on training expiry alerts covers alternatives.

No audit trail. Excel has no built-in change log. Google Sheets has version history, but it does not tell you which specific cell was changed or by whom. If an inspector asks "who changed this record and when?", a spreadsheet cannot answer.

No version control (Excel). If the file lives on a shared drive, someone will save a copy to their desktop. Someone else will email an old version to a colleague. Within weeks, multiple versions exist and nobody knows which is current. Google Sheets mitigates this with its single-source-of-truth model, but only if everyone uses the shared version.

No certificate storage. The template tracks dates and statuses. It does not store the actual certificates, training provider confirmations, or assessment records. You need a separate filing system for evidence, and you need it to be cross-referenced to the matrix. This is where spreadsheets start to creak.

No role-based access. Everyone who can open the file can see and edit everything. You cannot restrict a team leader to viewing only their team's data. For organisations with multiple teams or sites, this becomes a problem quickly.

These limitations are manageable for small teams. For organisations with 15 or more employees, or those facing regular inspections, the limitations start to outweigh the cost savings. Our comparison of online training matrices vs spreadsheets covers when the switch makes sense.

Start with the template, grow from there

A training matrix is the single most important document for proving training compliance. Starting with a free template is vastly better than starting with nothing. It gives you the structure, the training types, and the tracking mechanisms you need to get your records in order.

Use it. Fill it in honestly. Review it monthly. When the template stops being enough — and for growing teams, it will — you will have clean, structured data ready to migrate into a purpose-built system.

When you outgrow the template, TrainProof is ready. Import your spreadsheet data, add automated alerts and audit trails, and produce inspection-ready reports without the manual overhead.

Join the waitlist to be notified when it is ready.