EXCEL → JSON

Excel to JSON

Excel to JSON turns worksheet rows into objects using the first row as keys, or into arrays when headers are turned off. Export one sheet or a sheet-name object for the whole workbook.

Drop a file or paste below
Conversion options

Ready

Header rows and JSON objects

With headers enabled, each remaining row becomes an object. Empty header cells receive column_1-style names, and repeated names receive suffixes. Without headers, every row stays an array, including the first. Missing cells become null in object output. Column names are literal strings, so a period in a header does not automatically create nested objects.

All-sheet output and cell types

Selecting all sheets produces an object whose keys are sheet names and whose values are row arrays. Typed mode keeps stored numbers and booleans and represents date cells as ISO strings. Formatted mode exports displayed cell strings instead, which is useful for formatted account codes or dates. A JSON date is a string because JSON has no date type.

Workbook values and pasted tables

Workbook input preserves the saved cell types. Pasted tab-separated text contains text values rather than the original workbook cell metadata. Formula results must already be saved in the workbook; this tool does not calculate formulas. Review key names and null cells in the editable output before importing the JSON into another system.

Format references

Spreadsheet utilities · JSON format

File content is read and converted in the browser. Conversion does not upload the source to a server.

Frequently asked questions

Can I export every sheet?

Yes. Select All sheets to receive an object keyed by sheet name.

How are dates represented?

Date cells become ISO strings in typed mode, or displayed text in formatted mode.