- You can easily convert JSON to Excel format using the Power Query Editor feature and third-party websites.
How to Convert JSON to Excel
 On your PC, open the Excel file and click Data.
 Under the Data menu, click Get & Transform Data.
 Click Get Data → From File → From JSON.
 The import window will open. Move to the place where the JSON file is stored.
 Open the file, which will import the JSON file to your MS Excel worksheet.
 Once you import the JSON file, the Power Query Editor Window will open.
 Navigate to the top corner of the screen and click To Table.
 In the following dialogue box, keep the options as default and click OK.
 You can view the date in the Table format. To see it in full view, click the Expand Column icon.
 Check the column you want and uncheck the one you want to exclude. Once done, click OK.
 The data will be listed in a separate column and if you’re ok with it, click Close & Load.
 Now, the data will import from Power Query Editor to your Excel sheet, and you can view them as a table.
 Click File → Save. Type the name of the file and click Save.
 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.
 Using the browser, go to Data Page Website and click Upload JSON file.
 Select the JSON file that you want to convert as an Excel file.
 Once you upload the file, click Excel File (XLSL).
 That’s it. The JSON file converts to MS Excel.
Frequently Asked Questions
Based on your preferences, you can choose third-party sites, such as Data Page, Conversion Tools, Aspose, etc., to convert JSON to CSV.
Yes. With NodeJS technology, you can convert JSON into Excel format.