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.

Developer Tools 100% in your browser
Click to choose a fileor drag & drop it here — or paste the JSON below

Nested objects/arrays become JSON strings in their cell; missing keys become empty cells; column order = first-seen order.

How to use

  1. Paste the JSON array or upload a .json file.
  2. Press Convert — the column set is the union of every object's keys.
  3. 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

FAQ

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.