Excel to JSON
Convert a spreadsheet sheet into JSON.
Turn a sheet into an array of objects, using the header row as the keys. Useful for getting a spreadsheet someone sent you into a form your code can read.
How to use it
- Add the .xlsx file.
- Choose the sheet and confirm the header row.
- Copy the JSON or save it as a file.
Why use this tool
Completely private
Everything runs inside your browser. Your files and text are never sent to a server.
Free, with no limits
No sign-up, no watermarks and no cap on how many times you can use it.
Instant results
There is no upload or queue to wait for, so results appear as fast as your device can work.
Works on any device
Runs in any modern browser on phone, tablet or desktop. Nothing to install.
Frequently asked questions
- Which sheet is used?
- The first one, unless you pick another from the list. Only the selected sheet is converted.
- Are numbers converted to numbers?
- Yes by default, except for values with leading zeros, which stay text so that postcodes and account numbers survive. Turn the option off to keep everything as strings.
- How are merged cells handled?
- The value appears in the first cell of the merged range and the rest are empty, which is how the file itself stores it.
- What about empty rows?
- Completely empty rows are skipped rather than becoming objects with no values in them.