Excel to JSON

Turn an Excel sheet or CSV into a JSON array of records, numbers kept as numbers.

Processed in your browser — files never leave your device

Drop a file here

or

Select file

About Excel to JSON

Turn a spreadsheet into JSON: each row becomes a record keyed by the column headings, or a plain array if you prefer. Numbers, true/false and dates are written as real JSON values, while PIN codes, roll numbers and long IDs stay text so no leading zero or digit is lost. Works with .xlsx and .csv files, in your browser.

How Excel to JSON works

Excel to JSON reads your .xlsx or .csv file in your browser — the same reader used by the site's other spreadsheet tools — and writes each row as a record. With headings, a row becomes an object whose keys are the column headings; as arrays, a row becomes a list of values with the headings as the first list.

With Numbers as numbers, cells that are numbers, dates or true/false become real JSON values: 91, "2024-05-01", true. Text that only looks like a number but starts with 0 (a PIN code or roll number) or has more than 15 digits stays text, so nothing is lost. Empty cells become null.

When to use Excel to JSON

  • Turn a product or price list into JSON for a website or an app.
  • Load spreadsheet data into a script, a database or an API test.
  • Convert exported CSV data into JSON for a JavaScript chart.

How to use Excel to JSON

  1. Add your file. Drop an Excel (.xlsx) or CSV file into the box above.
  2. Choose the shape. Objects with field names, or arrays; numbers typed or all text.
  3. Download. Save the .json file.

Options explained

First row is the headings
The headings become the field names. Untick it to name fields Column A, Column B…
Object or Array
{"Name": "Asha"} per row, or ["Asha", 91].
All sheets
Every sheet of a workbook, as {"Sheet1": […], "Sheet2": […]}.
Easy to read
Indented JSON; untick for the smallest file.

Frequently asked questions

What happens to empty cells?

With Numbers as numbers they become null; with All as text they become empty strings.

Can I convert every sheet of a workbook?

Yes. Tick All sheets and you get one object with a list of records for each sheet.

Are formulas converted?

Their results are: the value Excel last calculated and saved in the file.

Is there a size limit?

The conversion runs in your browser, so very large files depend on your device. A file too large is refused with a message; split it first with Split Excel & CSV.

Are my files safe with Excel to JSON?

Yes. Excel to JSON runs entirely in your web browser, so your files never leave your device and are never uploaded to us.

Is there a file size limit?

Files up to 30 MB are accepted. Because the work happens on your device, very large files depend on your device's memory.

Guides