rumfamtools
← All tools

Excel to JSON

Open an XLSX and select a sheet. The first row becomes field names and the following rows become JSON objects.

Settings

Up to 50,000 rows, 256 columns and 500,000 cells per sheet.

What the result looks like

The result is an array of flat objects with string values. Displayed cell values are used, including leading-zero formatting. Formula cells use the values saved in the workbook.

The first row must contain nonempty, unique headers followed by at least one data row. Duplicate headers cause an error.

Excel to CSV