Convert Excel
to JSON.

Why convert XLSX to JSON?

• Feed code, not spreadsheets. JSON is native to every language — one line to parse in JavaScript, Python, Go, or Ruby, no Excel library needed.
• Records, ready to use. A header row plus data rows becomes an array of objects — exactly the shape an API or a config loader expects.
• Real types. Numbers stay numbers and blanks become null, so you can compute on the data instead of parsing strings.

How the mapping works

• First sheet only. The active (first) sheet is converted; other tabs are ignored.
• Row 1 = keys. Each header cell becomes a JSON key; an empty header becomes column_1, column_2, and so on.
• One object per row. Every row below the header becomes an object in the output array.
• Native types. Numbers, booleans (TRUE/FALSE), and null for blanks come through as real JSON; dates are ISO 8601 strings.
• Formulas → cached value. A formula exports as its last value saved by Excel (see the FAQ if cells come out null).

How it works

1. Use the converter. No registration is required.
2. Upload your XLSX file. Drag and drop your spreadsheet, or browse from your device.
3. Convert to JSON. Select JSON as the target format and click Convert.
4. Download the JSON file. Save the records array, ready to feed an API, script, or config.

Good for

• Seeding a database or API from a spreadsheet.
• Turning a data export into a test fixture or config file.
• Handing tabular data to a front-end that speaks JSON, not XLSX.

FAQ

Which sheet gets converted? The first (active) sheet only. JSON has no concept of multiple tabs, so if you need a different sheet, move it to the first position in Excel and re-upload. Multi-sheet output is on the roadmap.

How are the JSON keys chosen? The first row is treated as the header, and each cell in it becomes a key. The output is an array of objects — one object per data row. An empty header cell becomes column_1, column_2, and so on; duplicate headers keep the last value.

How are numbers, dates, and blank cells represented? Native JSON types: numbers stay numbers, TRUE/FALSE become booleans, and a blank cell becomes null — not the string "null". Dates are written as ISO 8601 strings (for example 2026-07-17) so any language can parse them.

What happens to my formulas? Formulas are exported as their last cached result — the value Excel saved into the file the last time it was open. If the workbook was generated by a script and never opened in Excel, formula cells may come out as null; open it in Excel once, save, then re-upload.

Is it free? Yes. No signup, no watermark, no payment. Free for personal and commercial use, up to five files per upload at 20 MB each.

Related

• CSV → JSON → the same, from a plain CSV
• XLSX → CSV → flat rows instead of records
• JSON → CSV → go the other way
• JSON → YAML → turn the result into config
• All supported formats →