A certificate of insurance tracking spreadsheet logs each vendor's carrier, coverage types, limits and expiration dates so you can see who is compliant. Below is the exact column template to build one in Excel or Google Sheets, plus a clear look at where spreadsheets break and when COI tracking software is the better call. Upload a certificate above and the AI fills those columns for you in seconds.
Last updated June 2026
Upload your certificates of insurance
Drop files here or click to upload
Up to 50 files
Uploading...
A spreadsheet is a fine place to start. Here is exactly where it stops keeping up, and what software does instead.
| Capability | Excel Spreadsheet | COI Tracking Software |
|---|---|---|
| Data entry | Manual typing from each PDF | AI reads the ACORD 25 automatically |
| Expiration reminders | None, you must remember to check | Automated at 60, 30 and 15 days |
| Coverage verification | Manual, eyeball every limit | Automatic against your requirements |
| Error risk | High, typos in limits and dates | Low, data is pulled from the certificate |
| Scales to | About 20 to 30 vendors | Hundreds to thousands of vendors |
| Missing-COI alerts | None | Flags any vendor without a current certificate |
| Audit report | Build it by hand | One-click export to Excel or PDF |
| Cost | Free, but costs staff hours | Free tier, then transparent monthly pricing |
A well-maintained spreadsheet can work for a small, stable vendor list. Most teams outgrow it once they pass roughly 20 to 30 vendors or start missing renewals. Last verified June 2026.
A spreadsheet stores data well. The trouble is that COI tracking is not really a storage problem, it is a deadline-and-verification problem, and that is where Excel runs out of room.
A spreadsheet does not email anyone. A vendor's policy expires mid-project and the work continues uninsured until someone happens to open the file and notice.
Retyping limits, policy numbers and dates off each certificate guarantees mistakes. One transposed limit or misread date makes your compliance record quietly wrong.
A cell holds whatever you type. It will not tell you a general liability limit is below your $1,000,000 requirement or that the additional insured endorsement is missing.
Copying from PDFs, color-coding dates and adding follow-up notes is manageable for 15 vendors. Past 20 to 30 it becomes a part-time job nobody owns.
Someone saves a copy, emails it, edits the wrong one. With several people and several spreadsheets, certificates get lost and the numbers stop agreeing.
When a client, insurer or auditor asks who was compliant on a given date, a spreadsheet cannot show the history. You reconstruct it from inboxes and folders.
The cost of a missed expiration is rarely the software you skipped. It is the uncovered claim, the contract penalty, or the workers compensation audit that reclassifies an uninsured subcontractor as your own payroll. A spreadsheet is a reasonable first step, and the template below will make yours as good as a spreadsheet can be. Just know what it cannot do, so you can move to software before a gap costs you.
Software does not just store the same columns. It does the parts of COI tracking a spreadsheet leaves entirely to you: reading, checking and reminding.
Upload a certificate and the AI reads the insurer, policy numbers, coverage types, limits, dates and additional insured status, so nothing is typed into a cell by hand.
Set your required limits and endorsements once. Every certificate is verified against them on upload, and anything short is flagged immediately instead of slipping past.
Automated alerts go out at 60, 30 and 15 days before each policy lapses, so a renewal is never missed because no one opened the file in time.
Every certificate, requirement and vendor lives in one searchable place. No duplicate copies, no lost attachments, no disagreement over which file is current.
Export a clean compliance report to Excel or PDF whenever someone asks for proof, with the history a spreadsheet cannot keep.
Group certificates by vendor, project, property or trade and see each party's compliance status on its own, the moment you open the dashboard.
COISoftware reads the same forms you would otherwise retype, from the ACORD 25 certificate of liability insurance to the broader certificate of insurance formats. For the full picture, see our certificate of insurance management software and vendor insurance compliance software, or compare platforms in the best COI tracking software roundup.
Five steps to a working tracker in Excel or Google Sheets. It will do everything a spreadsheet can; the section below shows where it stops.
Add one row per certificate with columns for vendor name, insurance type, carrier, policy number, each coverage limit, effective date, expiration date, additional insured status, waiver of subrogation, date received, status and notes.
Tip: Use one row per policy type, not per vendor, so general liability and workers comp track separately.
Use conditional formatting on the status column so Current shows green, Expiring Soon shows yellow, and Expired or Missing shows red. Color makes problem rows jump out at a glance.
In a helper column, subtract today's date from the expiration date so each row shows the days remaining. Sort by that column to push the soonest expirations to the top.
When a vendor sends a COI, open the PDF and type the carrier, limits, dates and endorsements into a new row. Save the PDF in a matching folder so you can find the source later.
Set a recurring reminder to open the file, sort by days remaining, and email any vendor whose policy is inside 30 days. This manual review is the step software automates entirely.
The exact columns to include, when a spreadsheet is enough, and the point where it is time to switch.
A good tracker captures enough to answer two questions: is this vendor compliant, and when does that change? These are the columns to include:
Build it with one row per policy type rather than per vendor, so a vendor's general liability and workers comp each carry their own limits and expiration dates.
If you track fewer than 20 vendors, your insurance requirements rarely change, and renewals are infrequent, a well-maintained spreadsheet can do the job. The discipline it takes is real: someone has to enter every certificate accurately, review the sheet on a schedule, and chase renewals by hand. As long as that owner exists and the volume stays low, the template above works.
Most teams outgrow Excel once they pass roughly 20 to 30 vendors, start missing renewals, or get burned by a manual-entry error. The tell-tale signs are a sheet that takes hours to keep current, certificates that live in three different inboxes, and the moment a vendor's coverage lapses without anyone noticing. At that point software pays for itself, because it reads each certificate, verifies coverage against your rules, and sends the reminders the spreadsheet never could. You can import your existing list and try it free using the uploader above.
Create one row per policy with columns for the vendor, insurance type, carrier, policy number, limits, effective and expiration dates, additional insured status, and a color-coded status column. Add a formula that counts the days until each expiration, sort by it, and review the sheet weekly to chase renewals inside 30 days.
It should include the vendor name, insurance type, carrier, policy number, each coverage limit, effective and expiration dates, additional insured and waiver of subrogation status, the date received, a color-coded status, and notes for required endorsements. One row per policy type keeps general liability and workers comp tracking separately.
A spreadsheet is good enough for a small, stable vendor list, roughly under 20 vendors with infrequent changes, as long as someone enters every certificate accurately and reviews it on schedule. It cannot read a certificate, verify coverage against your requirements, or send an expiration reminder, so most growing teams outgrow it.
Most teams hit the wall around 20 to 30 vendors. Below that, a disciplined spreadsheet can keep up. Above it, manual entry errors, missed renewals and version conflicts start creating real coverage gaps, which is the point where COI tracking software pays for itself.
Excel cannot send a reminder on its own. You can add a formula that flags how many days remain until expiration and color-code the row, but you still have to open the file and act on it. Sending automated alerts at 60, 30 and 15 days requires COI tracking software.
Yes. The column structure on this page is a complete free template you can recreate in Excel or Google Sheets in a few minutes, with the status, formula and formatting steps included. If you would rather not maintain it by hand, COISoftware has a free plan that reads certificates and tracks expirations automatically.
A spreadsheet is a manual log: you type in every certificate and remember to check it. COI tracking software reads each ACORD 25 with AI, verifies coverage against your requirements, alerts you before policies expire, and exports an audit-ready report. The spreadsheet stores data; the software does the work the data is for.
Read ACORD 25 data, verify coverage and track every COI expiration.
Compare the seven leading COI tracking platforms honestly, side by side.
Collect, verify and track vendor and subcontractor COIs in one place.
