JSON to Excel

JSON to Excel writes one worksheet named Sheet1, with one row per object and a header from the keys. A two-row sample workbook measured 16010 bytes.

Sheet1 and the header

The file text is parsed. An array is the row list. A single object is wrapped as one row. json_to_sheet builds the cells, and the sheet is appended under the name Sheet1. There is no other sheet. For name Ada qty 2 and name Bea qty 3, reading that sheet back as CSV is name,qty then Ada,2 then Bea,3. The button reads Run JSON to Excel. The download name ends in converted.xlsx. The content type is the xlsx spreadsheet type. Column order follows the key order. A second JSON file in the same request is not a second sheet.

Nested values and the CSV cousin

A nested array does not become extra columns. In the Excel path the measured tags cell for Ada was blank. The CSV path for the same shape wrote the array into one quoted cell. Use JSON to CSV when you need that cell text. Use this page when you need a workbook. Neither page expands tags into tag1 and tag2. Objects inside a field are not a second worksheet. If you need those columns, reshape the JSON before you upload. The blank cell is empty, not the word null and not the word object. The nested tags sample produced a blank cell under tags. Ada followed by a comma and an empty field is what the CSV round trip showed. Both data rows stay on Sheet1.

Parse failures

A lone opening brace throws Expected property name or '}' in JSON at position 1. An empty file throws Unexpected end of JSON input. The page does not replace those parser messages. Trailing commas and comments fail. The cap is 25 MB. The 16010 byte figure is the workbook for the two simple rows, not a promise about your file. A larger array produces a larger xlsx. Dates are whatever the sheet writer stores from the JSON values you sent. The round trip of that sample still listed only the sheet name Sheet1. The button reads Run JSON to Excel, and the stored name ends in converted.xlsx. The upload cap on this route is 25 MB. No extra tab is created.

The JSON is uploaded

The JSON is uploaded for the conversion, and the temporary file is removed after the download. Keep the JSON if you still need nesting that the blank cell dropped. Excel to CSV can turn the first sheet of a workbook back into text. The 16010 byte size is the xlsx container for two short rows, including the workbook parts Sheet1 needs, not the size of the CSV text of those same rows. A single object, not an array, still becomes one data row under the same header. The sheet name does not change to the file name. It stays Sheet1.