Excel to JSON Converter

Choose a spreadsheet or paste CSV. Preview the JSON, then copy or download it. Your file stays on your device.

Use calculatorQuestions & answers

Up to 10 MB. Up to 10,000 data rows and 200 columns per sheet. Legacy .xls files must be saved as .xlsx first.

Or paste CSV text

Download the sample workbook to test a file from your device. It contains made-up inventory and an empty second sheet.

Select a file or try the sample to begin.

Convert an Excel sheet without uploading it

Choose a local .xlsx workbook and select its worksheet. If the first row contains column names, leave the header option checked to produce an array of objects. Otherwise, turn it off to keep rows as arrays. Check the preview before copying or downloading.

CSV to JSON example

A CSV containing Code,Quantity followed by 0012,3 becomes [{"Code":"0012","Quantity":"3"}]. CSV cells stay strings, so the leading zeros in an identifier are not silently removed.

Check the result before importing it elsewhere

Only cell values are converted. Styling, charts, merged-cell layouts and Excel display formats are not preserved. Dates are represented as ISO strings, empty cells as null, and duplicate headers are renamed visibly. Formula cells use their saved values; this tool does not calculate formulas.

For files using legacy formats or passwords, open them in your spreadsheet application and save an unprotected .xlsx or UTF-8 CSV copy first. Keep identifiers as text in the source workbook when their leading zeros matter. Large or unusually complex workbooks may exceed your browser's memory.

Frequently Asked Questions

Are my spreadsheet files uploaded?
No. This converter reads the selected file in your browser. The file contents, file name and JSON output are not sent to our servers or analytics. Copying or downloading the result happens only when you choose it.
Which Excel formats are supported?
Use .xlsx files or UTF-8 .csv files up to 10 MB. Legacy .xls, password-protected workbooks and macro-enabled .xlsm files are not supported. Save those as .xlsx or UTF-8 CSV in your spreadsheet application first. Each selected sheet may contain up to 10,000 data rows and 200 columns.
How are headers, empty cells and duplicate names handled?
With First row contains column names selected, each data row becomes an object. Blank headers become Column 1, Column 2 and so on. Duplicate names receive numbered suffixes so no column is overwritten. Empty cells become null; fully empty rows are skipped. Turn off headers to get an array of arrays.
Are numbers, dates and leading zeros preserved?
CSV values remain strings, preserving identifiers such as 0012. XLSX cells retain their stored numeric, text or boolean type; dates become ISO strings. Excel number formatting, including zeros displayed only by a number format, is not preserved. Formulas are not recalculated; only saved values are read.

Related Calculators & Tools