How to View Machine-Readable Files (MRFs) in Gigasheet

Gigasheet enables users to explore, filter, and analyze Machine-Readable Files (MRFs) at scale. Follow the steps below to sign up, upload, and work with MRF data in Gigasheet.

Step 1: Sign Up for a Gigasheet Account

Before you can upload and view MRFs, you need to create a Gigasheet account.

1. Go to https://app.gigasheet.com/sign-up.
2. Click on Sign Up Free and enter your email address.
3. Follow the instructions to create a password or sign up with Google SSO.
4. Once logged in, you'll be taken to your Library, where all your datasets will be stored.

Note: MRFs are often large files. Only Business, Enterprise, and Price Transparency plans support working with large-scale MRF datasets.

Step 2: Upload or Connect to Your MRF Data

MRF files can be stored in different locations. Choose the method that works best for you:

A. Upload an MRF File from Your Computer

1. From the Library, click on + New > File Upload.
2. Drag and drop your .json, .csv, .tsv, or .parquet file into the uploader.
3. Wait for the file to process (Gigasheet automatically handles large files in the background).

B. Import an MRF from Cloud Storage

Gigasheet supports direct imports from cloud storage platforms:

1. Click on + New > Cloud Storage.
2. Choose from Google Drive, OneDrive, Box, or AWS S3.
3. Authenticate and select the file you want to import.

C. Query an MRF from a Data Warehouse

If your MRF data is stored in a database or data warehouse:

1. Click on + New > Data Warehouse.
2. Select Snowflake, BigQuery, Databricks, PostgreSQL, or MySQL.
3. Enter your credentials and write a query to retrieve the data.

Step 3: Open and Explore the MRF Data

Once the file has finished processing, follow these steps:

1. Navigate to your Library and click on the uploaded MRF file.
2. The file will open in Gigasheet’s spreadsheet-like interface.
3. Use the column headers to explore the structure of the data.

Tip: If your file is too large to load all at once, Gigasheet will handle it dynamically, allowing for fast queries without loading the entire dataset into memory.

Step 4: Analyze and Filter the MRF Data

Gigasheet provides a range of features to help you interact with MRFs:

Filtering

• Click on a column header and select Filter.
• Define your criteria to narrow down records (e.g., filtering by insurance provider, rate type, or procedure code).

Sorting

• Click on a column header and choose Sort Ascending or Sort Descending to organize records.

Pivot Tables

• Click on Pivot to summarize MRF data by key dimensions like provider name, plan type, or service category.

Formulas and Derived Columns

• Click on + New Column > Formula to create calculations (e.g., average rate comparisons).

Step 5: Export or Share the Processed MRF Data

After exploring and refining your dataset, you may want to export or share it:

A. Exporting Data

• Click File > Export and choose from CSV, Excel, or JSON.
• Select whether to export filtered data or the entire dataset.

B. Sharing Data with Others

• Click Share in the top-right corner.
• Generate a view-only or editable link to collaborate with others.

Step 6: Automate MRF Processing (Optional)

For users handling MRFs regularly, consider automating data workflows:

• Use Gigasheet's API to programmatically ingest, process, and distribute MRFs.
• Set up scheduled data refreshes for recurring analysis.

Final Notes

• Free tier users may experience file size limitations. For large MRFs, upgrade to a Business, Enterprise, or Price Transparency plan.
• Need help? Visit the Help Center