Excel to JSON
Convert Excel to JSON online for free — turn spreadsheet rows into a JSON array of objects keyed by the header row (or an array of arrays), keep numbers and true/false as real types, and export one sheet or every sheet at once. Copy or download the JSON; everything runs in your browser.
100% private — everything runs in your browser. Conversion happens on your device; nothing is uploaded.
Converted in your browser with SheetJS — your data never leaves your device. Excel formulas are exported as their calculated values; formatting such as colours and merged cells isn’t carried into CSV or JSON.
How to convert Excel to JSON
- Drop your Excel file in the box.
- Pick the sheet, or tick “All sheets”.
- Choose headers, types and pretty-printing.
- Copy or download the JSON.
What you can use it for
- Load spreadsheet data into web apps and APIs
- Create seed data and fixtures for development
- Feed product lists into static sites and CMSs
- Convert content tables for translation tools
More free tools
Building for the web?
Format, minify, convert and generate code with our free, private developer tools.
See all free tools →Frequently asked questions
What JSON format do I get?
By default, an array of objects whose keys come from the first row — for example [{"Name":"Alice","Age":30}]. Untick “First row is headers” to get an array of arrays.
Are numbers kept as numbers?
Yes, with “Keep types” ticked. Untick it to get every value as text, exactly as displayed in Excel.
Can I export all sheets?
Tick “All sheets” to get one object keyed by sheet name.
Is my data uploaded?
No. The conversion runs in your browser with the open-source SheetJS library, so spreadsheets with customer or financial data stay on your device.
What about formulas and formatting?
Formulas are exported as their calculated values. Colours, fonts and merged cells aren't part of CSV or JSON, so they aren't carried over.
Which spreadsheet formats can I open?
Click the box to browse for an XLSX, XLSM, XLSB or XLS file from Excel, an OpenDocument (ODS) spreadsheet or an Apple Numbers (.numbers) file; these are the types the file picker accepts. You can also drag a file onto the box. The workbook is read in your browser with the SheetJS library, and when it has two or more sheets, they're listed in the Sheet menu.
How are dates and true/false values exported?
With “Keep numbers and true/false as types” ticked, dates become text in year-month-day form, such as "2026-11-18", or "2026-11-18 14:30:00" when the cell also holds a time. They're built from your computer's local date and time rather than a UTC timestamp. Cells reading true or false, in any capitals, become JSON true and false. Untick the option to get dates as text, formatted as displayed in Excel.
What happens to empty cells?
Empty cells are written as null rather than left out. With “First row is headers” ticked, every object therefore gets a key for every column, so all records have the same shape and code that reads the JSON can expect the same fields each time. With headers unticked, empty cells inside each row also come out as null in the array of arrays, keeping columns in the same positions.
Which sheet gets converted?
The first sheet in the workbook, unless you choose another. When a file has two or more sheets, a Sheet menu appears above the preview, and switching it updates the preview and the JSON straight away. The download is named after your file and the sheet, such as sales-Summary.json. Tick “All sheets” to put every sheet in one file instead, named after the file alone, such as sales.json.
Is there a file size or row limit?
The tool sets no file size or row limit of its own. The preview table shows the first 50 rows and 20 columns, with a note giving the full row and column count, and the Result box shows the first 200,000 characters of the JSON. Download JSON and Copy always use the complete output, so for a large sheet, download the file rather than copying from the box.
Can I convert several Excel files at once?
Yes. Drag several files onto the box together and they're combined into one workbook, with each sheet named after the file it came from; a file with more than one sheet gets numbered names, such as sales and sales 2. A message confirms how many files were combined. Pick one in the Sheet menu, or tick “All sheets” to get one JSON object keyed by those names.
How do I turn the JSON back into Excel?
Use our JSON to Excel converter. It takes an array of objects, such as this tool's output with “First row is headers” ticked, and builds an XLSX file with one column per key. An object whose values are all arrays, like the “All sheets” output, becomes a workbook with one sheet per key, so a round trip keeps your sheet names.