JSON to Excel

Flatten any JSON payload into a readable spreadsheet.

Paste an API response or upload a .json file and get a worksheet with one row per record. Nested objects are flattened into dotted columns and arrays are either expanded into rows or joined into a single cell — your choice.

Price
Free
Your files
Never uploaded
Runs
In your browser

or drag it here

.json, .jsonl, .ndjson · up to 50 MB · processed locally, never uploaded

Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.

Files stay on your device

What it does well

  • Handles JSON, JSON Lines and NDJSON in the same drop zone
  • Deep flattening with configurable depth and separator
  • Union of all keys across records, so sparse fields still get a column

How to use JSON to Excel

  1. 1

    Paste your JSON into the editor or upload a file.

  2. 2

    Point at the array to convert if your payload wraps it in a data or results key.

  3. 3

    Decide how nested objects and arrays should be flattened.

  4. 4

    Download the generated .xlsx.

Watch a walkthrough

How to use JSON to Excel

2 min 18 s · captions included

Watch on YouTube

Common problems and fixes

Unexpected token error when pasting.

The payload is JavaScript rather than strict JSON — usually trailing commas or unquoted keys. Enable “Lenient parse” to accept both.

Only one row is produced from a large file.

The file is JSON Lines but was parsed as a single JSON document. Choose the JSONL mode in the source dropdown.

Frequently asked questions

More convert tools

Move data between XLSX, CSV, JSON, XML, HTML and PDF without losing formatting, encoding or number precision. Every conversion runs locally in your browser.

Browse Convert