Reviewing a roster after importing spreadsheet dates

Reading the imported date column

A pasted spreadsheet often carries a date that looks fine but means something else. Before trusting the roster, sort the certificate list by what runs out next and scan for cards that jumped from current to late the moment the import finished. Lena Fischer's OSHA 10 card, shown as expiring in 51 days, is a good anchor: if the imported row says something wildly different, the column was read wrong.

Comparing one row at a time

Open the original spreadsheet cell and the tracker record side by side. Compare the month and day separately, then the year, and write the two values on a scratch line so the difference is visible.

Example: the sheet held 03/04/2026 and the import recorded 04/03/2026. The row looked current in both places, but the day and month had traded places. Before the fix the card sat 31 days away from the true date; after correcting the record to 03/04/2026, the 60-, 30-, and 7-day emails line up with the actual card.

Cleaning the rest of the roster

Re-check every row that came from the same source file, not just the one that looked wrong. Confirm each certificate PDF or phone photo still matches the corrected date on screen. If a whole column shifted, note the source file name and the date it was pasted on the roster header so the next import can be compared against it.

Related: Cert Expiry Tracker features.