Excel to JSON Converter
Turn spreadsheet rows into JSON objects, keeping numbers, booleans and dates.
Drop Excel files (.xlsx) here
or select to choose from your device
Files are processed on this device. Nothing is uploaded.
How to use Excel to JSON Converter
- Add an .xlsx workbook.
- Choose objects (using the header row as keys) or plain arrays, and which sheets to include.
- Select Convert to JSON, then download or copy the result.
How it works
With Array of objects, the first row supplies the keys and every following row becomes one object. Empty header cells are named column_N, and repeated headers get a suffix (name, name_2) so no column is lost. Completely empty rows are skipped.
Types come from the workbook, not from guessing: numeric cells become JSON numbers, TRUE/FALSE cells become booleans, text stays text (so a text cell 00123 keeps its zeros), empty cells become empty strings, and date cells become "YYYY-MM-DD" or "YYYY-MM-DD HH:MM:SS" strings. Formula cells give their last calculated value.
Files are read and written by your browser on your device. Nothing is uploaded, so there is no size limit set by us and no copy of your data anywhere else.
Example
Rows id | name | active → [{"id": 1, "name": "Ada", "active": true}, …].
Frequently asked questions
How are dates converted?
As ISO text, for example "2026-03-15". JSON has no date type, and this form sorts correctly and is read by every language.
Can I get all sheets in one JSON file?
Yes. Choose "All sheets" and the result is an object with one key per sheet name.
What happens to merged cells?
The value is in the top-left cell of the merged area; the other cells are empty, as stored in the file.
Does it support .xls or CSV?
For CSV use CSV to JSON. Old .xls files must be saved as .xlsx first.
Limitations
- .xlsx and .xlsm only; no .xls and no password-protected files.
- Nested JSON is not produced: one object per row.
- Formatting and formulas themselves are not exported.
Last reviewed November 9, 2026. How we build and test tools.