Do I need Excel installed?

No. DataTray writes the .xlsx directly and never opens Excel to do it.

How is nested JSON handled?

Nested keys are flattened into dotted column names and arrays are expanded, with a preview of the resulting columns before you commit.

Is there a size limit?

No. Because nothing is uploaded there is nothing to cap — the limit is your disk.

Free converter

JSONExcel

JSON to Excel Converter

Straight from an API response to a workbook, with no CSV step in between and no online paste box. Nested objects become columns, arrays are expanded, and the result is a real .xlsx.

Windows 10/11 (x64) · Free · No account

Drop in your files — The workbook lands in DataTray's output folder; the JSON is left exactly as it was.

Why convert

Skipping the CSV in the middle

The usual route is JSON to CSV, then CSV opened in Excel — and that second step is where types get re-guessed and long identifiers turn into scientific notation. Writing the workbook directly means the types you set are the types you get.

Handing an API export to someone who works in Excel.
Getting nested configuration or event data into a readable grid.
Converting a large JSON file no online tool will accept.
Producing a workbook with a sheet per record type.

How it works

Convert JSON to Excel in a few clicks

1
Open the JSON
Arrays, nested objects, NDJSON and JSONL are all handled.
2
Review the flattened shape
See the columns the nesting produced and drop the ones you do not need before conversion.
3
Write the workbook
One .xlsx out, with explicit column types so nothing is mangled.

The details

JSON to Excel, at a glance

Input: JSON, NDJSON, JSONL
Output: .xlsx workbook
Nesting: Dotted column names; arrays expanded
Excel needed?: No — DataTray writes the file itself

Questions