Excel to JSON Converter

Convert Excel spreadsheets (XLSX, XLS) to JSON arrays.

Click to upload or drag and drop

.xlsx .xls .xlsm .ods

No file at hand?

How to convert Excel to JSON online

1
Upload an .xlsx, .xls, .xlsm or .ods file by clicking the upload box or dragging the file onto it.
2
The first row of each sheet is used as the JSON keys, and every following row becomes one object.
3
If the workbook has several sheets, pick a sheet from the list to preview its JSON.
4
Click "Copy" or "Download". With several sheets, "Download all (ZIP)" saves one JSON file per sheet.

Example: an Excel sheet as JSON

Excel sheet

| id | name        | city    | salary |
|----|-------------|---------|--------|
| 1  | Emma Wilson | Seattle | 98000  |
| 2  | Liam Chen   | Austin  | 72000  |

JSON output

[
  {
    "id": 1,
    "name": "Emma Wilson",
    "city": "Seattle",
    "salary": 98000
  },
  {
    "id": 2,
    "name": "Liam Chen",
    "city": "Austin",
    "salary": 72000
  }
]

Tips for converting Excel to JSON

Numbers stay numbers

Cells that hold numbers in Excel are written as JSON numbers, and text cells as strings, so the output is ready for APIs and code.

Dates as ISO strings

Excel dates become ISO 8601 strings such as 2021-03-15, which every programming language can parse.

Empty cells

Empty cells are kept as empty strings, so every object has the same keys.

Clean header row

Short, unique headers without spaces, such as hire_date, give you JSON keys that are easy to use in code.

Excel to JSON FAQ

Is the Excel to JSON converter free?

Yes. It is free, with no sign-up and no file limit.

Is my spreadsheet uploaded to a server?

No. The workbook is read in your browser, so your data never leaves your computer.

What happens with multiple sheets?

Each sheet that contains data becomes its own JSON file. You can preview them one by one or download them all as a ZIP.

Are formulas converted?

The JSON contains the calculated values that Excel saved in the file, not the formulas.

Which Excel formats are supported?

.xlsx, .xls, .xlsm and OpenDocument .ods files.

All CSV Tools

CSV to JSON

Convert your CSV files to JSON format with ease.

JSON to CSV

Convert your JSON files to CSV format easily.

CSV to Excel

Convert CSV files to Excel format easily

Excel to CSV

Convert Excel spreadsheets to CSV format.

Excel to JSON

Convert Excel spreadsheets (XLSX, XLS) to JSON arrays.

JSON to Excel

Convert JSON data to an Excel (XLSX) spreadsheet.

CSV Splitter

Split a large CSV file into smaller files by row count.

Merge CSV

Combine multiple CSV files into one, matching columns by header.

XML to CSV

Convert XML files to CSV format efficiently.

CSV to XML

Convert CSV files to XML format efficiently.

CSV to YAML

Convert CSV rows to a YAML list.

YAML to CSV

Convert a YAML list to a CSV table.

CSV to Markdown

Convert CSV files to Markdown tables.

Markdown to CSV

Convert Markdown tables to CSV files.

CSV to HTML

Convert CSV files to HTML tables.

HTML Table to CSV

Extract tables from HTML and save them as CSV.

CSV to PDF

Convert CSV files to PDF documents.

CSV to SQL

Convert CSV files to SQL insert statements.

CSV to vCard

Convert CSV files to vCard format for contacts.

CSV to TSV

Convert comma-separated CSV to tab-separated TSV.

TSV to CSV

Convert your TSV files to CSV format easily.

TSV to Excel

Convert your TSV files to Excel format easily.