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.
• 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 (large MRFs may require an upgrade to a paid plan). For the best MRF data we strongly recommend our purpose-built Price Transparency analytics.
   • 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.
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. Limited Scope: MRFs typically only include data for a single insurer or payer. To benchmark effectively, you need data from multiple payers and providers.
2. Market-Specific Insights: Negotiations require a deeper understanding of market trends, focus areas, and competitive pricing.
3. 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:

• Integration with major payer datasets to aggregate and compare pricing information.
• Prebuilt workflows to clean, normalize, and benchmark data.
• Insights tailored to your market, focus area, and provider network.

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