Construction Training Matrix
A free Excel workbook for tracking construction crew training and OSHA certifications by job title, with automatic expiration color-coding once you enter your dates. Free to use and edit, no email required.
.xlsx · opens in Excel or Google Sheets · no signup required to download
Five sheets, three you actually type into.
Set up once, then update it every time someone completes or renews a training.
Requirements by Job Title
Define your job titles and mark which trainings each one needs. 30 training types out of the box, with open columns to add your own.
Employee Roster
Name, position, supervisor, hire date, status, and location for every person you're tracking.
Training Records
One row per completed training, with completion and expiration dates, issuer, and certificate number.
Training Matrix (read-only)
One row per employee, one column per training type, auto-colored red/yellow/green/gray by expiration status. Never type into this sheet directly.
Dashboard (read-only)
Five live counts: active employees, expiring qualifications, expired qualifications, missing required trainings, and renewals due in the next 30 days.
How to Use
A worked example using the sample data already in the workbook, plus a troubleshooting section for the most common setup mistakes.
This spreadsheet still needs someone to watch the dates.
CrewSafety automatically tracks employee requirements, notifies employees and supervisors before qualifications expire, stores supporting documentation, and maintains the employee's compliance record, so nobody has to open a file to catch a problem.