RividTech

Excel to JSON

Pick a sheet from an Excel workbook and export it as a JSON array of objects.

Drop an Excel file or click to browse

or paste data below

First row of each sheet is treated as headers

Need the reverse conversion? JSON to Excel

How Excel to JSON works

How a sheet becomes JSON

Pick a sheet from the workbook. The first row of its used area supplies the keys, and every following row becomes one object, in sheet order. Blank header cells become Column1, Column2, and so on, so no value is dropped. Rows where every cell is blank are skipped.

Header text is used exactly as written, apart from trimming spaces. A header like Unit Price ($) becomes that key, which you then access with bracket notation in JavaScript. If you want simple keys such as unit_price, rename the header cells in Excel first, or export to CSV and rename columns with Column Tools.

Give every header a unique name. If two columns share a header, the later column overwrites the earlier one in each object.

Value types in the output

Every value in the JSON is a string. Numbers come from the stored cell value, so a cell displayed as 1,200.00 becomes "1200", and a percentage displayed as 15% becomes "0.15". Empty cells become "". Formulas give the result saved in the file, not the formula itself.

Dates come out as Excel serial numbers, for example "46037" for 15 January 2026, because that is how the workbook stores them. In JavaScript, new Date(Date.UTC(1899, 11, 30) + serial * 86400000) converts a serial number back to a date. Alternatively, format the dates as text in Excel before converting.

Files and limits

Only .xlsx is read; save .xls files in the newer format first. Workbooks up to 25 MB are accepted. The first 50 sheets are read, with up to 100,000 rows and 500 columns each, and a warning appears if anything is left out. The JSON is pretty-printed with two-space indentation.

How to use Excel to JSON

  1. 1

    Drop an .xlsx workbook or click to choose one.

  2. 2

    Select the sheet to export.

  3. 3

    Check the keys in the first object and any warnings.

  4. 4

    Copy the JSON or download it under the workbook's name.

When to use it

Content kept in spreadsheets

Teams often maintain translations, pricing, or FAQ text in a sheet. Export it as JSON for a website or app build.

Test data

Let QA keep test cases in Excel and turn them into JSON fixtures for automated tests.

Excel to JSON questions

Can I get numbers instead of strings?

The output keeps every value as a string. Convert the fields you need with Number() or parseFloat() after loading the JSON.

Can I export the whole workbook as one JSON file?

No. Export one sheet at a time and combine them in your code if you need a single object keyed by sheet.

Why are some keys Column3 or Column7?

Those columns had an empty header cell. Fill in the header in Excel to get a meaningful key.

Questions about privacy, file size, or accounts are answered on the FAQ page.

Other tools in the same category, starting with the reverse conversion

Search all tools
XLSXCSV

Excel to CSV

Export any sheet of an .xlsx workbook as CSV, read from the stored cell values

JSONXLSX

JSON to Excel

Turn a JSON array of objects into a single-sheet .xlsx workbook

JSONSQL

JSON to SQL

Generate CREATE TABLE and INSERT statements from a JSON array of objects

JSONTable

JSON Preview

View a JSON array of objects as a table, with one column per key