Skip to content

Excel to JSON

Turn a sheet of an XLSX, XLS or ODS workbook into JSON. By default the first row becomes the keys and every following row becomes an object, or you can export plain arrays of rows. Export one sheet or every sheet into one JSON object keyed by sheet name.

Choose files or drag and drop them into the upload field. Maximum file size: 5 MB.

Reset

Frequently asked questions

How are the keys chosen?

In the objects format, the cells of the first row become the keys. Empty header cells become column1, column2 and so on by position, and repeated headers get a suffix such as name_2 so no value is lost.

Which value types appear in the JSON?

Numbers stay numbers, booleans become true or false, dates become ISO strings such as 2025-03-14, error cells become their error text such as #DIV/0! and empty cells become null. With displayed values turned on, every cell becomes the text Excel shows instead.

Can I convert all sheets at once?

Yes. Tick the option for all sheets and the JSON file holds one object whose keys are the sheet names and whose values are the rows of each sheet.

What does the arrays format look like?

Each row becomes an array of cell values, and the first row is kept as an ordinary row. This is useful when the sheet has no header row or when column order matters more than names.

Are formulas included?

No. Each formula cell is exported as its last calculated value, the value stored in the file when it was last saved.

What are the limits?

Files up to 10 MB with at most 25 MB of uncompressed content, up to 100 sheets, 50,000 rows per sheet and 1,000,000 cells in total.

About OneClick Pro

OneClick Pro is a free collection of more than 150 web tools for everyday work: converting images and units, formatting and validating code, checking domains and SEO, and working with text, dates and numbers. Every tool runs without registration or subscription, and what you enter is only used to calculate your result and is never stored. Use it as a quick toolbox for one-off tasks, or bookmark the tools you rely on every day.