Runs locally in your browser
Excel to JSON Converter
Extract JSON records from an XLSX worksheet. Select the sheet and header row, then export cell values, dates, and saved formula results locally.
Working with a .csv or .tsv file? Convert CSV to JSON.
How to convert Excel to JSON
- Choose or drop your .xlsx workbook.
- Select the worksheet and the row containing column names.
- Review, copy, or download the JSON array.
A sheet with name and active headers and a row containing Alice and TRUE produces [{"name":"Alice","active":true}]. Each non-empty data row becomes one object.
Extract records from a workbook with several sheets
An operations workbook might contain Summary, Orders, and Products sheets. Select Orders to export only its rows. If a report title occupies the first row, choose the actual header row before copying the JSON.
For a sheet whose headers are order_id, total, and paid, a text ID, numeric total, and boolean payment flag produce:
[
{"order_id":"ORD-1042","total":149.5,"paid":true},
{"order_id":"ORD-1043","total":62,"paid":false}
]Only the selected worksheet is exported. The output uses stored cell values: a custom display format such as 00000 does not turn the underlying number 124 into the string 00124.
Understand dates, formulas, and workbook layout
- Excel date cells become ISO 8601 strings. Text that looks like a date stays text.
- Formula cells return saved results. A formula without a saved result becomes null; this converter does not calculate formulas.
- Blank cells become null. Formatting, charts, and layout are not exported, and merged cells may repeat the master value.
For plain text with delimiters instead of workbook sheets, use CSV to JSON. To create a workbook from records, use JSON to Excel.
Frequently asked questions
Which Excel files are supported?
Import an unencrypted .xlsx workbook up to 10 MB and choose a worksheet. Legacy .xls files must first be saved as .xlsx. Each selected sheet may contain up to 10,000 data rows and 200 columns.
How are headers and empty cells handled?
The selected header row becomes the JSON keys. Empty headers receive column_1-style names, and duplicate names receive numeric suffixes to prevent overwriting. Blank cells become null and completely empty data rows are skipped.
How are dates and formulas converted?
Dates become ISO 8601 strings. Formula cells use their saved results, or null when no result is saved; formulas are not recalculated. Rich text and hyperlinks become their displayed text. Nested JSON text remains a string.
Are formatting and merged cells preserved?
JSON contains values, not spreadsheet styling or layout. Merged cells may repeat the master cell value. For predictable records, use a table with one header row and unmerged data cells.
Is my spreadsheet uploaded?
No. Your workbook is read and converted locally in your browser.