JSON to Excel

Paste or upload any JSON — an array of records, a single object, or a columnar object of arrays. It gets flattened into a table you can preview, then exported as an .xlsx file.

1. Input

Frequently Asked Questions

What JSON structures are supported?

The tool supports arrays of objects, columnar objects (object with arrays of same length), single records, wrapped arrays, and primitives. Nested objects are automatically flattened using dot notation.

What are the two array expansion modes?

"As columns" expands each array-of-objects into indexed dot-notation columns within a single row (e.g. icons.0.src, icons.1.src). "As rows" creates a separate row for each array item, repeating parent fields and cross-joining multiple array-of-objects fields.

Is my data sent to any server?

No. All processing happens locally in your browser. Your JSON data is never uploaded or transmitted anywhere.

Can I exclude certain columns from the download?

Yes. After parsing, you can toggle individual columns on or off using the chip selectors. You can also select all or deselect all at once.

How do nested JSON objects get converted?

Nested objects are flattened using dot notation. For example, { "contact": { "email": "a@b.com" } } becomes the column "contact.email".

Is there a row limit?

There is no hard row limit. The preview shows the first 100 rows, but the full data set is included in the downloaded Excel file.