JSON to Excel
Convert an array of JSON objects into an .xlsx worksheet: columns are the union of all keys, nested values are stringified, missing keys stay blank.
Nested objects/arrays become JSON strings in their cell; missing keys become empty cells; column order = first-seen order.
How to use
- Paste the JSON array or upload a .json file.
- Press Convert — the column set is the union of every object's keys.
- Download the generated .xlsx.
Example
Input: [{"id":1,"name":"Ada"},{"id":2,"role":"adm"}]
Output: data.xlsx — columns id, name, role (blanks where missing)
How it works
The JSON array is written as an .xlsx workbook with SheetJS: object keys become column headers and each object becomes a row.
Limits & compatibility
- Input must be an array of objects — top-level scalars or nested arrays are refused with a clear error.
- Nested objects/arrays become JSON strings in their cell rather than being flattened silently.
- Column order follows first-seen key order.
Privacy
Converted with SheetJS inside your browser. The JSON never leaves your device.
Related tools
Questions about JSON to Excel
Is my input private?
Yes. This tool runs entirely in your browser — your input never leaves your device, is never uploaded to a server and is never stored.
How accurate is the result, and what are the limits?
The tool page states its formula and limits openly. Check them before relying on a result, and verify anything consequential — financial, legal, medical or safety-critical — against an authoritative source.
What happens to files I open with this tool?
Files are processed locally in your browser and never uploaded; closing the tab discards them. Text tools never store what you paste — it lives only in the page while you use it.