JSON to Excel

Each object in the array becomes a row, and each key found in any object becomes a column, in the order it first appears. Row 1 holds the key names. Records that are missing a key get an empty cell, and null is also written as empty.

A cell can only hold a single value, so nested objects and arrays are written as their JSON text. For a spreadsheet where nested fields such as customer.email get their own columns, run the data through Flatten JSON first, then convert the CSV it produces with CSV to Excel.

Every value is written as a text cell. String IDs like "00142" keep their leading zeros, and long numeric strings are not rounded into scientific notation. JSON numbers are stored as text too, so Excel flags them with a green triangle; select the column and use Convert to Number before running formulas on it.

Booleans appear as true and false. Dates in JSON are already strings (usually ISO 8601, such as 2026-01-15) and are kept as text. Excel's DATEVALUE function can convert them if you need real dates.

The workbook has one sheet, Sheet1, with up to 100,000 rows and 500 columns. The input must be one valid JSON document: an array of objects or a single object. An array of plain values such as [1, 2, 3] has no column names and is rejected.