Certificate of Insurance Tracking Template: Columns, Excel Setup, and When to Upgrade

Last updated July 2026.

A certificate of insurance tracking template is a spreadsheet with one row per vendor and columns for the carrier, each coverage type and its limit, the additional insured and endorsement status, the policy effective and expiration dates, and a compliance flag. At minimum it needs vendor name, insurer, general liability limit, auto and umbrella limits, workers compensation, additional insured yes or no, expiration date, and status. The template works until the vendor count and renewal volume outgrow what one person can watch by hand.

If you have landed here, you are almost certainly staring at a folder of certificate PDFs and deciding whether a spreadsheet is enough. It can be, for a while. Below is exactly what to put in the template, how to build it in Excel or Google Sheets, and the point at which the spreadsheet stops protecting you and starts hiding gaps.

The columns a certificate of insurance tracking template needs

A useful COI tracking template captures four things about every vendor: who they are, what they carry, whether it meets your requirement, and when it expires. Here is the column set that covers all four.

Column	What it holds	Why it matters
Vendor / subcontractor name	Legal name of the insured	Ties the certificate to the contract and the work
Insurance carrier	Named insurer on the certificate	Lets you gauge the carrier rating and follow up on claims
General liability limit	Each-occurrence and aggregate GL limits	The most common requirement, and the one most often short
Auto liability limit	Combined single limit for autos	Required whenever a vendor drives to your site
Umbrella / excess limit	Excess limit over the primary policies	How most contracts reach a required 2 or 5 million
Workers compensation	Statutory coverage plus employers liability	Protects you from a subcontractor employee injury claim
Additional insured	Are you named, on ongoing and completed operations	The endorsement that actually extends coverage to you
Waiver of subrogation	Present or not	Stops the vendor insurer from coming back at you
Primary and noncontributory	Present or not	Puts the vendor policy in front of yours
Effective date	Policy start date	Confirms coverage was in force when work began
Expiration date	Policy end date	Drives every renewal reminder you will ever send
Status	Compliant, expiring, expired, or short	The one column a manager actually scans

Add optional columns for the certificate holder name, the project or property the vendor works on, the date you last received a certificate, and a link to the stored PDF. That is the full shape of a working certificate of insurance tracking spreadsheet.

What is a certificate of insurance tracking template?

A certificate of insurance tracking template is a preformatted spreadsheet used to record and monitor the insurance every vendor, subcontractor or tenant carries. Each row is one insured party, and the columns hold the coverages, limits, endorsements and expiration dates from their certificate. The template turns a pile of PDFs into a single list you can sort by expiration date and filter by compliance status.

It is the starting point almost every risk manager, property manager and general contractor uses before moving to dedicated software. The template itself is free to build; the cost is the manual work of reading each certificate and keeping every row current.

What columns should a COI tracking spreadsheet have?

At a minimum, a COI tracking spreadsheet should have vendor name, insurance carrier, general liability limit, auto and umbrella limits, workers compensation status, additional insured status, waiver of subrogation, policy effective and expiration dates, and an overall compliance status. Contracts that require specific endorsements should add a column for each one so nothing is verified by memory.

The trap is stopping at name and expiration date. A template that tracks only when a policy expires tells you nothing about whether the coverage ever met your requirement in the first place. A certificate can be perfectly current and still be missing the additional insured endorsement your contract depends on, which is why the endorsement columns matter as much as the dates.

How to build a certificate of insurance tracking template in Excel or Google Sheets

You can build a workable template in about fifteen minutes:

Put the columns above across row 1 and freeze the top row so headers stay visible.
Format the effective and expiration columns as dates, not text, so you can sort by them.
Add a conditional formatting rule that turns the expiration cell red when the date is within 30 days of today, and amber within 60 days.
Add a status column with a short data-validation list: Compliant, Expiring, Expired, Short.
Store each certificate PDF in one folder and paste the file link into a column so the source is one click away.
Sort the whole sheet by expiration date every Monday so the next renewals sit at the top.

That routine is the entire value of the spreadsheet: a weekly sort that surfaces what expires next. The moment nobody runs the sort, the template goes stale and a lapsed vendor keeps working with no coverage on file. Beyond insurance, many teams keep the same vendor list for tracking what each vendor costs them across the year, which is a reminder that a spreadsheet is a general ledger of manual work, not a monitoring system.

Where a certificate of insurance tracking spreadsheet breaks down

The spreadsheet is fine at ten vendors. It breaks in predictable ways as you grow:

Nobody reads the certificate for you. Every field in every row is typed by hand off a PDF, so one transposed limit or mistyped date makes the sheet quietly wrong.
Coverage is listed but never checked. A row can say a vendor carries general liability without anyone confirming the limit meets your requirement or that the additional insured endorsement is real.
Renewals depend on a person remembering. The conditional formatting only helps if someone opens the file. There is no reminder that reaches the vendor on its own.
Mid-term cancellations are invisible. A policy can be cancelled months before its expiration date, and a spreadsheet that watches only the expiration column never sees it.
There is no audit trail. When an owner, lender or insurer asks you to prove a vendor was covered before they worked, a spreadsheet shows what was typed, not that a real certificate was verified on a real date.

When to move from a spreadsheet to COI tracking software

The rule of thumb: once you are tracking more than about 25 to 50 vendors, or once a lapse would cost you real money, the manual template costs more time than it saves. Software reads each certificate with AI, checks it against the rule you set, chases the renewal automatically, and keeps a dated record you can hand an auditor. That is the job a COI tracking system does, and the migration from a spreadsheet is usually a same-day import.

You do not have to guess whether a certificate is complete either. The same checks behind certificate of insurance verification flag a short limit or a missing endorsement the instant a certificate arrives, instead of waiting for a weekly sort to catch it. If you want the background on the workflow itself, our guide to what COI tracking is walks through every step from requesting a certificate to monitoring it.

Do you still need a template if you use software?

No. Once software is reading and verifying certificates, the spreadsheet becomes a report you can export rather than the system of record you maintain by hand. Most teams keep a template only as a familiar way to share a compliance snapshot with an owner or a board, while the live tracking, verification and renewal chasing happen in the software. Start with the uploader at the top of this page to see a certificate read in seconds, then decide whether a spreadsheet is still doing you any favors.

PDF, JPG, PNG, BMP, HEIC, TIFF