Home › Spreadsheets & Data › JSON to Excel
X

JSON to Excel

Convert a JSON array to an Excel workbook.

✓ Free✓ No watermark
Advertisement
  1. 1Upload
  2. 2Settings
  3. 3Download

How to use JSON to Excel

Add your file (or type your content) using the box above.
Adjust the options if you want something different from the defaults.
Click the button, then download your result.

About JSON to Excel

JSON is how most apps and APIs hand over data, but almost nobody reads it comfortably, and a list of records is much easier to sort, filter and chart in Excel. This free tool turns a JSON array into an .xlsx workbook right in your browser: choose a .json file or paste the text, press the button and download a workbook with one sheet named Data.

Each object in the array becomes a row. The column headings are the keys, collected from every object in the order they first appear, so records that are missing a field simply leave that cell empty. The header row is bold. If a value is itself a list or an object, it is written into the cell as JSON text so nothing is silently lost. An array of arrays is also accepted and is copied cell for cell.

How it works: the tool reads a JSON array of objects, uses the keys as column headings and writes each object as a row in an .xlsx workbook that opens in Excel, Numbers or Sheets.

Step by step: 1) paste or add the JSON; 2) convert; 3) download the workbook; 4) open it and confirm columns and values.

Realistic limits: spreadsheets are flat. Nested objects and arrays do not become neat columns and may appear as text or need flattening. Keys that are missing from some objects leave blank cells. Invalid JSON, such as trailing commas, must be fixed first. Large inputs depend on browser memory.

Typical uses: analysing API output, sharing a data export with non-developers, or building reports from application data.

Preparing the JSON: use an array of objects with the same keys, since the first object's shape guides the headings. Make sure the syntax is valid, with double quotes around keys and no trailing commas. If your data is nested, flatten the parts you need into simple fields before converting.

Using the workbook: open it, widen columns, apply number and date formats, and add filters or pivot tables as needed. Check long numbers and identifiers, which spreadsheets may display in scientific notation unless the cells are formatted as text. Keep the JSON as the source of truth if the data comes from an application, and regenerate the workbook when it changes.

Tips for better results

  • The JSON must be an array, for example [{"name":"Ada","age":36}]. If your data is wrapped in an object such as {"items":[...]}, copy just the array.
  • Every item has to be an object or an array. A list of plain numbers or strings is rejected with a message, because there would be no column names.
  • If the file will not convert, check it with a JSON validator or editor first to find the missing comma or quote. Our SmartDevTools JSON editor highlights the exact error.
  • Going the other way, Excel to JSON turns a sheet back into a JSON array, and JSON to CSV gives a plain text table.
  • Use a consistent set of keys in every object.
  • Flatten nested data before converting.
  • Check numbers and dates after opening.