About the Excel to JSON Converter
Spreadsheets are where data is maintained; JSON is what code consumes. This converter reads an .xlsx workbook locally, takes the sheet you choose, and turns each row into an object using the header row as keys, so a sheet with columns id, city and population becomes an array of records with those keys. Numeric cells become JSON numbers, booleans become booleans, and text stays text. Untick the header option to get an array of arrays instead.
The workbook is unzipped and parsed by JavaScript in the page; nothing is uploaded, so internal spreadsheets are safe to convert. Shared strings, inline strings and cached formula values are all read. Empty cells become empty strings so every object has every key.
Once you have the JSON, the other JSON tools apply: validate it, view it as a tree, or convert to YAML or TypeScript types. The reverse converter writes a workbook from JSON.
How to use
- Select the .xlsx file, or drag it onto the left pane.
- Choose the sheet index and whether the first row is a header.
- Copy or download the JSON.
Common questions
- Does it read all sheets?
- One sheet per conversion, chosen by index. The status shows how many sheets the file has.
- How are dates handled?
- As Excel serial numbers, since that is how the file stores them. Convert to dates in your code if needed.
- Are empty cells null or empty strings?
- Empty strings, so every record has every key.
- Is my spreadsheet uploaded?
- No. It is parsed in your browser.