How to use Excel to JSON
- Click “Select Excel file” or drop an .xlsx workbook onto the box.
- Choose the sheet, or “All sheets” for one object keyed by sheet name.
- Pick the JSON shape and whether values are typed or kept as displayed text.
- Press “Convert to JSON”, then copy the result or download the .json file.
About this tool
In “array of objects” mode the first non-empty row supplies the keys – empty headers become column1, column2 … and duplicates get a numbered suffix – and every following row becomes one object. Empty rows are skipped and empty cells become null, so every object has the same keys.
Typed values keep numbers as JSON numbers, TRUE/FALSE as booleans and date cells as ISO 8601 strings (2026-03-31 or 2026-03-31T14:30:00). Choose “Text as displayed” if you want exactly what Excel shows, such as “$1,234.50” or “15%”. Formulas are exported as their calculated values.
Frequently asked questions
How are dates exported?
In typed mode as ISO 8601 strings, which every programming language can parse. In “as displayed” mode they use the cell’s Excel format.
Can I convert JSON back to Excel?
Yes, use JSON to Excel. It accepts the same shapes this tool produces.
Are my spreadsheets uploaded to a server?
No. The whole process runs inside your browser with JavaScript. Your spreadsheets never leave your device, which also means the tool keeps working if you go offline after the page has loaded.
Is this tool really free?
Yes. There is no sign-up, no daily limit, no watermark and no paid tier. The site is supported by advertising shown on the page, not by charging for the tools.