# How to Convert JSON to Excel

**URL:** https://www.compsmag.com/blogs/how-to-convert-json-to-excel/
**Author:** Ayushi Chauhan
**Published:** 2022-05-25
**Updated:** 2022-05-25
**Categories:** Blogs
**Tags:** Blogs Daily, guiderobert, Guides and Tutorials, guiding12, How To Guide, How To Guides, Tips, Tricks
**Reading Time:** 4 min

---

This tip is about the how to Convert JSON to Excel. So read this free guide, How to Convert JSON to Excel step by step. If you have query related to same article you may contact us.

## How to Convert JSON to Excel - Guide

Chances are you are familiar with the JSON record and maybe someone recently sent you one of these documents.  Currently, opening a JSON document is not difficult, but it seems OK to change it to Microsoft Excel (CSV) design for more direct use.  The question is: how can you change a JSON document to Excel?  You would be shocked to find out how simple this is to finish.  Furthermore, this is, in general, what we will examine today.

## How to    Convert JSON to Excel

Converting a JSON file into an Excel spreadsheet is quite simple and the process is quite straightforward.  You start by importing the desired JSON file into Microsoft Excel.  Once the file has been imported, different features from the Excel application are used to convert the data inside the JSON file into a table.  It turns out that Excel comes with a ton of different functions that let you manipulate the data you have inside an Excel file.  Also, you can protect your data by password protecting your Excel files.

Once the data is converted to a table format, you can choose which data you are interested in.  This will allow you to filter the data within the JSON file and only list the values ​​in the required columns.  All of this is done within the Power Query Editor window.  Follow the instructions below to do all this:

First of all, go ahead and open up an Excel file on your computer.

After opening an Excel file, click on the Data option provided in the menu ribbon.

After that, below the menu ribbon, click on the Get Data drop-down menu provided in the left corner.

From the drop-down menu, choose From File > From JSON.

In the Import Data window that comes up, navigate to where the JSON file is stored and open it up.  This will import the JSON file into your Microsoft Excel spreadsheet.  After importing the JSON file, a Power Query Editor window will open up.

In the upper left corner, click the To the provided table option.

Next up dialog box, keep the default options and click the OK button button.

After that, the data was converted into a table.  However, you still cannot see the data.

To see the data, you will have to expand the icons.  To do this, click on the Expand Column icon provided (the one with the double arrows pointing towards each other).

In the dialog box that comes up, choose the columns you want to see and deselect the ones you want to exclude.  Once this is done, click on the OK button button.

Finally, you will be able to see the data listed in separate columns.

For your own convenience, you can choose to move the different columns in the worksheet.  To do this, right-click on a column header and from the drop-down menu choose the Move option.

From there, you can choose to move the column left, right, top or bottom. final.

Once you are satisfied with the layout of your Excel spreadsheet, click on the Close and Load option provided.

By doing this, the data will be imported into your Excel spreadsheet from the Power Query Editor and you will be able to preview the table.

Once that's done, you've successfully converted your JSON file into an Excel spreadsheet.

## Final note

I hope you like the guide How to Convert JSON to Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.

---

*End of Article*