How to Convert JSON to Excel?

Open Excel

Go to the Data tab

Select Get Data

Choose From File

Select From JSON

Browse and open the JSON file

In Power Query Editor, review the imported data

Expand nested fields if needed

Click Close & Load

Save the workbook as an Excel file

If needed, use a JSON-to-Excel converter tool

If needed, copy JSON into a script or app that exports to XLSX

Suggested for You

Trending Today