Why convert JSON to XLSX?
JSON is a data-exchange format suited to APIs and applications, but .xlsx lets users sort, filter, and build pivot tables from the same data using familiar spreadsheet tools. Sharing an XLSX removes the need for the recipient to have a JSON viewer or programming environment.
How to convert JSON to XLSX
Microsoft Excel EASIEST
Go to Data > Get Data > From File > From JSON, select your .json file, expand the data in the Power Query editor, and click Close & Load to populate a worksheet.
Python FREE
Install pandas and openpyxl, then run pd.read_json('data.json').to_excel('data.xlsx', index=False) for flat JSON; use pd.json_normalize() for nested structures.
About these formats
.JSON
JavaScript Object Notation file
A JSON file is a plain-text data file in JavaScript Object Notation format, used by web APIs, app configurations, and data exports. Any text editor opens it - Notepad on Windows, TextEdit…
Open .JSON details →
.XLSX
Microsoft Excel Open XML Workbook
An XLSX file is a Microsoft Excel spreadsheet saved in the Open XML format, introduced with Excel 2007 as the replacement for the older binary XLS format. You can open it without buying…
Open .XLSX details →Quality & what to watch
- Flat JSON (an array of simple objects with all keys at the same level) converts to a tidy table in one step; deeply nested objects or arrays-within-arrays need manual expansion in Power Query or flattening code in Python.
- Power Query's JSON import path is fully available on Windows; Excel for Mac has limited Power Query support and may not offer the full JSON import wizard.
- Excel has a row limit of 1,048,576 rows - large JSON exports may be silently truncated; split the file first if your dataset is larger.
Frequently asked questions
Does Power Query work on Excel for Mac?
What if my JSON is deeply nested?
pd.json_normalize() to flatten nested keys into separate columns automatically.
