About the Excel to JSON Converter
This tool reads an Excel .xlsx workbook in your browser and converts a sheet, or every sheet, into JSON. You pick a sheet or export the whole workbook. The first row becomes object keys, or you can output rows as arrays. Numbers and TRUE/FALSE become JSON values. Dates are written as YYYY-MM-DD. Formulas are exported as their saved values and empty cells become null. The conversion runs locally in the browser, so files are never uploaded and results download straight to your device. Old .xls files must be saved as .xlsx first. Developers, analysts and reporters use this for quick exports, simple API fixtures, or dataset sharing without sending files to servers. The tool follows common JSON and date formats for compatibility with RFC 8259 and ISO 8601 style dates.
How to use it
- 1Upload an Excel .xlsx file from your device.
- 2Pick a single sheet or choose to convert every sheet.
- 3Choose JSON shape: objects using the first row as keys, or a list of rows.
- 4Convert and copy the JSON or download the .json file to your device.
Worked example
Input sheet 'Customers' with headers id,name,dob,active,total and two rows: Row 2: 1, Alice, 1988-05-12, TRUE, 123.45 Row 3: 2, Bob, FALSE, 0 Output JSON: [ {"id":1,"name":"Alice","dob":"1988-05-12","active":true,"total":123.45}, {"id":2,"name":"Bob","dob":null,"active":false,"total":0} ]
How it works
Reads an Excel .xlsx file and turns a sheet, or every sheet, into JSON: a list of objects using the first row as keys, or a list of rowsNumbers and TRUE/FALSE can become JSON values, dates are written as YYYY-MM-DD, formulas as their saved values and empty cells as nullCopy or download a .json fileOld .xls files must be saved as .xlsx firstRuns in the browser: files are never uploadedResults download straight to the deviceSource: JSON specification (RFC 8259)Office Open XML (ECMA-376)Microsoft support: Date systems in Excel. Last checked 5 November 2026.
What it is good for
- Runs entirely in your browser; no files are uploaded.
- Preserves common types: numbers, booleans and dates as YYYY-MM-DD.
- Copy the JSON or download a .json file straight to your device.
- Does not read legacy .xls files; save them as .xlsx first.
- Very large workbooks may be slow or memory heavy in the browser.
Questions people ask
Are my files uploaded to a server?
No. The conversion runs in your browser only. Files are not uploaded and the output downloads directly to your device.
How are dates written in the JSON output?
Dates are written as YYYY-MM-DD strings. The tool does not output Excel serial numbers for dates.
Will formulas be converted to formulas or values?
Formulas are exported as their saved (calculated) values. If you need the formula text, export it from Excel first.
How does the tool handle empty cells and booleans?
Empty cells become null in JSON. TRUE and FALSE cells become JSON true and false values.
Can I convert every sheet in a workbook at once?
Yes. You can choose a single sheet or convert every sheet. Each converted sheet is output as its own JSON structure.
What file types are supported?
The tool accepts .xlsx workbooks. Old .xls files need to be saved as .xlsx in Excel before conversion.
Help keep every tool free
FreeToolr stays free because people help it grow. Share a tool you like, tell us what to build next, or support us on Ko-fi.