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 Runs in your browser · no upload

Reviewed 17 November 2026 · Free · No account needed

ExecutionYour browserInput never leaves your tab
File retentionNoneNothing is stored
AccountNot requiredNo sign-up, no paywall
PriceFreeNo trial, no usage cap on the tool itself

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.

The input must be an array of objects. Columns are the union of every object's keys in first-seen order; each object becomes one row. Strings, numbers and booleans are written directly, nested objects and arrays are written as JSON strings in their cell, and null or missing keys stay blank.

Worked example

[{"id":1,"name":"Ada"},{"id":2,"role":"adm"}] becomes data.xlsx with columns id, name, role — role blank on the first row.

Edge cases to know

  • Top-level scalars, nested arrays or non-object elements are refused with a clear error.
  • Nested values become JSON strings in the cell rather than being flattened silently.
  • Column order follows first-seen key order, not alphabetical.

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

How is the column set decided?

Columns are the union of every object's keys, ordered by first appearance — so objects with different shapes still land in one coherent table, and a key that appears only in some objects leaves blank cells where it is missing. The page's example shows two objects merging into three columns.

What happens to nested objects and arrays?

They become JSON strings inside their cell rather than being flattened into extra columns or silently dropped — an address object arrives as its own JSON text. Scalars convert normally, and null or missing values become empty cells. Nothing is renamed: your keys are the header row verbatim.

What input shapes are refused?

The input must be an array of objects — a top-level scalar, an array of arrays, or objects mixed in with scalars are refused with a clear error naming the problem. You can paste the JSON or upload a .json file; either way the conversion runs locally with SheetJS and the data never leaves your device.