835 to CSV converter
Convert 835 ERA files to CSV: one row per claim or per service line, with CARC adjustments and RARC remarks. Formula-safe, Excel-ready. Free up to 50 claims per file.
CSV layouts
- Claims CSV (free): payer, trace number, payment date, claim number, patient, member ID, status, dates of service, billed, paid, patient responsibility, contractual and other adjustments, adjustment codes, remarks and balance check.
- Service lines CSV (free): one row per SVC with procedure, modifiers, revenue code, units, billed, allowed, paid and each adjustment.
- Adjustments CSV (Pro): one row per CAS adjustment with group, reason and amount.
- Denials worklist and Patient balances CSVs (Pro).
Files are UTF-8 with a BOM so Excel shows names correctly, amounts are plain numbers with two decimals, and text that starts with =, +, - or @ is escaped so a malicious value can't run as a spreadsheet formula.
Private by design
An 835 is full of protected health information — patient names, member IDs, dates of service and procedure codes. Remitgrid reads the file with JavaScript in your browser tab. The contents are never uploaded, logged or stored, and nothing is saved when you close the tab. You can confirm it in your browser's developer tools (Network tab), or disconnect from the internet after the page loads and keep working.
How it works
- Download the 835 (ERA) from your clearinghouse, payer portal or practice-management system.
- Drop it here. Payments, claims and lines appear instantly, with balancing checks and denials flagged.
- Export claims or service lines to CSV, print a readable remit, or (Pro) download the Excel workbook and denials worklist.
FAQ
Is my 835 uploaded?
No. The file is read by JavaScript running in your browser tab; its contents — patient names, member IDs, claims — are never sent over the network or stored. You can verify this in your browser's developer tools (Network tab), or go offline after the page loads.
Is it HIPAA compliant?
Remitgrid never receives, stores or transmits your files, so no PHI reaches us. HIPAA compliance depends on how your organization handles the files and anything you download — use approved devices and storage, and check with your privacy or compliance officer.
Which files work?
X12 835 health care claim payment/advice files (version 005010X221A1 and most older ones), usually named .835, .edi, .txt, .era or .x12. Files with several payments, any delimiters, and with or without line breaks are supported. 837, 277 and 999 files are recognised and politely refused.
What do the balancing checks do?
For every service line, claim and payment, Remitgrid checks that billed − adjustments = paid, and that claims paid − provider-level adjustments = the check or EFT amount. It also checks segment counts and control numbers. Anything that doesn't add up is marked UNVERIFIED.
Are the code descriptions official?
No. They are short plain-English summaries written by Remitgrid. The official CARC and RARC wording is published by X12 at x12.org/codes, and payers apply codes according to their own policies.
What's free?
Viewing any 835 of any size, the balancing checks, denials view and reason summary are free. Claims and service-line CSVs and printing are free for files up to 50 claims. Pro removes the limit, opens many files at once, and adds the Excel workbook, denials worklist, adjustments and patient-balance CSVs.