Skip to content

Free Excel to JSON Converter

Drop an Excel or CSV file and get JSON, right here in your browser. Your file is never uploaded.

Drop your spreadsheet here or click to choose a file ·
.xlsx .xls .xlsb .ods .csv .tsv .txt · max 5 MB

Converts in your browser. Your file never leaves your device.

Converting…

How to convert Excel to JSON

1
Drop your fileExcel (.xlsx, .xls, .xlsb), OpenDocument (.ods) or CSV/TSV, up to 5 MB. It is read right in your browser.
2
Get JSON instantlyPick a sheet and a layout: objects with your headers as keys, rows as arrays, or headers + rows.
3
Tweak, copy or downloadThe output is editable. Copy the JSON to your clipboard or save it as a .json file. Done.

JSON in the shape your code wants

The same two spreadsheet rows, three ways. Switch layouts with one click after converting - whichever your API, script or import expects.

Objects - headers as keys
[
  { "Product": "Widget", "Units": 42 },
  { "Product": "Gadget", "Units": 7 }
]
The default. What REST APIs, config files and most scripts expect.
Rows as arrays
[
  ["Product", "Units"],
  ["Widget", 42],
  ["Gadget", 7]
]
Positional data, headers included. Compact, order preserved.
Headers + rows
{
  "headers": ["Product", "Units"],
  "data": [["Widget", 42], ["Gadget", 7]]
}
Keys once, data as arrays. Chart libraries and wide tables like it.

Need more structure? Headers like customer.name and tags[0] become real nested JSON objects and arrays in Sheet2JSON for Windows - along with NDJSON (one object per line), an A1 cell map, per-column types and camelCase / snake_case keys. Click the locked chips in the tool above for a preview on your own data.

Convert XLSX, XLS, XLSB, ODS and CSV to JSON

Every common spreadsheet format is read directly in your browser - no Excel installation needed.

XLSX to JSONThe modern Excel workbook format. Multi-sheet files work: pick the sheet you need from the dropdown, and formula cells contribute their last calculated value.
XLS to JSONLegacy Excel 97–2003 workbooks convert the same way - no need to resave them in a newer Excel first.
XLSB to JSONExcel's binary workbook format, common for very large files, is read directly.
ODS to JSONOpenDocument spreadsheets from LibreOffice and OpenOffice convert without either program installed.
CSV and TSV to JSONComma- and tab-separated text files become JSON objects with the first row as keys - handy when an export lands as .csv instead of a workbook.
XLSM - in the desktop appMacro-enabled workbooks (plus pasting cells straight from any spreadsheet, Google Sheets included) are handled by Sheet2JSON for Windows.

This page vs. Sheet2JSON for Windows

This free tool handles the quick one-off file. The desktop app is the same idea grown up: private at any scale, and with real JSON shaping.

Sheet2JSON for Windows: select a range and choose your output format. It also combines worksheets and exports JSON-LD, with no fixed cell cutoff.

FeatureFree browser toolSheet2JSON for Windows
PrivacyRuns in your browserNothing is uploadedRuns on your PCNothing is uploaded
File sizeUp to 5 MBNo fixed limitDepends on available memory
RowsFirst 2,000 rowsEvery rowNo row or cell cap
WorksheetsOne sheet at a timeSeveral sheets in one fileOr export any selected range
Export formatsJSONObjects, rows as arrays, headers + rowsAll browser formats, plusNested JSONNDJSONJSON-LDA1 cell mapCSVTSV
Types & keysDetected automaticallySet per columnText, number, boolean or date; camelCase or snake_case keys
Usage10 conversions a dayFree, no sign-up10 free conversionsThen unlimited with a license

Frequently asked questions

This free browser tool exports regular JSON from one selected worksheet at a time. The JSON-LD chip shows a two-row preview using an example context. For JSON-LD or several worksheet tabs in one file, use Sheet2JSON for Windows. Supply your receiving service's context for JSON-LD. Combining sheets preserves their data; it does not infer relationships or guarantee that an AI service reads every record. See the combined export and JSON-LD guide.
The 5 MB limit applies to the input file in this free browser tool, which also limits conversion to approximately 2,000 data rows per sheet. The Windows app has no fixed file-size, row or cell limit; available memory determines practical capacity. Your AI service may impose separate upload limits.
Drop your .xlsx, .xls or .csv file into the converter at the top of this page (or click it to browse). The file is read in your browser, the sheet you pick becomes JSON with your first row as the keys, and you copy it to the clipboard or download it as a .json file. No sign-up, no software, no upload.
No. This converter runs entirely in your browser using a JavaScript spreadsheet reader; the file is opened on your device and never transmitted. You can even load this page, disconnect from the internet, and the conversion still works.
Yes - that is the point of this page. No Power Query, no VBA macro, no Python script: drop the file, pick a layout, copy the JSON. When exporting to JSON becomes a regular part of your workflow, the desktop app does the same job with more control and no browser tab.
Yes. CSV and TSV files convert exactly like Excel workbooks: the first row becomes the keys and each following line becomes a JSON object. Semicolon-separated files (common in Europe) work in the desktop app, which sniffs the delimiter automatically.
Excel workbooks (.xlsx, .xls, .xlsb), OpenDocument spreadsheets (.ods) and delimited text (.csv, .tsv, .txt), up to 5 MB, any sheet you pick. The output is JSON as objects (first row as keys), rows as arrays, or headers + rows - and you can edit it before copying. The desktop app additionally reads .xlsm, pastes cells from any spreadsheet, selects ranges in a grid, produces nested JSON, NDJSON, JSON-LD and an A1 cell map, and combines worksheets into one file.
Not on this page: the free tool emits flat objects. Nested mode is the desktop app's speciality: headers like customer.name and tags[0] become nested objects and arrays. Sheet2JSON for Windows includes 10 free conversions to try it.
Excel itself stores 007 as the number 7 unless the cell is formatted as text, so any converter sees a 7. In the desktop app, set the ID column to Text to preserve zeros that are stored as text. This cannot restore zeros that Excel has already discarded.
This page is meant for the quick one-off file; 10 conversions a day covers that comfortably. If you convert regularly, the desktop app is the better home for the job anyway: drag, select, copy, with no browser tab involved.

Converting spreadsheets more than once a week?

Sheet2JSON for Windows: JSON-LD, combined worksheets, nested JSON and NDJSON. No fixed cell cutoff. Fully private, with 10 free conversions included.

Get Sheet2JSON for Windows

Desktop apps, Excel add-ins, and free tools for everyday work.

Stay Updated

Get new tool updates and exclusive deals.