Batch Fill ACORD 25 Certificates from Excel

The ACORD 25 is the Certificate of Liability Insurance (COI) — the standard form that insurance agencies and brokers use to provide evidence of an insured's commercial liability coverage to a third party. It is published by ACORD (Association for Cooperative Operations Research and Development), the global insurance standards body, and is recognized industry-wide by carriers, certificate holders, contractors, landlords, and lenders.

A single ACORD 25 documents multiple policy types on one page: Commercial General Liability, Automobile Liability, Umbrella / Excess Liability, Workers' Compensation, and an "Other" section for additional coverages such as Professional Liability, Pollution Liability, or Cyber. Each policy section lists the insurer, policy number, effective and expiration dates, applicable checkboxes (additional insured, subrogation waived), and the coverage limits.

The ACORD 25 has roughly 60 fillable fields when you count every limit, checkbox, and policy section. That is why renewal season is so painful without automation — an agency with 300 commercial policies renewing in a quarter is looking at 18,000 individual fields to fill if every certificate is done by hand.

1. Select your ACORD 25 PDF. Open Power PDF Filler from the Excel ribbon and select the fillable ACORD 25 form — either the official PDF from your management system or downloaded from acord.org. The add-in detects every fillable field on the form, including all the policy sections, limit fields, and checkboxes.
2. Select & map your Excel data. Each row represents one certificate. Typical columns include insured name and address, certificate holder name and address, NAIC code for each insurer, policy numbers for GL / Auto / Umbrella / WC, effective and expiration dates, all the limit values, and the description of operations text. Map each Excel column to the corresponding ACORD 25 field. Save the mapping as a reusable template named something like "ACORD 25 – Commercial GL" — you only do this once.
3. Click "Ready, Go." Power PDF Filler generates one completed ACORD 25 per row. Download all certificates as individual PDFs (named by certificate holder or policy number using an Excel column), or as a single ZIP file for the entire batch. Email or upload to your COI tracking system.

• Mismatched insurer letters. The ACORD 25 uses INSURER A through F and references each policy by letter (INSR LTR column). If your spreadsheet has the GL policy under INSURER B in one row and INSURER A in another, the policy section won't line up. Standardize so the lead insurer is always INSURER A in your data.
• Dates as text instead of date values. The MM/DD/YYYY format is expected. If Excel stores your effective dates as text strings, results may be inconsistent. Format the date columns as Date in Excel before mapping.
• Currency formatting in limit fields. Some ACORD 25 PDF revisions render the limit fields as text and others as currency. If your limits include the dollar sign and comma (e.g., "$1,000,000"), make sure your spreadsheet stores them as text so the formatting is preserved exactly. If the form expects unformatted numbers, store them as numbers and let the PDF format them.
• Checkboxes filled with text. The ADDL INSD and SUBR WVD boxes are checkbox fields, not text. Use TRUE/FALSE, Yes/No, or 1/0 values — not the literal letter "X". Power PDF Filler will tick the checkbox when the cell is truthy.
• Truncated description of operations. The DESCRIPTION OF OPERATIONS field has a fixed visual area on the printed form. If your Excel cell contains 500+ characters of additional insured language, some text may overflow the visible region. Keep descriptions concise or split long endorsement language across multiple certificates.