JSON to Excel Converter
Convert JSON data to Excel spreadsheet format. Paste your JSON, upload a file, or fetch straight from an API URL - then download as .xlsx instantly.
Conversion Options
How to Convert JSON to Excel
- Paste your JSON - Enter your JSON data in the text area, upload a .json file, or fetch from an API URL.
- Check the detected structure - As soon as the JSON parses, the panel above the options reports the rows, columns, and nesting your settings will produce.
- Choose the output shape - Toggle nested-object flattening and array expansion, and pick how nulls are written; the structure numbers update live.
- Click Convert - Our tool will parse your JSON and create an Excel spreadsheet.
- Preview and edit - See your data in a table and click any cell to fix a value before exporting.
- Download - Click the download button to save your Excel file.
How to Import JSON into Excel with Power Query
Desktop Excel can read JSON directly through Power Query. It is powerful but takes several clicks per level of nesting, which is why the converter above flattens nested objects for you in one step.
Power Query (Get Data > From JSON)
Best for: Excel 2016 and later on Windows, and current Microsoft 365 builds on Mac.
- Go to Data > Get Data > From File > From JSON and pick the file.
- The Power Query Editor opens. If the top level is a list, click To Table and accept the defaults.
- Click the expand icon (two arrows) in the column header, choose the fields you want, and untick Use original column name as prefix for shorter headers.
- Repeat the expand step for any column that still shows Record or List - each is another level of nesting.
- Click Home > Close & Load. The data lands as a table on a new sheet, and Data > Refresh All re-reads the file later.
In Google Sheets
Sheets cannot open JSON files directly. Convert the file to .xlsx or CSV with the tool above and import that.
Common mistakes
- Arrays inside records multiply rows. Expanding a List column to new rows repeats the parent fields once per item - expected, but it changes the row count.
- JSON Lines is not JSON. A file with one object per line fails in Power Query's JSON connector; use the JSONL to Excel converter for those.
About JSON to Excel Conversion
JSON (JavaScript Object Notation) is a popular data format for APIs and web applications. Converting JSON to Excel - or JSON to XLSX - makes it easier to analyze and share data with colleagues who prefer working with spreadsheets. This is also the fastest way to turn an API response into a JSON to spreadsheet export.
Our converter handles arrays of objects, converting each object to a row in Excel. Object keys become column headers. Nested objects are automatically flattened using dot notation (e.g., "address.city").
JSON Structures You Can Convert
Array of objects - the most common API shape. Each object is a row:
[
{ "name": "John", "email": "john@example.com" },
{ "name": "Jane", "email": "jane@example.com" }
]Nested objects - flattened with dot notation into separate columns (address.city, address.zip):
[
{ "name": "John", "address": { "city": "NYC", "zip": "10001" } }
]Arrays inside an object - your choice: expand lists of values into a comma-separated cell and lists of objects into indexed columns (items.0.name, items.1.name), or keep them as JSON text in one cell so nothing is dropped from the workbook.
Features
- Support for arrays of objects and single objects
- Detected-structure panel: rows, columns, and nesting depth shown before you convert
- Dot-notation flattening of nested objects (optional)
- Array expansion into columns or comma-separated cells (optional)
- Null policy: blank cells or the literal text null
- Columns built from every row, not just the first object
- Custom worksheet name
- Live preview before download
- Download as standard .xlsx format
- 100% client-side processing for privacy
- No file size limits for reasonable data sizes
Frequently Asked Questions
Yes, our converter is completely free. No hidden fees, no premium tiers, and no signup required.
We support arrays of objects (most common), which are converted to rows. Each object's keys become column headers. Nested objects are flattened using dot notation.
Your data is processed entirely in your browser and never uploaded to any server. Your JSON data remains completely private.
Yes, our converter can handle JSON files up to several megabytes. Very large files may take longer to process.
Yes. The download is a standard .xlsx workbook, so this works as a JSON to XLSX converter as well as a JSON to spreadsheet tool. Open the result in Excel, Google Sheets, LibreOffice, or Numbers.
An array of objects becomes one row per object, with each object key as a column header. Arrays nested inside an object can be expanded too: lists of values become a comma-separated cell, and lists of objects become indexed columns like items.0.name and items.1.name. If you prefer, turn off array expansion to keep them as JSON text in a single cell so nothing is lost.
Yes. Flattening nested objects into dot-notation columns (address.city) and expanding arrays are both toggles, and you can set a custom worksheet name before converting. Most online converters apply one fixed strategy; here you choose the shape of the output.
As soon as your JSON parses, the detected-structure panel reports what the conversion will produce: how many rows, how many columns after flattening with your current toggles, how deeply the data is nested, and whether arrays are present. Change a toggle and the numbers update, so there are no surprises in the downloaded workbook.
You choose. By default a JSON null becomes an empty cell. Switch the null policy to write the literal text null instead, so explicit nulls stay distinguishable from keys that were simply missing. Missing keys are always left blank.
Yes. Paste an API endpoint into the URL box and the JSON is fetched directly in your browser, then converted - handy for turning a REST response into a spreadsheet. The request goes from your browser to the API, not through our servers, so your data stays private. It works with endpoints that permit cross-origin (CORS) requests; if one is blocked, save the response and use the upload option.
Yes. The preview table is editable - click any cell to fix a value, then download. Your edits are written into the .xlsx file.