Free converter
Paste a carrier rate table, get a spreadsheet.
The rates arrive in an email, a portal grid or a PDF, and the comparison lives in Excel. This moves them across without retyping a number. Free, runs in your browser, no account.
Converter
Paste the rate table. Get the spreadsheet.
Copy the rates out of the carrier email, the portal or the PDF and paste them below. The tiers, plans and dollar amounts are picked out as you type. Nothing leaves your browser.
Waiting for a rate table
Paste anything with coverage tiers and dollar amounts. If the text has no rates in it, the whole thing is listed below as not recognised rather than guessed at.
What it recognises
- Coverage tiers
- Employee, Employee + Spouse, Employee + Child(ren), Family, and the three-tier Employee + 1 and Employee + 2 or more. Abbreviations like EE, ES, EC, EF and EE+SP are read too.
- Layouts
- Tiers down the side with plans across (the usual carrier grid), plans down the side with tiers across (most portals), and one value per line as a carrier email lists them.
- Plan-design rows
- Individual and family deductible, out-of-pocket maximum, coinsurance, primary care and specialist copays, prescription and network rows, kept as written.
- Separators
- Tabs from Excel or a portal, two or more spaces, pipes, commas, a colon, and the dotted leaders a PDF uses between a label and its amount.
What it does not do
- Anything that is not a tier, a plan-design label or a dollar amount is listed as not recognised and left out. The converter does not guess.
- Rates with a month and an annual column on the same row are read as two plans, not one. Paste one column at a time.
- Age-banded or composite rates by age band are not tiers and come through as unrecognised lines.
- Scanned images and PDFs that do not let you select the text have nothing to paste. Those are what the product's document reader is for.
From the spreadsheet to the comparison
The CSV drops straight into the free employee benefit comparison template or the group health insurance comparison spreadsheet, which already have the tier rows and the contribution math laid out. From there the employee benefit deduction calculator turns a premium and an employer contribution into the per-paycheck figure. Not sure what on the sheet is a rate and what is not? How to read a carrier rate sheet is the six checks, and how to compare two health insurance quotes is what to do with the spreadsheet next.
When the packet is forty pages of PDF rather than one rate table, pasting stops being the fast path. Planlined's carrier quote PDF parsing reads the quotes, SBCs and rate sheets themselves, keeps every value beside its source page, and carries the approved case into the side-by-side benefit quote comparison. The Smart Paste post covers what the in-app version of this converter does with messier text.
Done pasting? Upload the whole packet instead.
Your first proposal is free, no credit card. Drop in the carrier files as they arrived and review the comparison instead of building it.
Rate sheet converter questions
Does the rate table leave my browser?
No. The converter runs entirely in your browser on the text you paste. Nothing is uploaded, stored or sent to Planlined.
Is this the same parser Planlined uses on carrier documents?
No. This is a small set of rules for text you can select and copy: tier labels, plan names and dollar amounts. The product reads the carrier PDF itself, including scanned and image-only files, keeps every value next to the page it came from, and flags what it is unsure of for review.
Which tier structures does it recognise?
The four-tier structure (employee, employee plus spouse, employee plus children, family) and the three-tier structure (employee, employee plus one, employee plus two or more), in full words or the usual abbreviations.
What happens to lines it does not understand?
They are listed under "not recognised" and kept out of the table, so you can check them by hand. A line that looks like a rate but is not one is never slipped into the spreadsheet.
Can I paste more than one plan at a time?
Yes. A grid with several plan columns, a portal table with one plan per row, or an email that lists each plan and its tiers one after another all come through as one spreadsheet with one row per plan.