PDF to Excel for Medical Billing: Convert EOBs, Remittances, and Patient Statements
Not every payer sends an 835. Workers comp carriers, auto and no fault plans, small commercial payers, and secondary insurers still mail paper, and somebody has to key it in. PDFXLSX reads the claim line table straight off the page and hands back clean Excel, with billed, allowed, paid, adjustment, and patient responsibility kept numeric so the columns actually foot. Drop a page 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 EOB or paper remittance advice to Excel, upload the PDF to a converter that detects the claim line table and exports a spreadsheet, rather than retyping every service line into your practice management system. You get one row per claim line with date of service, CPT or HCPCS code, units, billed charge, allowed amount, paid amount, adjustment, patient responsibility, and the adjustment reason code, all kept numeric. That is what makes underpayment review and denial trending a formula instead of a manual tally. Billing teams reach for this on the paper that never arrives as an 835: workers compensation, auto and no fault carriers, small secondary payers, and payer fee schedules published as PDFs.
Last updated July 2026
Numbers
Stay numeric
Scans
OCR for mailed pages
Batch
A whole payer batch at once
XLSX + CSV
Ready for your worksheet
Why billing teams still key in paper
Electronic remittance solved most of this problem and then stopped. The large commercial payers and Medicare send an 835 that posts automatically, and for those the conversation is over. The remainder is where the labor sits: workers compensation carriers, auto and no fault plans, smaller regional payers, some secondary and tertiary insurers, and any plan a patient brings in from out of state. Those still arrive as paper or as a PDF in a portal, and a person reads them line by line into the practice management system.
The cost is not only the typing. It is that the data never becomes data. Once a paper EOB is posted, the detail lives in the PM system one claim at a time, so questions that should take a minute take an afternoon. Which CPT codes is this payer routinely allowing below contract? Which denial reason is trending this quarter? How much did we write off to a single carrier last year? Those are spreadsheet questions, and you cannot ask them of a stack of paper.
Converting turns the batch into rows. The engine reads each service line, keeps the dollar columns as real numbers, and returns a sheet where billed minus allowed minus adjustment reconciles per line. From there you can compare the allowed column against your contracted fee schedule, group denials by reason code, or total a payer's write offs for a renegotiation. Try it on a page at the top.
| CPT | Billed | Allowed | Paid | Pt resp |
|---|---|---|---|---|
| 99213 | 185.00 | 112.40 | 89.92 | 22.48 |
| 99214 | 265.00 | 168.55 | 134.84 | 33.71 |
| 36415 | 28.00 | 3.12 | 3.12 | 0.00 |
| 80053 | 142.00 | 14.49 | 14.49 | 0.00 |
| 93000 | 95.00 | 16.72 | 0.00 | 16.72 |
Dollar columns come back as numbers, so allowed against contract is a subtraction rather than a read through.
Billing documents you can convert
Anything with a table on the page. These are the ones billing and RCM teams send through most often.
| Document | What comes back | What it is for |
|---|---|---|
| Paper EOB or remittance advice | One row per service line with billed, allowed, paid, adjustment, patient responsibility | Posting payments from payers that never send an 835 |
| Workers comp and auto carrier EOBs | Claim lines plus the reduction reason text | Fee schedule reductions and appeal support |
| Payer fee schedules | CPT or HCPCS code against contracted rate | Loading contract rates and checking underpayments |
| Denial and rejection reports | Claim, code, denial reason, dollar amount | Trending denials by reason and payer |
| AR aging from a clearinghouse or PM system | Aging buckets by payer with balances numeric | Work lists and month end AR review |
| Patient statements and superbills | Line items, charges, and balances | Balance reconciliation and patient disputes |
| Credentialing and roster documents | Provider, NPI, and effective date columns | Tracking par status across payers |
Fee schedules are the quiet win here. Payers publish them as PDFs, and until that PDF is a spreadsheet you cannot put the allowed column next to the contracted column and see the gap.
Built for the way billing offices work
The details that decide whether a converted remittance is usable or just a picture of one.
Dollar columns stay numeric
Billed, allowed, paid, adjustment, and patient responsibility come back as numbers, not text. A column that looks right but sums to zero is the single most common conversion failure, and it is the one we care most about avoiding.
OCR for mailed pages
Most paper EOBs reach you as a scan from the office multifunction printer. Built in OCR reads image only PDFs, so a mailed page converts the same way a downloaded one does.
Multi page claim runs
A payer batch that runs twenty pages with the table continuing across each one comes back as a single continuous sheet, rather than twenty fragments you stitch together by hand.
Codes preserved as written
CPT, HCPCS, and modifier columns keep their leading characters instead of being helpfully reformatted. A modifier that loses its leading zero stops matching your fee schedule lookup.
Batch a whole day of mail
Upload the stack rather than one file at a time and download the spreadsheets together. Practical when the mail run is the daily bottleneck.
XLSX or CSV
Take the spreadsheet into your own analysis, or use CSV where an import template expects it. The output is an ordinary file you own, with no format lock in.
How to convert an EOB to Excel
Upload the PDF
Drop the remittance, fee schedule, or aging report into the converter at the top of this page. Scanned pages are fine.
The claim table is detected
The engine finds the service line table, maps its columns, and carries the table across page breaks so the batch stays one sheet.
Download and reconcile
Open the XLSX and check the paid column against the payer's stated check total before you work from it. That one tie out catches nearly everything.
Who this helps
The common thread is a paper stack standing between someone and an answer they need in a spreadsheet.
Medical billing companies and RCM firms
You carry the paper burden for every client practice at once, so the minutes per EOB are your margin. Converting a batch also lets you show a client where a payer is underpaying, which is the report that renews the contract.
Practice managers and revenue integrity analysts
You need the allowed amounts next to the contracted rates before a payer renegotiation, and the PM system will not hand you that comparison in a form you can sort.
Billers working denials and appeals
Grouping a quarter of denials by reason code turns a pile of individual write offs into an argument. It also shows which denials are a front end registration problem rather than a coding one.
Workers comp and no fault billing specialists
This corner of billing is the most paper heavy of all, because the carriers are least likely to send an 835 and most likely to reduce to a state fee schedule you have to check by hand. Carrier side teams working the same documents use our PDF to Excel for insurance workflow.
Billing questions
That is your call to make deliberately, not ours to wave away. If you are a covered entity or a business associate, HIPAA requires a signed business associate agreement with any vendor that handles protected health information on your behalf. We do not want you to assume one is in place because a website said the word encrypted, so talk to us through the Enterprise plan before sending live patient data. On the technical side, files move over TLS, are deleted after processing, and are never used for anything but the conversion you asked for. Where a document does not need identifiers to answer your question, such as a fee schedule or a denial summary, redacting first is simply less risk to manage.
No, and it is worth being precise about the difference. We output a spreadsheet, XLSX or CSV, not an X12 835 transaction. If your goal is fully automated posting into the practice management system, you want an EOB conversion service that produces a compliant 835, and several clearinghouses sell exactly that. What a spreadsheet is good for is everything around posting: underpayment analysis against your fee schedule, denial trending by reason code, payer scorecards, and giving a biller a sorted work list instead of a stack of paper.
Yes. Built in OCR handles image only PDFs, which is what a scanned page is. Scan quality drives accuracy more than anything else, so 300 DPI and a straight page make a real difference, and a faxed page that has been through a second generation of copying is the hardest case. Whatever the source, tie the paid column to the check total before working from the sheet. See the OCR PDF to Excel converter for how the scanned path works.
Convert the remittance and the payer fee schedule, put them in two sheets of one workbook, then look up each CPT code from the remittance against the fee schedule and subtract. Anything where allowed is below contract is a candidate for appeal. A lookup formula is the whole job here, and our guide to using VLOOKUP in Excel covers the matching, including why a code stored as text refuses to match one stored as a number.
Treat it as a working file rather than the record. The payer's remittance is the source document and belongs in the file exactly as received, because that is what an appeal, an audit, or a refund request will be judged against. Before you post or report from the sheet, confirm the paid column totals to the check or EFT amount the payer states. If it ties, the extraction is sound. If it does not, you have found either a page the converter missed or a line you would have keyed wrong by hand.
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 keying in the mail run
Drop a remittance 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 convert a stack at once with the batch PDF to Excel converter.