Excel to JSON

Convert Excel worksheets to JSON records, rows or columns

Spreadsheets are the most common way data is handed over, and JSON is what most programs and web services expect. Excel to JSON converts an .xlsx or .xlsm workbook into JSON with the values typed the way the cells are: numbers stay numbers, dates become ISO 8601 strings, empty cells become null and text stays text.

Upload the workbook and choose a shape. Records is the usual choice: the first row of each sheet becomes the keys and every following row becomes an object, which is the format APIs, databases and charting tools read directly. Rows gives arrays of arrays including the header, useful when the columns have no clean names. Columns gives one array per header, handy for plotting. A workbook with one sheet returns that sheet's data; a workbook with several sheets returns an object with one entry per sheet name.

Formulas are exported as their last calculated value. Headers written as paths, such as address.city or a numbered item of a list, are rebuilt into nested objects, which is exactly what JSON to Excel writes, so the two tools round-trip a file without losing its structure. Merged cells keep their value in the first cell. For a comma-separated file use CSV to JSON instead, and for Markdown tables use Excel to Markdown.