Home / Free COI tracking spreadsheet

Free COI tracking spreadsheet template

For general contractors and property managers who track subcontractor certificates of insurance (COIs). Works in Google Sheets and Excel. No signup needed.

Download the template (.csv)

What's in the template

How to use it

  1. 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.
  2. Delete the two sample rows and add your subs. Use dates in the format 2027-06-01.
  3. Copy the formulas in the last two formula columns down to every new row.
  4. Sort by Days until expiration, smallest first. Anything negative is already expired.
  5. 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.

See the Coverkite demo

Related: What to check on a subcontractor's certificate of insurance

This template is a general organizing tool, not insurance or legal advice. Your contracts and your insurance agent define what coverage you actually need.