COI and license expiry checker
Most GCs track certificates of insurance in a spreadsheet and find out a policy lapsed after the sub is already on site. Paste the list here and get a sorted, color-coded view with a can-schedule column you can export.
Free. No account. Nothing you paste leaves your browser, and no AI runs on our side. We count tool clicks anonymously, never what you paste.
Columns: Subcontractor, Policy type, Expiry date. Dates like 2026-11-30, 11/30/2026 or Nov 30 2026. Upload .csv or .xlsx (first sheet), or paste from Excel.
How to use it
- Export your COI log or vendor list to CSV, or copy the three columns from Excel.
- Paste it in the box or upload the file. Nothing leaves your browser.
- Set the warning window (30 days by default) and press Check.
- Send renewal requests for every yellow row and hold red rows from the schedule.
- Export the result as CSV and keep it with your weekly look-ahead.
Go further with AI
Copy a prompt into ChatGPT, Gemini or Microsoft Copilot along with your exported results. Check your company’s AI policy first, and have a person review the output.
Prompt 1
Write a short, polite email to [subcontractor] asking for an updated certificate of insurance. Their [policy type] expires on [date]. Ask them to have their broker send the ACORD 25 to [email], naming [owner / GC entities] as additional insured as required by the subcontract, by [deadline]. Keep it under 120 words.
Prompt 2
Here is a CSV export of expired and expiring subcontractor policies: [paste export]. Group it by subcontractor, list the earliest expiry for each, and draft a one-paragraph weekly status note for the project team. Do not add any dates that are not in the export.
Prompt 3
Read this certificate of insurance text: [paste COI text]. Extract insured name, each policy type, policy number, effective date, expiry date and limits as a table. Flag any field you cannot find instead of guessing. Then compare the limits to these subcontract requirements: [paste requirements].
FAQ
Is my subcontractor list uploaded anywhere?
No. The check runs in your browser and nothing you paste leaves it. We count tool clicks anonymously (which button, which tool), never what you paste or open.
What does the Can schedule column mean?
No means at least one policy for that sub is expired or has an unreadable date. Check means something expires within your warning window. Yes means every listed policy is current.
Which date formats work?
ISO (2026-11-30), US (11/30/2026 or 11/30/26), month names (Nov 30 2026 or 30-Nov-2026) and Excel date serial numbers from .xlsx files.
Does it check coverage limits or additional insured wording?
No. It only checks dates. Use the third prompt above with ChatGPT, Gemini or Copilot to pull limits from certificate text, then have someone compare them to the subcontract.
Does it cost anything?
No. It is free with no account, and there is no per-use cost because nothing runs on a server.
Related
Results support review; they do not replace checking the source documents. Not legal, insurance or engineering advice.