Open & View MRFs (Machine Readable Files)

What Are Machine-Readable Files?

Machine-readable files (MRFs) are structured data files, often in JSON or CSV formats, designed for computer processing rather than human readability. They are a key component of the Transparency in Coverage (TiC) regulations, which mandate healthcare insurers to disclose negotiated rates with providers. These files aim to provide stakeholders—such as employers, providers, and analysts—with the raw data needed to analyze costs, compare prices, and make more informed decisions about healthcare services.

Common Uses for MRFs in Healthcare

1. Price Transparency: Organizations use MRFs to uncover negotiated rates for services and benchmark costs.
2. Data Analysis: They provide raw data for building cost models, identifying trends, or detecting anomalies.
3. Compliance: Insurance companies and hospitals use MRFs to ensure compliance with regulatory requirements for transparency.

Challenges with MRFs
While MRFs offer valuable raw data, they present significant hurdles:

• File Size: MRFs often span multiple gigabytes and contain billions of rows, making them difficult to open with traditional business friendly tools like Excel.
• Complex Structure: Nested formats like JSON are not easily navigable without specialized tools. It's also not uncommon for these large files to be invalid or malformed.
• Irrelevant Zombie Rates: MRFs often include numerous reimbursement rates that are technically published but not actively used in real-world claims. These can include placeholder values, inflated outliers, or legacy rates that don’t reflect actual contracted payments. Without filtering these out you risk benchmarking against data that isn’t commercially relevant. Zombie rates and duplicates can account for as much as 90% of the data found in MRFs (which is why we use proprietary AI combined with external claims-based validation to cleanse MRFs). ‍
• Limited Context: A single MRF only provides one piece of the puzzle, often lacking the context needed for actionable insights for negotiations or comprehensive analytics across the market.

How to Open and View MRFs with Gigasheet

Gigasheet is a browser-based tool designed for working with large, complex datasets. Follow these steps to open and explore MRFs:

1. Upload the File
   • If you haven't already, sign up for Gigasheet. You can get started for free with CSVs, but JSON files require paid plan. We offer purpose built analytics and you can learn more about our price transparency solutions here.
   • Upload your MRF file into your Library. Gigasheet supports large files and common formats like JSON and CSV. Gigasheet support files up to 250GB.
2. Gigasheet Automatically Processes the Data
   • For nested JSON files, Gigasheet automatically flattens the structure into columns for easier navigation. Large files can take a while.
   • For our customers we provide access to preprocessed data for any payer or market. This data has been cleansed of zombie rates and enriched with NPI and Medicare GCPIs and expert 1-1 support and guidance.
3. Analyze the Data
   • Filter, sort, and pivot the data to find meaningful insights.
   • For example, filter rows by billing code to identify specific negotiated rates.
4. Export as Needed
   • Save subsets of data for further analysis or share with your team.

Why MRFs Alone Aren’t Enough

Although MRFs provide raw data on negotiated rates, relying solely on one file is unlikely to yield actionable insights for price benchmarking or negotiations. Here’s why:

1. Zombie Rates: many (and sometimes most) rates in MRFs aren’t actually used in practice. Without filtering out these inactive or inflated values, benchmarks can be misleading.
2. Limited Scope: MRFs typically only include data for a single insurer or payer. To benchmark effectively, you need data from multiple payers and providers.
3. Market-Specific Insights: Negotiations require a deeper understanding of market trends, focus areas, and competitive pricing.
4. Data Preparation: Cleaning, normalizing, and comparing data across MRFs is labor-intensive and requires advanced tools.

The Gigasheet Solution: Tailored Price Transparency Analytics

If you’re looking to streamline the complex process of analyzing MRFs and benchmarking prices across your market, Gigasheet for Price Transparency is your answer. Our tailored offering includes:

• Ability to cleanse and analyze any payer dataset to aggregate and compare pricing information.
• Prebuilt workflows to clean, normalize, and benchmark data.
• Insights tailored to your market, clinical focus area, and provider network.

With Gigasheet, you can focus on strategy rather than data wrangling, giving you the edge in negotiations.