Home / Free COI tracking spreadsheet
Free COI tracking spreadsheet template
What's in the template
- One row per policy (not per sub): a sub with general liability and workers' comp gets two rows, because each policy expires on its own date.
- Contacts for the sub and their insurance agent — the agent is usually the one who issues the renewed certificate.
- Effective and expiration dates, each-occurrence and aggregate limits.
- Additional insured and waiver of subrogation columns, so you note whether you received the endorsement, not just the certificate.
- Formulas that calculate days until expiration and a status: Covered, Expiring soon (30 days or less), Expired or Missing.
How to use it
- Google Sheets: open File → Import → Upload, choose the CSV, and keep "Convert text to numbers, dates, and formulas" turned on. Excel: open the CSV directly.
- Delete the two sample rows and add your subs. Use dates in the format
2027-06-01. - Copy the formulas in the last two formula columns down to every new row.
- Sort by Days until expiration, smallest first. Anything negative is already expired.
- Optional: add conditional formatting — red for "Expired", yellow for "Expiring soon".
Tip: set a recurring calendar reminder every Monday to review the sheet. Spreadsheets don't send reminders on their own — that's the gap most teams run into.
When a spreadsheet stops being enough
A sheet works well for a handful of subs. It gets harder when several people edit it, when certificates arrive by email and never get logged, or when nobody remembers to look. If that sounds familiar, Coverkite is being built to send the renewal requests and reminders for you.