Excel to JSON Converter
Convert an Excel .xlsx file to JSON in your browser: records keyed by the header row, one sheet or all sheets, typed numbers and ISO dates. Nothing is uploaded.
How to use Excel to JSON
- 1Open an .xlsx file (or drop it on the box).
- 2Choose one sheet or All sheets, and set the header row and type options.
- 3Copy the JSON or download it as a .json file.
What makes it better
- One sheet as an array, or every sheet as an object keyed by sheet name
- Header row becomes the keys; duplicate or empty headers are made unique
- Numbers and booleans stay typed, or switch to text for every value
- Dates are written as yyyy-mm-dd; formulas give their saved results
- Preview of the first 50 rows and a record count
About Excel to JSON
Excel to JSON reads an .xlsx workbook and writes the selected sheet as an array of objects keyed by the header row, or as arrays of arrays. Choose All sheets to get one object keyed by sheet name, and decide whether numbers and booleans stay typed or every value becomes text.
Common uses
- Load a price list or inventory sheet into a web app as JSON.
- Turn a multi-sheet configuration workbook into one JSON document.
- Seed test data from a spreadsheet that a non-developer maintains.
- Inspect what a workbook really contains, including hidden sheets.
Example
Input
Order,Date,Qty,Price,Code 1001,2024-03-01,2,19.50,007 1002,2024-03-02,10,4.00,042
Result
[
{
"Order": 1001,
"Date": "2024-03-01",
"Qty": 2,
"Price": 19.5,
"Code": "007"
},
{
"Order": 1002,
"Date": "2024-03-02",
"Qty": 10,
"Price": 4,
"Code": "042"
}
]Good to know
- Only .xlsx is supported. Legacy .xls files cannot be read; re-save them as .xlsx in Excel, LibreOffice or Google Sheets first.
- Formulas are exported as the last saved values and are never recalculated. Empty cells become null with Detect types on and empty strings with it off.
- Number formatting is ignored: a cell displayed as 19.50 is exported as 19.5. A sheet named __proto__ is handled as an ordinary key.
Excel to JSON FAQ
How do I convert Excel to JSON?
Open the .xlsx file, pick a sheet and keep First row is header on. Each following row becomes an object whose keys are the header cells, and you can copy or download the result.
Can I export all sheets at once?
Yes. Choose All sheets and the output is one object whose keys are the sheet names and whose values are the arrays of records or rows for each sheet.
Why are my values strings or numbers?
With Detect types on, Excel numbers and booleans stay JSON numbers and booleans. Turn it off when you want every value as text, for example to keep 19.5 exactly as a string.
How are dates exported?
As ISO text, yyyy-mm-dd, with the time added when the cell has one. JSON has no date type, so dates are strings that most libraries can parse.
Does it support .xls files?
No, only .xlsx. The binary .xls format from Excel 97-2003 is not readable by the library in use, so save a copy as .xlsx and open that.