A spreadsheet is free, flexible and already open on your laptop. For a small crew it is honestly fine. Here's where it starts to break.
Where spreadsheets win
- Zero cost and no new login.
- Total flexibility. Any column you want.
- Fine for a handful of workers whose federal OSHA cards never expire.
Our free training matrix template is built for exactly that.
Where they fail
- Nobody gets reminded. Conditional formatting turns a cell red, but only if someone opens the file.
- Photos live somewhere else. The sheet says "OSHA 10 ✔", and the card is in a text thread from 2023.
- Version sprawl. "Matrix_FINAL_v3 (2).xlsx" on three laptops.
- Sharing is clumsy. Sending a GC the cards for one site means filtering, exporting and attaching photos by hand.
- Field access. Foremen won't open a spreadsheet on a phone in the rain.
The tipping point
Most contractors feel the pain when they have expiring credentials (forklift, CPR, fit tests, NYC SST cards), more than one site, or GCs asking for proof weekly. That's usually somewhere past 10 workers.
What a tracker adds
Automatic reminders by email or SMS, card photos stored with each cert, per-site requirement gaps, and one-click PDF or CSV exports. The OSHA Card Tracker has a free plan for up to 10 workers, so you can try it without giving up your sheet.
An honest cost comparison
People compare a free spreadsheet with a monthly subscription. The real comparison is the time someone spends keeping the sheet current, plus the cost when something slips through.
| Spreadsheet | Certification tracker | |
|---|---|---|
| Software cost | $0 | Free tier for small crews; paid plans for SMS, photos and multiple sites |
| Weekly upkeep for 25 workers | 1–2 hours: checking dates, chasing photos, emailing GCs | Minutes: reminders and exports are automatic |
| Reminders | Only if someone opens the file | Email and SMS at set intervals |
| Card photos | In texts, email and phone galleries | Stored with each certification |
| Sharing proof with a GC | Filter, export, attach photos by hand | One PDF or link per site |
| Field access | Awkward on a phone | Built for phones |
| Audit trail | Whoever edited last | Change history |
If the person keeping the sheet costs $35 an hour, 1.5 hours a week is about $2,700 a year. One worker removed from a public job for a missing card, or a lapsed forklift evaluation found during an inspection, can cost more than that in a day.
How to make a spreadsheet work if you keep one
A spreadsheet can work well for a small crew if it is built carefully:
- One row per worker per credential, not one row per worker with 20 columns. It is easier to sort and filter.
- Separate columns for completion date and expiry date. Leave expiry blank for federal OSHA cards.
- A status column calculated by formula, for example: blank expiry = "No expiry"; expiry within 60 days = "Due soon"; past = "Expired".
- Conditional formatting on the status column: green, amber, red.
- A link to the photo of each card in a shared folder, named consistently:
Lastname_Firstname_OSHA10.jpg. - One file, one owner, stored in a shared drive, not on a laptop. Turn on version history.
- A weekly calendar reminder for the owner to open the file and act on everything amber.
Our free training matrix template has these formulas built in.
Warning signs you have outgrown the sheet
- You found out a credential had expired because a GC or inspector told you.
- Foremen keep their own copies of the sheet.
- Card photos are scattered across texts and personal phones.
- You run more than one site with different requirements, such as an NYC SST job and a Nevada job.
- You spend more than an hour a week on it.
- The person who maintained it left, and nobody understands the formulas.
Two or more of these usually means a tracker will pay for itself in saved time alone.
What to look for in a tracker
If you decide to switch, judge tools on what matters for construction crews:
- Correct expiry logic. It should not invent expiry dates for federal OSHA 10/30 cards, and it should support local rules like NYC SST and Nevada's 15-day deadline.
- Text reminders with consent and opt-out, because field crews do not read email. See SMS reminders for crews.
- Photo upload from a phone, by the worker or the foreman.
- Per-site requirements and gap reports, so you see who is missing what before they arrive.
- One-click proof for GCs: a PDF per site, or a link.
- Language support for crews that work in Spanish.
- Export, so your data is never locked in.
- Pricing you can predict as the crew grows.
A migration plan that takes one afternoon
- Clean the sheet: one row per worker per credential, correct dates.
- Add workers to the tracker, starting with the crews on your busiest sites.
- Upload card photos as you go; ask workers to send missing ones.
- Set site requirements for each active job.
- Keep the sheet read-only for a month as a backup, then archive it.
For a fuller picture of what good records look like, read audit-ready training records and how to track OSHA cards for a crew.
Formulas that do the work
If your sheet has the completion date in column E and the expiry date in column F, these formulas (Excel and Google Sheets) keep the status honest:
- Status (G):
=IF(F2="","No expiry",IF(F2<TODAY(),"Expired",IF(F2-TODAY()<=60,"Due soon","OK"))) - Days left (H):
=IF(F2="","",F2-TODAY()) - Forklift next evaluation, when E is the last evaluation date:
=EDATE(E2,36) - Nevada 15-day deadline, when E is the hire date:
=E2+15 - Replacement deadline for any OSHA Outreach card, five years after the class:
=EDATE(E2,60)
Then filter on "Due soon" every Monday. That one simple weekly habit prevents most lapses on a small or medium crew. Assign it to a named person, and give them a backup for weeks when they are on vacation.
Two contractors, two right answers
An 8-person remodeling company in Ohio. No state OSHA 10 law, private jobs, everyone has OSHA 10, one forklift operator and two first aiders. Expiring items: three, all predictable. A spreadsheet with the formulas above and a monthly calendar reminder is the right choice. Paying for software would not save much time.
A 40-person mechanical contractor working in New York City, New Jersey and Connecticut. NYC SST cards for most of the crew, Connecticut public works with the four-hour refresher rule for licensed plumbers, weekly GC requests for proof, six forklift and telehandler operators, fit tests for the sheet metal crew. Expiring items: around 60 a year, spread across three states. Here the spreadsheet costs hours each week, and one lapsed SST card can keep a worker off site. A tracker with SMS reminders and per-site gap reports pays for itself quickly.
Most contractors are somewhere between these two. Count your expiring credentials per year and the number of times a GC asks for proof per month. Those two numbers tell you which side you are on.
Sources and further reading
The dates in the formula examples come from these rules.
- OSHA Outreach Training Program: federal OSHA 10 and 30 cards do not expire.
- NRS 618.983: Nevada's 15-day rule used in the formula example.
- 29 CFR 1910.178(l)(4): the three-year forklift evaluation.
- Microsoft EDATE function: date math used in the formulas.