Guides

COI tracking spreadsheet (free CSV template)

A COI tracking spreadsheet needs five columns: vendor name, contact email, policy type, expiration date, and notes. Use one row per vendor per policy line, sort by expiration date, and follow up on anything inside 30 days. Download the free CSV below; it opens in Excel, Google Sheets or Numbers.

Download the CSV template

The columns

ColumnWhat goes in it
nameVendor or subcontractor name
emailWho sends the certificate (the vendor or their agent)
policy typeGeneral liability, auto, workers' comp, umbrella
expiryExpiration date of that line, as YYYY-MM-DD
noteJob, required limits, missing endorsement

Dates as YYYY-MM-DD sort correctly in every spreadsheet app and import cleanly into other tools.

Useful formulas

In Excel or Google Sheets, with the expiry in column D, add a "days left" column:

=D2-TODAY()

And a status column:

=IF(D2<TODAY(),"EXPIRED",IF(D2-TODAY()<=30,"EXPIRING","OK"))

Conditional formatting on the status column (red for EXPIRED, amber for EXPIRING) makes the weekly check quick.

Where spreadsheets fall short

A spreadsheet only helps when someone opens it. It will not email you or the vendor. If the weekly check keeps slipping, see COI Nudge vs a spreadsheet for an honest comparison.

Import this template into COI Nudge

The template's headers are the ones the COI Nudge importer reads. Open the vendor list, choose the CSV, and the free try keeps the first 3 vendors on your device. The paid plan holds up to 100 vendors and sends the reminder emails.

FAQ

Is the template free?

Yes. It is a plain CSV file with example rows you can delete. No sign-up is needed to download it.

Should I track each policy line separately?

If the lines on a certificate expire on different dates, yes. One row per vendor per line means no expiration hides behind another.

What date format should I use?

YYYY-MM-DD, for example 2027-03-31. It sorts correctly and imports cleanly into other tools.

Can a spreadsheet send reminders?

Not by itself. You can add scripts or calendar entries, or use a reminder tool that reads the same columns.

Get an email before a certificate lapses

COI Nudge tracks each expiry date and reminds you 30, 14 and 7 days before, on the day, and after. $9/month, reminders included.

Try 3 vendors free