How To Import JSON To Excel

Updated April 13, 2026

If you're looking to view JSON in Microsoft Excel, you've come to the right place! In this post we'll provide step-by-step instructions to view JSON in Excel. First, it's worth explaining why Excel can't simply open JSON like any other spreadsheet. JSON (JavaScript Object Notation) is a format type widely used in front- and back-end programming and databases, but it's not natively readable by Microsoft Excel. The JSON format is straightforward to work with, but often you may feel the need to access data in tabular form, or in other words use an Excel to JSON Maybe you are more comfortable with spreadsheets while working with data.

Whatever the case, you can easily convert JSON into a CSV file and open it in the spreadsheet software of your choice. So, here are the steps to import a JSON file into Excel. Let us dive straight in.
‍

If your JSON workflow is in healthcare price transparency, you may not need to force machine-readable files into Excel first. Gigasheet's MRF Viewer and healthcare price transparency analytics are built for that workflow.

6 Steps: Import JSON In Excel

Want to automatically convert JSON to CSV for Excel online? Skip ahead.

MS Excel, as you know, is one of the most accessible spreadsheet software options in the world. It is readily available on most modern MS Windows devices and has an estimated 850 million users globally. If you're using Windows and MS Excel 2016 and newer versions, and want to import a JSON file follow these steps below. (If you are using MS Excel 2010 – 2013, skip to the next section.)

1. Open MS Excel

Open the Start Menu using Windows Keys or Clicking the Start Menu icon on your Task Bar. Search and open MS Excel.

2. Create New Workbook

Next, you need to create a blank spreadsheet. Once you have MS Excel’s welcome page in front of you, click on Blank Workbook in the New section. It will create a new spreadsheet for you to work with.

3. Locate the Data Tab

Find and click on the Data tab in the Ribbon menu of MS Excel.

4. Import Data

When you click on the Data tab, it brings up several sections, and one of them is Get & Transform Data. In the section, Click on Get Data, select From File option and then select From JSON option.

5. Select your JSON File

Clicking on From JSON option will bring up an import window. You have to select the drive or folder where your JSON file is located and select the file. Click on Import, and Excel will open the Power Query Editor window. Here, you have the option to choose the way you want data in JSON to appear in a spreadsheet.

6. Convert Data Into Table

At last, to convert JSON into a table, select the option Into Table. And then click Close & Load option in Home tab of Power Query Editor. That’s it. You have a JSON file in a tabular format open in MS Excel.

Now all you have to do is open the File menu and save your spreadsheet. Optionally you can export the data as a CSV file.

Import JSON To MS Excel 2010 – 2013

The steps mentioned above will work on MS Excel 2016 and newer versions. If you are using MS Excel 2010 – 2013, follow the following steps to import JSON to Excel:

a.       Open MS Excel from Start Menu.

b.       Open New Spreadsheet.

c.       In the Power Query tab, click From Other Sources and select Blank Query.

d.       In the Query Editor, select Advanced Editor.

e.       Enter your query string as given below.

Note: Replace “C:\Users\XYZ\Desktop\examplefile.json” with the path to your JSON file.

let    Source = Json.Document(File.Contents(“C:\Users\XYZ\Desktop\examplefile.json”)),    # “Converted to Table” = Record.ToTable(Source)in    # “Converted to Table”

Limitations & Troubleshooting JSON in Excel

Flattening JSON Structure

JSON is a lightweight data-interchange format. It is easy to read and write and can be used in almost all programming languages, but it can be difficult to get a usable format imported into Excel. This is especially true if you're working with a highly complex file. As we've detailed above, there are ways to import JSON into Excel, but if you're unfamiliar with the data schema, and unsure how best to flatten a large JSON, you can be at a dead-end. At Gigasheet we believe that a better approach is to use algorithms to automatically convert JSON to CSV.

JSON & Excel's Max File Size

