Excel to JSON Converter
Drop a workbook and get the chosen sheet as a JSON array of objects, with dates as ISO text.
Processed locally in your browser/ Your data stays in your browser.
What is Excel to JSON Converter?
Spreadsheets are a common source for configuration, translations, price lists and test data, but applications want JSON. This tool reads the workbook locally, takes the first row as property names and turns every following row into an object with typed values: numbers stay numbers, TRUE/FALSE become booleans and empty cells become null.
Date cells are converted to ISO 8601 text so the result does not depend on any locale (or you can keep the displayed text or the Excel serial number). Empty or duplicate headers are renamed, blank rows can be skipped, and property names such as __proto__ are handled safely. Multi-sheet workbooks show a sheet picker.
How does it work?
- Drop an Excel, ODS or CSV file (up to 50 MB).
- Choose the sheet from the selector if the workbook has several.
- Keep "First row is a header" for objects, or untick it for an array of arrays; set dates, empty cells and blank-row handling.
- Copy the JSON or download it as a .json file named after the workbook.
Common use cases
- Turning a translation spreadsheet into JSON locale files.
- Loading a price list from Excel into a web app or API mock.
- Building test fixtures maintained by non-developers in a spreadsheet.
- Feeding a chart or table component from a workbook export.
Examples
Drop a workbook and get the chosen sheet as a JSON array of objects, with dates as ISO text.
Privacy
Excel to JSON Converter runs entirely in your browser. The text or files you provide are processed on your device and are not uploaded, logged or stored on our servers.
Limitations
Formulas are exported as their last calculated values. Only one sheet is converted at a time, and merged cells appear only in their top-left cell.
Frequently asked questions
How are dates represented?
As ISO 8601 text by default: 2024-01-15 for dates and 2024-01-15T13:45:00 for date-times, without any time-zone shift. You can also choose the displayed text or the raw Excel serial number.
What happens to empty cells?
By default they become null. You can omit the key entirely or use an empty string instead.
Can I get arrays instead of objects?
Yes. Untick "First row is a header" to get an array of arrays that includes the first row.
Related tools
JSON to CSV Converter
Paste a JSON array and get a CSV file ready for Excel or Google Sheets, with nested data flattened into columns.
JSON & Data
Excel to CSV Converter
Drop a spreadsheet, choose a sheet and get a clean CSV, with the delimiter and quoting you need.
JSON & Data
CSV to JSON Converter
Turn CSV rows into clean JSON in one step, with typed values, custom delimiters and pretty or minified output.
JSON & Data
Excel Viewer
Look inside a spreadsheet without Excel: switch sheets, read the first rows and check the size of each sheet.
JSON & Data
JSON Formatter & Beautifier
Turn a minified or messy JSON document into readable, consistently indented text, with a precise error message if the JSON is invalid.
JSON & Data
Excel Sheet Extractor
Split a workbook: pick a sheet and download it as its own .xlsx file, or export all sheets at once.
JSON & Data
CSV to Excel Converter
Paste CSV and download a proper Excel workbook where numbers are numbers and dates are dates.
JSON & Data