XLSX to JSON Converter
Turn a spreadsheet into JSON records.
File
Result
Your converted file will appear here.
About the XLSX to JSON converter
Getting spreadsheet data into code usually means an export-to-CSV step and then a parser. This goes straight from .xlsx to a JSON array, with the header row supplying the keys.
The whole thing runs in your browser, which is worth caring about given what spreadsheets normally contain.
How rows become records
The first row of the chosen sheet supplies the property names, and every row after it becomes an object. Blank header cells are filled in as `column_1`, `column_2` and so on rather than being dropped.
Gaps are preserved: a cell left empty in the middle of a row stays an empty value rather than shifting the columns after it.
Types
With type detection on, numbers become numbers and TRUE/FALSE become booleans. Turn it off when values must survive exactly as written — product codes with leading zeros are the usual reason.
Date-formatted cells become ISO date strings, since Excel would otherwise hand you a serial number.
Frequently asked questions
What happens to formulas?
You get the last calculated value that Excel stored, not the formula. A workbook that has never been opened and recalculated may have stale values.
Are merged cells handled?
The value appears in the top-left cell of the merge and the rest are empty, which is exactly how the file stores it.
Is my data uploaded?
No. The conversion runs in your browser, which matters here — configuration files and spreadsheets routinely contain credentials and personal data.