DataFlow Convert

JSON to Excel

Most converters stringify nested JSON or crash. This one flattens nested objects to dot-notation columns and puts arrays of objects on separate sheets — automatically.

File
Convert to

Dot-notation flattening

Nested objects like {"user": {"city": "Berlin"}} become a column named user.city.

Multi-sheet output

When your JSON has arrays of objects (e.g. orders inside customers), each array gets its own sheet. Sheets are linked by a _row column.

Strategy picker

The UI detects nested structure automatically and lets you choose: flatten everything to one sheet, or split into relational sheets.

NDJSON support

Works with both JSON arrays and newline-delimited JSON (one object per line).

Column selector

Choose which columns appear in the output and rename them before converting.

Large files

Up to 100 MB on Pro. Anonymous uploads up to 5 MB.

Example: multi-sheet output

A JSON with customers[].orders[] produces: Sheet 1 with one row per customer, and a second sheet orders with one row per order and a _row column linking back to the parent customer.

Also see: JSON Repair · JSON Path Extract · CSV to JSON