JSON to Excel

Convert JSON to an Excel workbook

Most JSON that people receive is really a table: an export from a web service, a log, a list of customers or orders. JSON to Excel turns it into an .xlsx workbook that opens in Excel, Google Sheets or Numbers, with real numbers, dates and booleans rather than text that has to be converted by hand.

Paste the JSON or drop a .json file. A list of objects becomes one sheet with a header row taken from the keys and one row per object. Nested objects are flattened into dotted columns such as address.city, and arrays into numbered columns, one per item, so nothing inside a record is lost. An object whose values are lists of records becomes a workbook with one sheet per key, named after it. Other shapes, such as a single object or a list of values, are laid out as a two-column table so the file always opens with something useful in it. Columns are widened to fit their content and the header row is bold and frozen.

Numbers longer than fifteen digits, such as some identifiers, are written as text so Excel does not round them. The output pairs with Excel to JSON, which rebuilds the nested objects from the dotted headers. For a plain text export use JSON to CSV, and for a printable version use JSON to PDF.