JSON to Excel

JSON To Excel Converter

Paste or upload JSON, auto-extract array lists, and download CSV or XLSX — all in your browser. Your data never leaves your device.

Size: 0.0 KB · 0 chars
Paste, upload, or load an example to see a table here.

How it works

1. Paste or upload JSON

Paste a JSON response, select a .json file, or drag a file in. Everything is processed locally in your browser.

2. Auto-extract arrays and flatten fields

The tool recursively finds every array and turns each into a table. Nested objects are flattened into dot-path columns, e.g. customer.contact.email becomes a column header.

3. Download CSV or XLSX

Download the current table or every table at once. Field names keep their original JSON keys.

Supported structures

Top-level arrays, objects with arrays at any path (data.list, data.raw.listv2), and object fragments missing outer braces (auto-repaired).

Nested arrays

Array fields inside a row are written to a cell as a JSON string — they are never expanded into new tables or columns.

FAQ

Is my data uploaded anywhere?

No. All parsing, preview, and export happen locally in your browser. Your JSON is never sent to a server.

What is the file size limit?

5 MB per input. Larger inputs are rejected before parsing — split your JSON or reduce the data size.

Do you support JSON5 (single quotes, comments, trailing commas)?

No. Only standard JSON is supported. Non-standard input is reported as invalid with correction guidance.

Are nested objects flattened?

Yes. Nested objects are flattened into dot-path columns such as userInfo.contact.email.

Are nested arrays expanded into new tables?

No. Arrays inside a row are written to a single cell as a JSON string and are not expanded.

Can I convert multiple arrays at once?

Yes. Every array found under object paths becomes its own tab; you can download them all into one XLSX.

Why does it say no list was found?

Your JSON contains no arrays. Only arrays can be turned into tables — plain objects are not shown as a single row.

What is the difference between CSV and XLSX?

CSV is a single-table text file. XLSX is a spreadsheet workbook; multiple tables can be exported as separate sheets in one file.