About the JSON to Excel Converter
This tool turns a JSON list of objects into a downloadable Excel .xlsx workbook. You paste JSON or drop a .json file in the browser. The converter flattens nested objects into dotted column names like address.city. Lists of plain values join with commas. If a property is an object of lists, the tool creates one sheet per list. You see a preview of the first rows so you can check columns and values before download. All conversion runs in your browser only, so files are never uploaded to a server. The output is a standard Office Open XML .xlsx file that opens in Excel, LibreOffice and Google Sheets. Use it when you need a quick table from API output, log exports, or data samples.
How to use it
- 1Paste your JSON array or upload a .json file
- 2Check the preview of the first rows and columns
- 3Adjust your JSON source if needed and confirm
- 4Download the generated .xlsx file to your device
Worked example
Input JSON: [{"id":101,"name":"Amy","address":{"city":"Leeds","zip":"LS1"},"tags":["news","tech"]},{"id":102,"name":"Ben","address":{"city":"Bristol","zip":"BS1"},"tags":["sports"]}]. Result: data.xlsx with columns id, name, address.city, address.zip, tags. tags cells contain "news,tech" and "sports".
How it works
Turns a JSON list of objects (pasted or from a .json file) into an Excel .xlsx file with one column per keyNested objects become columns such as address.city, lists of plain values are joined with commas, and an object of lists becomes one sheet per listShows a preview of the first rowsRuns in the browser: files are never uploadedResults download straight to the deviceSource: RFC 8259 JSON specificationECMA-376 Office Open XML spreadsheet standard. Last checked 5 November 2026.
What it is good for
- Runs fully in your browser so files are not uploaded
- Shows a preview so you can verify columns before download
- Produces a standard .xlsx file that opens in Excel and LibreOffice
- Accepts a JSON list of objects; NDJSON/JSONL is not supported
- Very large files may hit browser memory limits and slow down
Questions people ask
How do I use this converter?
Paste a JSON array of objects into the input or upload a .json file. Check the preview and then download the .xlsx file to your device.
Does the tool upload my files to a server?
No. The conversion runs in your browser only and files are not uploaded to any server.
How are nested objects handled?
Nested objects are flattened into dotted column names, for example address.city and address.zip. You can inspect these columns in the preview.
What happens to arrays inside records?
Lists of plain values are joined into a single cell with commas. If a property is an object of lists, the tool makes one sheet per list. Check the preview for complex shapes.
Can I convert NDJSON or JSON Lines?
No. This tool expects a JSON list of objects pasted in or uploaded as a .json file. NDJSON and JSONL formats are not supported here.
Will numeric values and dates keep their types?
The preview shows how values will appear. Excel may treat ISO date strings as dates and numbers as numeric cells. Verify the preview before saving.
Help keep every tool free
FreeToolr stays free because people help it grow. Share a tool you like, tell us what to build next, or support us on Ko-fi.