Training matrix template builder

What a training matrix is

A training matrix is a grid with people down the side and training across the top. Each cell answers one question: has this person completed this training, and is it still current? In a safety program it is the fastest way to see gaps before a job starts, for example the new laborer without OSHA 10, or the forklift operator whose three-year evaluation passed last month.

How to build yours

1. Paste your workers, one name per line. Leave it empty to get a blank template with sample rows.
2. Tick the training columns you need. Each one becomes two columns: the date completed and the expiry date.
3. Download XLSX for Excel or Google Sheets, or CSV for anything else. The XLSX version has a frozen header row and first column so names stay visible as you scroll.

The template is free and needs no account. Names stay in your browser for the CSV download. For the XLSX download they are sent to our server only to build the file and are not stored.

Which columns a construction crew needs

Start with what your GCs and state actually ask for, then add the certs that genuinely expire:

Leaving the expiry blank for federal OSHA cards is deliberate. Those cards do not expire, and inventing a date in a spreadsheet leads to pointless retraining. Where an expiry is real, put it in.

Making the spreadsheet useful

A matrix only helps if someone looks at it. Three simple additions in Excel:

• Conditional formatting on the expiry columns: red if the date is before TODAY(), amber if it is within 60 days.
• A "site" column, so you can filter to the crew going to a particular job.
• A "card photo" column with a link to where the scan is stored.

Where spreadsheets break down

A spreadsheet does not send reminders. It does not tell a worker their card is about to lapse, and it does not stop two people from editing different copies. Three common failures:

1. Nobody opens it until a GC asks for cards, and then three are missing.
2. Copies drift. The office has one version and the foreman has another on his phone.
3. Photos live elsewhere, so proving a card exists means digging through texts.

The OSHA card tracker is the same matrix with reminders built in: emails at 60, 30 and 7 days, texts to the worker on the Crew plan, card photos on each record, and a one-click audit PDF. It is free for up to 10 workers. If you need software built around the matrix itself, see training matrix software.

Matrix examples by trade

• Electrical contractor: OSHA 10, OSHA 30 (foremen), NFPA 70E arc flash training, aerial lift/MEWP, CPR/First Aid.
• Roofing contractor: OSHA 10, fall protection, ladder training, aerial lift, heat illness awareness.
• Warehouse: OSHA 10 General Industry, forklift evaluation, hazard communication, lockout/tagout (authorized employees).

Our trade guides go deeper: electricians, roofers and warehouses.

Step-by-step: filling in the template

1. List every worker on one row each, including part-timers and long-term subs you're responsible for. Add trade and primary job site columns.
2. List credentials as columns. Start with what your jobs actually require: OSHA 10/30, NYC SST if applicable, fall protection training, aerial lift, forklift, CPR/first aid, respirator fit test, confined space and competent-person designations.
3. Mark each cell with the completion date, not just "yes." Dates let you see where something is expiring and answer "when?" from GCs.
4. Add an expiry only where one exists. Leave OSHA 10/30 expiry blank unless a state, city or contract sets one. Use the issuer's date for CPR, three years after evaluation for forklifts, and annual dates for fit tests.
5. Shade required cells. Use a fill color for "required for this role," so an empty shaded cell stands out as a gap.
6. Review monthly. Sort by expiry, then book classes for anything within 60 days.

Example rows

In this example, Nguyen has two problems: missing fall protection training that his role requires, and a forklift evaluation due soon. That is exactly what a matrix should make obvious at a glance.

Common mistakes

• Using check marks instead of dates. You can't tell what is about to lapse.
• Inventing OSHA 10 expiry dates. This causes false alarms and wasted retraining. Federal cards don't expire.
• Mixing required and optional training without marking which is which.
• No owner. Someone specific needs to update the file every time a worker is hired, trained or leaves.
• No evidence. A date in a cell is only a claim. Keep the card photo or signed record that backs it up.

From matrix to action

The value of a matrix is the decisions it drives: who to send to class next month, who can't go to the public job on Monday, which site is short a trained first aider. If you find that nobody looks at the file, add reminders or switch to a tool that sends them.

Who should own the matrix

On a small crew, the owner or office manager usually keeps it. Once you have several sites, give each foreman read access and one person write access. Foremen report new cards by sending a photo to the office, and the office updates the file and stores the photo. That keeps one source of truth while still making the field responsible for collecting proof. Whatever the setup, write the process down in two or three sentences so it keeps working when someone is on vacation.

Sharing the matrix with GCs and owners

When a GC asks for training records, send only what they need: the workers on that site and the credentials their contract requires, with copies of the cards. Remove phone numbers, home addresses and anything medical. Fit-test and medical evaluation details stay confidential. A clean, site-specific export also looks more professional than a full company spreadsheet.