Can I export every sheet as JSON at once?

No. Convert one sheet at a time. Excel to CSV can zip every sheet as CSV.

Will a locked .xlsx open in Excel to JSON?

No. Remove protection in Excel first, then drop the unlocked file.

Does JSON to Excel flatten nested objects?

Yes. Keys such as address.city become columns. JSON to Excel has no column picker.

Can Excel to JSON read a .xls workbook?

No. Save as .xlsx in Excel first.

How large can the Excel to JSON upload be?

15MB for an uploaded .xlsx or JSON file. Pasted JSON is not capped the same way.

Excel ⇄ JSON

Loading tool…

About Excel ⇄ JSON

Excel to JSON: upload an unprotected .xlsx (no paste), pick a sheet, choose Shape (array of objects or arrays), First row is header, and Infer types. Preview 20 rows and a JSON snippet. Download JSON and Copy. One sheet per download. There is no zip of every sheet here; use Excel to CSV if you need every sheet as a file.

JSON to Excel: upload or paste JSON. Nested objects flatten as a.b.c. Download XLSX builds a real workbook with a bold frozen header on Sheet1 (the button reads Building while it works). JSON to Excel has no Copy and no column picker. Password-protected workbooks and legacy .xls are not supported on the Excel side.

How to use Excel ⇄ JSON

1Pick a tab. Excel to JSON or JSON to Excel.
2Add the workbook or the JSON. Unprotected .xlsx one way. Array of objects the other.
3Pick a sheet or check flatten. Excel to JSON: sheet, shape, header, types. JSON to Excel: nested keys become a.b.c.
4Download JSON or Download XLSX. Copy exists on Excel to JSON only.

Excel to JSON

The sheet list shows name and row count. Convert one sheet at a time. Infer types matches the CSV to JSON rules. Stats and the 20-row table sit above the JSON snippet.

JSON to Excel

Output is a typed .xlsx, not a CSV renamed. Nested keys show as Flattened in the stats. Empty JSON or a shape we cannot tabulate returns an error instead of an empty workbook.

Limits and privacy

Excel to JSON and JSON to Excel both run in your browser. The .xlsx upload is 15MB max. Pasted JSON is not size-capped. Files are not uploaded. No account.

FAQs

Can I export every sheet as JSON at once?: No. Convert one sheet at a time. Excel to CSV can zip every sheet as CSV.
Will a locked .xlsx open in Excel to JSON?: No. Remove protection in Excel first, then drop the unlocked file.
Does JSON to Excel flatten nested objects?: Yes. Keys such as address.city become columns. JSON to Excel has no column picker.
Can Excel to JSON read a .xls workbook?: No. Save as .xlsx in Excel first.
How large can the Excel to JSON upload be?: 15MB for an uploaded .xlsx or JSON file. Pasted JSON is not capped the same way.