Excel to JSON Converter

Convert Excel spreadsheets (.xlsx, .xls, .ods, .csv) to JSON in your browser: pick a sheet or all sheets, use the header row as keys, dates as ISO. Free.

Choose a spreadsheet file.xlsx, .xls, .ods or .csv — read locally in your browser

JSON output

Runs entirely in your browser. Your data is never uploaded.

Related Tools

View All

Color Converter Number Base Converter Text to Binary Binary to Text NATO Phonetic Alphabet Converter JSON to TypeScript JSON to Go Struct JSON to Python

What is Excel to JSON?

Open an Excel or OpenDocument spreadsheet and get its rows as JSON. Choose one sheet or all sheets; with a header row each row becomes an object, otherwise an array of cell values. The file is read locally and never uploaded.

How to use Excel to JSON

Click Choose a spreadsheet file and select an .xlsx, .xls, .ods or .csv file.
Pick the Sheet (or All sheets).
Keep First row is a header on to get objects, or turn it off for arrays.
Copy or Download the JSON.

Example

Input

Sheet "Users": id | name | joined | active → 1 | Ada | 2024-01-15 | TRUE

Output

[{"id": 1, "name": "Ada", "joined": "2024-01-15T00:00:00.000Z", "active": true}, …]

When to use Excel to JSON

Use it to turn spreadsheets into JSON for APIs, fixtures or scripts without installing anything. It reads values, not formatting: merged cells, colors, comments and formulas are not exported.

How Excel to JSON works

The file is read with SheetJS (xlsx) inside your browser. Cell values keep their types: numbers stay numbers, booleans stay booleans, empty cells become null and date cells are converted to ISO 8601 strings in UTC. With a header row, SheetJS uses the first row as keys (duplicate headers get suffixes); "All sheets" produces an object keyed by sheet name. Formulas are not recalculated – the cached result stored in the file is used.