Like all spreadsheets in Excel, JSON imports are subject to Excel's row limits. Excel's maximum row limit is 1,048,576, and columns are limited to 16,384. If your JSON file is large, say more than a few megabytes, it's likely that Excel will crash. JSON is an ideal format for larger data sets that have a hierarchical structured relationship, but this structure also makes it more difficult to work with in Excel. If you're looking to get around Excel's max row limit, read ahead to learn how to convert JSON to Excel compatible formats online.

Convert JSON for Excel - Online

If you're struggling to get JSON imported to Excel, Gigasheet MRF Explorer can help. You do not need to know the code or need to install any spreadsheet software to convert JSON files to CSV, which can easily be read by Excel.  Gigasheet is a cloud-based big data spreadsheet web application, and it will automatically convert JSON to a tabular format.

If you are working with healthcare machine-readable files instead, you can also start with Gigasheet's MRF viewer or learn more about our price transparency analytics platform.

Here is how:

1.   Create a free account

If you do not have a Gigasheet account, you can start free here. Note: you'll need to upgrade to a paid Business, Enterprise or Price Transparency plan for full JSON support.

2.  Upload your JSON File

Click on "Upload," and you will get the option to locate your file. You can upload JSON files from your computer's local storage or cloud storage.

3.  View online and export

Once the upload is complete, Gigasheet will automatically parse and flatten the JSON file and present it in the tabular format without requiring you to write any code or query. You can filter, sort, split columns, and more with the data.

To save the file as CSV, simply click the File option in the menu and export the file as a CSV.

Why Use Gigasheet MRF Exploerer Convert JSON to CSV?

• Comparing the processes above shows that using Gigasheet to convert JSON to CSV for Excel is much easier than the other two, especially if the file is large or if you aren't intimately familiar with the data structure. There are some other very significant advantages of using Gigasheet over other options...
• First of all, Gigasheet is a web application that you can access from the web browser on your PC, laptop, and even a mobile device.
• Gigasheet allows you to upload files from different sources - local storage or the cloud storage services like Google Drive, Dropbox, SFTP, and AWS S3.
• Even though MS Excel is easily accessible on modern PCs, it cannot process more than 1,048,576 rows of data. Gigasheet, on the other hand, has no such constraints so you can process large multi-gigabyte JSON files.
• Often JSON files are too large, and users compress them to ZIP format to save storage. Gigasheet, by default, supports ZIP format, so you can directly upload compressed JSON files without having to un-compress them first.
• Gigasheet is a no-code big data worksheet. So, when working with big data in Gigasheet, you do not have to write a single line of code or set up a database.

To Conclude

There are ways to import your JSON files into Excel and work with data in tabular spreadsheet format. You can follow any of the processes that best fit your workflow. However, if you work with large JSON files with millions of rows of data, we think Gigasheet is the best way to convert them into CSVs which can then be used in Excel.

Gigasheet does what Excel can't. It offers much higher file limits, no-code JSON flattening, and an easier path to CSV export. Start today for free, explore the MRF Viewer, or learn more about healthcare price transparency analytics.

FAQ

Can Excel open JSON files directly?

Excel can import some JSON files through Power Query, but it does not handle large, nested, or complex JSON especially well. That is why many teams convert JSON to CSV first or use a tool that flattens the data automatically.

What is the easiest way to convert JSON to CSV for Excel?

The easiest option is usually a tool that automatically parses and flattens JSON into tabular columns, then lets you export CSV. That saves time versus manually transforming nested structures inside Excel.

When should I use Gigasheet instead of Excel for JSON files?

Gigasheet is a better fit when JSON files are large, nested, zipped, or too slow for Excel to handle comfortably. It is also useful when you want to filter, sort, and export data without writing code.

What if my JSON file is a healthcare machine-readable file?

Healthcare machine-readable files are usually much larger and more complex than a standard JSON export. In that case, it is better to start with Gigasheet's MRF Viewer or review our price transparency analytics workflows instead of trying to force the file into Excel.