How To

How to Convert JSON to Excel in Two Ways

You can convert the JSON file to Excel using Power Query Editor.

Key Highlights

  • You can easily convert JSON to Excel format using the Power Query Editor feature and third-party websites.

JavaScript Object Notation, also known as JSON, is a file format used to represent data in a structured manner based on JavaScript objects. Moreover, with the help of JSON, you can transfer the data in the web applications i.e., server to client, and vice versa. By converting the JSON to Excel, you can easily access them without interruption. As converting is a tougher process, luckily, Microsoft Excel offers an in-built option called Power Query Editor, in which you can convert JSON files to Excel for better reading and easy usage.

How to Convert JSON to Excel

[1] On your PC, open the Excel file and click Data.

[2] Under the Data menu, click Get & Transform Data.

[3] Click Get Data From File From JSON.

Click From File >> From JSON

[4] The import window will open. Move to the place where the JSON file is stored.

[5] Open the file, which will import the JSON file to your MS Excel worksheet.

[6] Once you import the JSON file, the Power Query Editor Window will open.

[7] Navigate to the top corner of the screen and click To Table.

How to Convert JSON to Excel - click the To Table option.

[8] In the following dialogue box, keep the options as default and click OK.

tap the Ok button

[9] You can view the date in the Table format. To see it in full view, click the Expand Column icon.

How to Convert JSON to Excel - click the Expand Column icon

[10] Check the column you want and uncheck the one you want to exclude. Once done, click OK.

[11] The data will be listed in a separate column and if you’re ok with it, click Close & Load.

click Close and Load option.

[12] Now, the data will import from Power Query Editor to your Excel sheet, and you can view them as a table.

[14] Click FileSave. Type the name of the file and click Save.

Click Save button

[13] With this, the JSON file converts to Excel Worksheet.

Tips! Using shortcuts, such as Dash, Comma, and Spaces, you can easily combine two columns in Excel within a few steps.

Converting JSON to Excel Using Third-Party Tools

Using the third-party tool, you can easily convert the JSON files to Excel format. You just need to drag and drop the file and click Convert.

Data Page

[1] Using the browser, go to Data Page Website and click Upload JSON file.

[2] Select the JSON file that you want to convert as an Excel file.

[3] Once you upload the file, click Excel File (XLSL).

[4] That’s it. The JSON file converts to MS Excel.

Frequently Asked Questions

1. What are the best third-party sites to convert JSON to CSV?

Based on your preferences, you can choose third-party sites, such as Data Page, Conversion Tools, Aspose, etc., to convert JSON to CSV.

2. Can you convert JSON to Excel using NodeJS?

Yes. With NodeJS technology, you can convert JSON into Excel format.

Was this article helpful?
YesNo

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button