JSON to XLSX Converter

Choose JSON that is either rows or a sheets array. The download is an XLSX.

Use this tool

Drop a file here, or use the picker. The file type is checked from its contents.

Result

The result appears in this panel after you run the tool.

About this tool

The sheets array is the same shape XLSX to JSON writes.

How to use it

  1. Choose a JSON file. An array of rows makes Sheet1.
  2. Or use an object with sheets, each with a name and rows.
  3. Download the XLSX. Sheet names are trimmed to 31 characters.

Limitations

Rows or a sheets array become worksheets

Two accepted shapes

A top-level array is one sheet named Sheet1. Each element of that array must itself be an array. Those inner arrays are rows. Values are turned into strings. Null and missing values become empty strings. Objects inside a row are stringified with the default string conversion, which is rarely what you want, so pass arrays of plain values. The other shape is an object whose sheets property is an array of objects. Each object needs rows, and may include name. A blank name becomes Sheet1, Sheet2, and so on. This is the shape XLSX to JSON writes, so that page’s download can come back through here.

Names and safety

Sheet names lose the characters a workbook forbids, including colon, slash, question mark, asterisk, and brackets. Names are cut at 31 characters. Duplicate names after that cut can make a file some spreadsheet programs dislike. Keep names distinct and short if you will edit them later. The cells are inline strings, same as the CSV workbook writer. An equals sign is text, not a formula. That avoids treating untrusted JSON as a program.

What you do not get

There is no column type, no date serial, and no shared-string table. The file is larger than a shared-string workbook would be when the same word repeats, and it is simpler to read back. Styles, charts, and pivot caches are not in the vocabulary of this writer. A JSON file that is a single object of column names will fail the shape check. Put the rows in arrays, or export CSV and use the CSV page. Numbers files are not JSON this tool is claiming to open. Bring a real JSON document.

Privacy

Your input is processed in your browser and is not uploaded to UtilChain. File names, text, and results are not sent to analytics.