PDF to Excel for Insurance: Convert Loss Runs, Policy Schedules, and Claims Reports
Carriers send loss runs, claims registers, and commission statements as PDFs. PDFXLSX turns them into clean Excel in seconds, finding the claim rows, running OCR on scanned carrier reports, and keeping every paid, reserved, and incurred amount numeric so your loss ratios calculate instead of needing a rebuild. Drop a loss run on the right to see it work.
Your first conversion is free, and files are deleted after processing.
Drop your PDF here or click to browse
PDF files up to 50MB
First conversion is free. Nothing to install.
The short answer
To convert an insurance loss run to Excel, upload the carrier PDF to a converter that detects the claim table and exports a spreadsheet, rather than retyping claim numbers, dates, and reserves by hand. You get one row per claim with paid, reserved, and incurred amounts kept numeric, so a five year loss history sorts by claim size, sums by policy year, and feeds a loss ratio calculation immediately. The same conversion works on policy schedules, claims registers, premium bordereaux, and commission statements, which is how agencies, brokers, and carrier analysts get a submission ready without a day of data entry.
Last updated July 2026
Numbers
Stay numeric
Scans
OCR included
Batch
Every carrier at once
XLSX + CSV
Ready for your AMS
Why insurance teams convert PDFs to Excel
A loss run is the claims history a carrier produces for a policy period, and it is the document every renewal and every new submission turns on. It almost always arrives as a PDF, often three to five years of history across several carriers, each with its own layout. To market that account you need the claims in one place: sorted by incurred amount, grouped by policy year, and totaled so you can show an underwriter the real picture rather than a stack of attachments.
None of that works while the numbers sit in a PDF. So an account manager retypes claim numbers, loss dates, and reserves into a spreadsheet, and a single mistyped reserve changes the loss ratio you quote. Converting the file first removes the retyping. The engine reads the claim rows, keeps paid and incurred figures as real numbers, and hands back a sheet you can sort, filter, and total the moment it downloads.
The same intake works for the rest of the paperwork: a policy schedule becomes a location and coverage list you can compare, a commission statement becomes rows you can reconcile against what the carrier actually paid, and a bordereau becomes a premium file you can roll up. Try it on a real carrier report at the top of the page.
| Claim | Loss date | Paid | Incurred |
|---|---|---|---|
| CL-104882 | 03/14/2024 | 4,120.00 | 4,120.00 |
| CL-108317 | 07/02/2024 | 0.00 | 18,500.00 |
| CL-111940 | 11/26/2024 | 9,875.50 | 12,300.00 |
| CL-115206 | 02/09/2025 | 1,240.00 | 1,240.00 |
| CL-119778 | 05/31/2025 | 0.00 | 62,000.00 |
Paid and incurred stay numeric, so the column totals, the open reserves sort to the top, and the loss ratio is one formula away.
Insurance documents you can convert
The PDFs that land in an agency inbox every week, and what you get back in Excel.
| Source PDF | What you do with it | In Excel you get |
|---|---|---|
| Carrier loss runs | Renewal marketing, loss ratio, large loss review | One row per claim with paid and incurred columns |
| Policy schedules and SOVs | Coverage comparison, location and value checks | Location rows with limits and values that total |
| Claims registers and status reports | Open reserve tracking, adjuster follow up | Claim status rows you can filter by open or closed |
| Commission statements | Reconciling agency revenue to what was paid | Policy level commission lines that foot to the check |
| Premium bordereaux | Program reporting, MGA and carrier submissions | Premium detail you can roll up by period |
| Applications and quote comparisons | Side by side carrier options for the client | Comparable fields in columns instead of prose |
Working a specific document type? See the pages for the invoice converter, the bank statement converter, and the PDF table extractor.
Built for the way agencies and carriers work
What matters when the numbers drive a quote, a renewal, or a reserve.
Reserves stay numbers
Paid, reserved, and incurred amounts export as real values, not text, so a loss run column totals and your editable Excel supports a loss ratio without cleanup first.
Scanned carrier reports
Older loss runs and faxed claim reports come back as images. Built-in OCR reads image-only PDFs, so a scanned five year history still lands in a usable grid.
Every carrier in one pass
An account with four carriers means four loss runs in four layouts. The batch converter takes them together, so building the submission is one upload.
Feeds your AMS or rating sheet
Export XLSX for the underwriting file or CSV when your agency management system, rater, or analytics tool wants a flat import file.
Claim data stays private
Claim files carry names, injuries, and settlement figures. Uploads are encrypted in transit and at rest, processed in isolation, and deleted automatically once the spreadsheet is ready.
Fast enough for renewal season
A loss run converts in seconds instead of the half hour it takes to retype it. Across a renewal book with a hard effective date, that time back is the difference between marketing an account and rushing it.
How to convert a loss run to Excel
Three steps, no software to install.
Upload the carrier PDF
Drag one loss run, or every carrier report for the account, into the box at the top of this page. Digital and scanned PDFs up to 50MB are supported.
It reads the claim table
The engine finds the rows and columns across every page, applies OCR to scanned pages, and keeps loss dates and dollar amounts in formats Excel understands.
Download and analyze
Download a clean XLSX or CSV, then sort the largest losses to the top and total incurred by policy year for the submission.
Who this helps
Anyone whose next task starts with a carrier PDF and ends in a spreadsheet an underwriter, a client, or a manager will actually read.
-
Commercial account managers and producers building a renewal submission out of several carriers' loss runs.
-
Underwriters and analysts pricing an account from claims history and exposure schedules that arrive as PDFs.
-
Risk managers at the insured tracking open reserves and total cost of risk across policy years and locations.
-
Agency accounting and operations reconciling commission statements to what the carrier actually paid. The finance team workflow covers the reporting side.
From loss run to loss ratio
Convert each carrier report, stack the claim rows in one sheet with a policy year column, then total incurred by year and divide by earned premium. Because the amounts stay numeric, that calculation is a formula rather than a rebuild, and every figure traces back to the carrier PDF you received.
Handling a long multi-year history? Use the large PDF converter built for documents that run hundreds of pages.
Insurance questions
Upload the carrier PDF to the converter at the top of this page and download an Excel file in seconds. The engine detects the claim table, carries it across every page of the history, applies OCR if the report is scanned, and keeps loss dates and dollar figures as real values. You get one row per claim, ready to sort by incurred amount and total by policy year.
Yes. Convert each carrier report, then paste the claim rows into one sheet and add a carrier and policy year column so you can group them. Layouts differ between carriers, so line up the columns you actually need, usually claim number, loss date, status, paid, and incurred, and leave the carrier-specific extras out of the combined view.
Yes. Built-in OCR reads image-only PDFs, so a scanned loss run or a faxed claim status report still converts to a clean grid. Clear scans read best, so ask the carrier for the native file when one exists. Whatever the source, spot-check the largest claims against the report before you quote off the numbers.
Uploads are encrypted in transit and at rest, processed in an isolated environment, and deleted automatically once your spreadsheet is ready. Nothing is kept, shared, or reused afterward. Claim files often contain names and medical detail, so confirm the deletion policy fits your agency's privacy obligations before running client documents through any tool.
Yes. A schedule or statement of values converts to one row per location with building value, contents, and limits in their own numeric columns, so the totals foot and you can compare what each carrier is covering. That makes it straightforward to check a renewal schedule against last year's and see which locations or values changed.
More ways to convert PDF to Excel
PDF to Excel for Real Estate: Convert Rent Rolls, T12s, and Operating Statements
Convert real estate PDFs to Excel and CSV. Rent rolls, T12 operating statements, and closing statements become clean spreadsheet rows you can underwrite in minutes.
AudiencesPDF to Excel for Accountants: Convert Client Statements and Reports
Convert client bank statements, financial reports, and scanned PDFs to Excel. Numbers stay numeric for reconciliation, month-end close, and QuickBooks import.
AudiencesPDF to Excel for Bookkeepers: Convert Statements and Receipts
Convert client bank statements and receipts from PDF to Excel and CSV. Numbers stay numeric for monthly bookkeeping, categorizing, and QuickBooks or Xero import.
AudiencesPDF to Excel for Finance Teams: Convert Financial Statements and Reports
Convert PDF financial statements and reports to Excel and CSV for your finance team. Numbers stay numeric and drop into models without broken cells or retyping.
Stop retyping loss runs
Drop a carrier report at the top of the page and download a clean Excel or CSV in seconds. Your first conversion is free. For everyday work, start with the PDF to Excel converter or the PDF table extractor.