Excel to JSON
Spreadsheet rows to JSON objects, first row as keys — on your device.
About this tool
Drop an .xlsx, pick the sheet and the shape (array of objects, or raw rows), copy or download the JSON. The workbook is read entirely on your device.
From rows to records
The standard shape programs want is an array of objects, one per row, keyed by the header row — which is what you get by default: numbers become JSON numbers, TRUE/FALSE become booleans, date cells become ISO strings, formulas contribute their calculated value, blank rows are skipped, and empty header cells get names like column3 so nothing is lost. Raw rows (an array of arrays) is there for data without headers. The everyday uses: turning a spreadsheet of products, translations, test cases or config into a file an app can import, mocking an API from a colleague's sheet, or moving data into a database via its JSON import. Honest scope: cell formatting and merged cells have no JSON meaning and are dropped; the old .xls format isn't supported. And the reason to do it here rather than on a converter site: spreadsheets are where the real data is. Validate or reshape the result with the JSON formatter, compare two exports with JSON diff, get TypeScript types from it with JSON to TypeScript, and What JSON is, and where it trips people up explains the format if it's new.
Frequently asked questions
How are the keys chosen?
From the first row of the sheet. Blank header cells become column1, column2… so every value has a key.
Are numbers typed as numbers?
Yes by default (with leading-zero values kept as strings to protect IDs); untick the option to keep everything as strings. TRUE/FALSE become booleans.
Can I export a specific sheet?
Yes — every sheet is listed with its row count; pick one.
Is the spreadsheet uploaded?
No — it's parsed in your browser and the JSON is built locally.