Skip to content
atifo

Browse tools

Theme

Convert JSON to Excel

Open API data and exports as a spreadsheet.

Converting to Excel

Working on your device. Nothing is uploaded.

Processed in your browser. Nothing is uploaded.

How to convert JSON to Excel

  1. 1

    Choose JSON files, or switch to “Paste JSON” and paste it.

  2. 2

    Tap “Convert to Excel”.

  3. 3

    Download the .xlsx with one row per record and filters on the header.

Read JSON like a spreadsheet

API responses, app exports, analytics downloads and database dumps often come as JSON: perfect for computers, hard for people to scan. Converting it to Excel lets you sort, filter, total and share the data with anyone who uses a spreadsheet.

Also exports JSON to CSV, turning JSON to a spreadsheet.

Upload or paste

Choose one or more .json files (each becomes a sheet), or switch to “Paste JSON” and paste data copied from a browser, an API tool or a log.

How the data is laid out

  • Each record becomes a row and each key becomes a column. Every key that appears anywhere gets a column, so records with missing fields simply get empty cells.
  • Nested objects are flattened into columns like address.city and address.pin.
  • Lists of simple values (such as tags) are joined with commas. Lists of objects are kept as JSON text in the cell.
  • Wrapped data is found automatically: if your JSON looks like {"status": "ok", "data": {"items": [...]}}, the first list inside it is used.

The header row gets filters, and column widths are set to fit the content.

When the JSON is broken

If the file isn’t valid JSON, for example because of a missing comma or quote, you’ll see roughly where the problem is so you can fix it and try again.

Private

Conversion happens in your browser, and nothing is uploaded. For the reverse, use Excel to JSON. To clean up or check the result, open it in Edit Excel.

Frequently asked questions

What JSON shapes are supported?

A list of objects (the most common), a list of lists, or an object that contains a list somewhere inside it, like {"data": {"users": [...]}}: Atifo finds the first list automatically.

How are nested objects handled?

They become columns with dotted names, like address.city. Lists of simple values are joined with commas; lists of objects are kept as JSON text.

What if my JSON has an error?

You’ll see where the problem is, such as “problem near character 1520”, so you can fix it.

Do all records need the same keys?

No. Every key that appears anywhere becomes a column, and records without it get an empty cell.

Related tools