Convert Excel to JSON
More data converters: JSON to Excel · JSON to CSV · CSV to JSON · XML to JSON · JSON to XML · XML to Excel · YAML to JSON · JSON Formatter
How to Convert Excel to JSON
From Excel, Google Sheets (File → Download → Microsoft Excel), Numbers or LibreOffice.
If the workbook has several sheets, choose one. Decide whether the first row holds the column names.
Copy the JSON or download it as a .json file.
What you get from each cell
Excel values in JSON
| In Excel | In the JSON |
|---|---|
| Number, currency, percentage | The number itself: 12.5, 0.25 — without the currency sign or % format |
| Date | "2026-11-20"; with a time, "2026-11-20T14:30:00" |
| TRUE / FALSE | true / false |
| Text, including numbers stored as text | A string, so "00123" keeps its zeros |
| Formula | The result Excel saved in the file, not the formula |
| Empty cell | null |
| Error such as #N/A | The error text, "#N/A" |
- Header row: the first row's cells become the keys. Empty or repeated names get
column_3or_2so nothing is lost. Switch it off to get plain arrays of rows. - Merged cells keep their value in the top-left cell only, the way Excel stores them.
- Old .xls files (Excel 97–2003) and .ods files cannot be read here. Open them in Excel or LibreOffice and save as .xlsx first.
- Password-protected workbooks are encrypted and cannot be read without being opened and saved without the password.
- Dots in headers like
address.citycan build nested objects — switch on the option.
Have a CSV instead? Use CSV to JSON. To go back, use JSON to Excel.
Frequently Asked Questions
Is my Excel file uploaded?
No. The .xlsx is opened and read by JavaScript in your browser. Spreadsheets with customer or financial data stay on your device.
Can I convert an old .xls file?
Not directly. Open it in Excel or LibreOffice, save it as .xlsx, and open that file here.
How are dates converted?
Cells formatted as dates become ISO text such as 2026-11-20, which every programming language can read. Dates with a time include it, for example 2026-11-20T14:30:00.
Are formulas converted?
The JSON contains the values that Excel last calculated and saved in the file, not the formulas themselves.