Hospital Price Transparency Decoder: What to Do With a Machine-Readable File You Cannot Read

A hospital's price transparency file is written for software, not for patients. It can run to hundreds of thousands of rows, with column names joined by pipes and amounts posted as percentages or formulas. You don't need to read all of it. You need to recognize the few fields that matter for your question and understand what each one does and doesn't tell you. This page is a field-by-field decoder.

What the file is, and what it isn't

Since January 1, 2021, U.S. hospitals have had to publish a machine-readable file of all their items and services, plus a consumer-friendly display of shoppable services (CMS, 2026). The file is the full dataset. The shoppable services display, often a price estimator on the hospital's website, is the version meant for people. If the estimator covers your service, start there. Our step-by-step lookup guide explains how to find both. Use this page once you have the raw file open and can't tell what you're looking at.

CMS publishes a template for the file in three formats: CSV "tall", CSV "wide" and JSON (CMS hospital price transparency repository, 2026). The format changes how the file looks, but not what it contains.

• CSV tall repeats each service on many rows, one for each payer and plan. It's long, but each row reads on its own.
• CSV wide puts each service on one row and adds columns for each payer and plan. It's shorter but can have hundreds of columns.
• JSON nests the information. It's easy for software and hard to read by eye, so you'll want a JSON viewer or a conversion tool.

Big files can be too large for a spreadsheet to open comfortably. A text editor that handles large files, a spreadsheet's import-and-filter function, or a free data tool will let you search for your code without loading everything at once.

The header: who published this and when

The first rows, or the top level of a JSON file, describe the file itself. The CMS template asks for the hospital's name, its locations and addresses, licensure information, the file date and the CMS template version. For 2026 it adds an attestation statement, the name of the person attesting, and the hospital's Type 2 (organizational) NPI (CMS, 2026). Check two things here:

1. Location. Hospital systems sometimes publish one file per campus. Make sure it's the campus where you'd be treated.
2. Date. A file that's a year old may not reflect current contracts. Note the date beside any price you copy.

The item: what exactly is being priced

Each row describes an item or service with a general description, a billing code, a code type and any modifiers. Drugs also carry a unit and a type of measurement, and every item carries a setting (CMS, 2026).

If you don't know your billing code, ask the doctor's office that scheduled the procedure. Without it you're matching labels, and labels in these files are not standardized.

The charges: which number is which

The CMS template's charge fields include the gross charge, the discounted cash price, payer name, plan name, the standard charge method, a negotiated dollar amount, negotiated percentage or negotiated algorithm, the de-identified minimum and maximum negotiated charges, and free-text notes (CMS, 2026).

Gross charge

The hospital's list price. It's useful for context and rarely what anyone pays. Our guide to chargemaster vs cash price explains why.

Discounted cash price

The amount the hospital will accept from a patient paying directly. If you'll be self-pay, this is the starting point. Check whether it covers only the hospital's own charge.

Payer name, plan name and negotiated amount

The contracted rate for one insurer and one plan. Your card's insurer may appear many times with different plan names. Use the row that matches your actual plan. If you can't tell, the insurer's member services line can tell you which network your plan uses.

Negotiated percentage or algorithm

Some contracts don't set a dollar amount. A percentage row means the hospital is paid a share of some base amount, and the file may not tell you the base. An algorithm row describes a formula in words. Neither gives you a number to copy. If your plan's row looks like this, ask the insurer for an estimate based on the contract.

Standard charge method

This tells you the unit behind the negotiated amount, for example a fee schedule, a per-day rate or a case rate for a whole stay. Two rows for the same code can be priced on different bases, so compare like with like.

De-identified minimum and maximum

The lowest and highest negotiated charges for the item across payers, without naming them. This shows the spread of contract rates. It doesn't show the range patients actually pay.

Allowed-amount fields (new for 2026)

For 2026, CMS replaced the estimated allowed amount with a median allowed amount, the 10th and 90th percentile allowed amounts, and a count of allowed amounts (CMS, 2026). These describe what was actually allowed on claims, rather than contract terms, which helps with percentage and algorithm rows. A low count means the figure rests on few claims.

Reading one row from left to right

Here's an illustrative row, invented for this example, as you might see it in a tall CSV: a description of an outpatient procedure; a procedure code; setting "outpatient"; a gross charge; a discounted cash price; a payer name and plan name; a standard charge method of "fee schedule"; a negotiated dollar amount; and a note. Read it as five questions:

1. Is this my procedure, by code, and my setting?
2. Am I self-pay (use the cash field) or insured (find my plan's row)?
3. Is the negotiated amount in dollars, or will I need the insurer to calculate it?
4. Does the note mention exclusions, such as implants or professional fees?
5. What other providers will bill separately for the same visit?

The fifth question is the one the file can't answer. A hospital's file covers the hospital's charges. Surgeons, anesthesia groups and pathologists who bill separately won't necessarily appear.

Turn the row into a commitment

A transparency file is research, not a quote. Once you have a likely number:

• Insured: ask the insurer for a cost estimate for the codes and facility, and ask the hospital to confirm your plan's rate.
• Self-pay: ask every billing provider for a written Good Faith Estimate. Our article on cash pay vs insurance pricing explains what those estimates cover.
• Comparing with care abroad: use the number you would actually pay, not the gross charge.

If the file is missing, broken or unreadable

CMS audits a sample of hospitals, investigates complaints, and can impose civil monetary penalties for noncompliance. Enforcement of the new 2026 requirements began on April 1, 2026 (CMS, 2026). If a hospital's file is missing or can't be opened, you can report it to CMS through the complaint route on that page. In the meantime, ask the hospital's patient financial services office for a written estimate. You're entitled to ask, and the request is often quicker than the file.

Frequently asked questions

What is the difference between a tall and a wide transparency file?

Both are CSV formats in the CMS template. A tall file repeats each service on a separate row for each payer and plan. A wide file puts each service on one row with a column for each payer and plan. The content is the same.

Why does my plan's negotiated rate show a percentage instead of dollars?

Some contracts pay a share of a base amount or follow a formula, and the template allows those to be posted as a percentage or algorithm. Ask your insurer to turn it into a dollar estimate for your procedure.

What are the new allowed-amount fields in 2026 files?

For 2026 the CMS template adds a median allowed amount, the 10th and 90th percentile allowed amounts, and a count of allowed amounts. They describe what was actually allowed on claims, which helps when contract rates aren't in dollars.

Does the hospital file include the surgeon's fee?

Not necessarily. The file covers the hospital's own charges. Surgeons, anesthesia groups and pathologists who bill separately may not appear, so get their estimates directly.

What can I do if a hospital's file is missing or won't open?

CMS audits hospitals, investigates complaints and can impose civil monetary penalties. You can complain to CMS, and in the meantime ask the hospital's patient financial services office for a written estimate.

Related MedicalCosts tools

Quote and comparison network