NextTool

JSON to Excel

How to use

Flattens JSON records into an Excel sheet, one row per record and one column per key. Drop the JSON file and download the XLSX.

File ConvertersLocal only

Step 1 of 4: Upload

  1. 1
  2. 2
  3. 3
  4. 4

Step 1 of 4 · Upload

When to use this
  • Sharing an API response with a manager or client as a spreadsheet
  • Reviewing exported app data or logs in Excel with filters and sorting
  • Converting a JSON database dump into a workbook for auditing
  • Turning test fixtures into a sheet for a QA team

Free and private. Everything runs on your own device, with no account and no uploads.

API responses, logs and exports often arrive as JSON, which is unreadable for anyone who is not a developer. This converter flattens JSON into an Excel sheet: every object becomes a row, every key a column, nested objects become dotted columns such as address.city, and arrays of simple values are joined into one cell. If the JSON holds several lists, say users and orders, each becomes its own worksheet in the same workbook.

An array of objects (the most common), an array of arrays, an object whose values include arrays (one sheet per array), or a single object (one row).

They are flattened with dots: {"address":{"city":"Pune"}} becomes a column named address.city. Arrays of plain values become a comma-separated cell; arrays of objects are kept as JSON text in the cell.

Every key seen in any record becomes a column, in first-seen order, and records without that key get an empty cell.

The file must be strict JSON: double-quoted keys, no trailing commas, no comments. The error message includes the position of the problem; the JSON Formatter can help find and fix it.

Not directly. Wrap the lines in [ ] with commas between them to make a JSON array, then convert.

How it works
  1. 1

    Add a JSON file

    Drop an array of objects, an object containing arrays, or a single record.

  2. 2

    Convert

    Keys from every record are collected, so columns missing from some rows are still included.

  3. 3

    Review the sheet

    Nested fields appear as dotted column names with a bold, frozen header row.

  4. 4

    Download the XLSX

    Open it in Excel, Google Sheets or Numbers.

More in File Converters
File Converter
Convert images, audio, video, spreadsheets and PDFs between 25+ formats, all in your browser
PNG to JPG
Convert PNG images to JPG with a quality slider and a fill colour for transparency
JPG to PNG
Convert JPG photos to lossless PNG files, individually or in a batch
WebP to JPG
Turn WebP images saved from the web into JPG files that open everywhere
Pro tips
  • ·For very deep nesting, extract the part you need with the JSONPath Tester first
  • ·Keys named in the first record set the column order, so put the important fields first
  • ·Use JSON to CSV when the data is going into another system rather than to a person