ACORD 25 certificates to Google Sheets

Certificate of insurance tracking in one spreadsheet.

Upload your subcontractors' ACORD 25 certificates and get every policy as a row: insured, insurer, policy number, limits and expiration date. Your Google Sheet or Airtable base shows what has lapsed and what is due.

25 pages free
One row per policy
PDFs, scans and photos
Expiry board

Days left on every subcontractor's cover.

ParserBee reads the expiration date of each policy from the certificate. Your sheet subtracts today and colours the row. Watch six weeks pass: Copperline Drywall turns amber at 30 days and Peak Roofing's workers comp lapses on 2 November.

Subcontractor COI log · days left = Expires − TODAY()Today: 10 Nov 2026
SubcontractorExpiresDays left
Peak Roofing Co.Workers comp and EL2026-11-02Expired 8 days ago
Copperline DrywallGeneral liability2026-11-3020 days left
Blue Mesa Plumbing Inc.General liability2026-12-1535 days left
Summit Electric LLCWorkers comp and EL2027-01-0152 days left
North Fork HVACGeneral liability2027-02-1496 days left
Vista Concrete LLCGeneral liability2027-05-20191 days left
More than 30 days 30 days or less Expired
Manage certificates of insurance

How do I keep a spreadsheet of subcontractor insurance certificates and expiry dates?

Keep one row per policy, not one per subcontractor, because the policies on one certificate often expire on different dates. Let ParserBee read each certificate into those rows, and let a formula in your sheet flag what has expired, what is due and which limits are too low.

Build the template once from one ACORD 25 with the AI template builder. Then drop a backlog of up to 100 certificates into Data Lab, or let Zapier, Make or n8n send each new one from your inbox.

  • Insured, producer and certificate holder
  • Every policy: type, insurer, number, dates and limits
  • The ADDL INSD and SUBR WVD boxes, as Yes or No
  • Dates as dates and limits as numbers, ready for formulas
ACORD 25

What to extract from an ACORD 25 certificate.

Most US certificates use the ACORD 25 form, so the boxes are always in the same place, but every agency fills them in its own way. These are the fields worth a column. The 2025/12 edition adds a line saying the limits shown may only be what the certificate holder asked for.

Top of the form

  • Certificate date
  • Producer: the agent or broker, with contact
  • Insured: the subcontractor or vendor
  • Insurers A to F, with NAIC numbers

Coverages table

  • Coverage type and insurer letter
  • Policy number
  • Policy effective and expiration dates
  • ADDL INSD and SUBR WVD boxes

Limits

  • GL: each occurrence, general aggregate, products
  • Auto: combined single limit
  • Umbrella or excess: occurrence and aggregate
  • Employers' liability: each accident, disease

Bottom of the form

  • Description of operations (project, endorsements)
  • Certificate holder: your company
  • Certificate and revision numbers
  • Any ACORD 101 remarks page
Limits vs your contract

Catch a $500,000 limit when the contract asks for $1,000,000.

Send the rows to a linked Google Sheet or Airtable base. Add a column with your required limit, and one formula marks every policy as expired, too low, expiring within 30 days, or OK.

  • Keep a small table of required limits per trade or per project
  • Filter by project, trade or insurer
  • ParserBee does not send reminders: an Airtable automation or a Zapier step can email you or the subcontractor
Send certificate data to
Google SheetsAirtableExcelCSVZapierMaken8nGmail, via n8nREST API
Certificate of insurance tracking services

When a COI service or platform is worth the price.

ParserBee removes the typing from certificate of insurance tracking. It is not a COI tracking service or a compliance platform. Pick something else if one of these is your main need.

You want someone to chase vendors

Certificate of insurance tracking services request renewals, follow up with agents and fix deficiencies for you. ParserBee does none of that. It reads the certificates your team collects.

You need endorsements verified

The ACORD 25 says a statement on the certificate gives the holder no rights in place of the endorsement. ParserBee reads the ADDL INSD and SUBR WVD boxes; reviewing the endorsements is still your job or your broker's.

You want a vendor portal

Dedicated COI platforms give vendors an upload link, keep compliance dashboards and send reminders on their own. If you track hundreds of vendors across many projects, compare them first.

Cost per certificate

One certificate, usually one page credit.

An ACORD 25 is one page; an ACORD 101 remarks page adds one more. No per-vendor fee. See pricing.

Try it on 25 certificates

FreeNew accounts get 25 free pages. An ACORD 25 is usually one page, so that is about 25 certificates. No credit card.

200 subcontractors a year

$29 a monthStarter gives 250 pages a month: enough for every new and renewed certificate of a busy general contractor.

1,000 vendors and more

$99 a monthScale gives 1,500 pages a month, for property managers and contractors with large vendor lists.

From the same subcontractors

Their invoices, purchase orders and policies too.

83 ready-made document parser templates across 16 industries, plus any document you build a template for.

Insurance policies

Policy number, insured, insurer, dates, premium and coverage.

Insurance policy data extraction →

Leases

Rent schedule, key dates and options from commercial leases.

Lease abstraction →

Invoices

Subcontractor and supplier invoices with every line item.

Invoice OCR software →

Purchase orders

Orders to subcontractors and suppliers, with every line.

Purchase order OCR →

Insurance documents

Claims, policies and explanation of benefits forms.

Insurance document templates →

Any batch of PDFs

Up to 100 files at once into one spreadsheet.

Convert multiple PDFs to Excel →
FAQ

Certificate of insurance tracking questions

Put your next 25 certificates in a sheet, free.

25 free pages read about 25 one-page ACORD 25 certificates. No credit card. Build your certificate template from one ACORD 25 in about 20 seconds.