About the Excel to JSON Converter
Developers often get data as an Excel workbook but need it as JSON for an app, a test or an API. Drop an .xlsx, .ods or CSV file here, pick the sheet, and the converter shows the JSON straight away. By default the first row is used as the key names and each row becomes an object, which is the form most APIs expect. You can switch to an array of arrays, and choose whether numbers and true/false cells become real JSON types or stay as text. Empty rows are skipped and empty cells become null. The file is read in your browser, so your spreadsheet is never uploaded anywhere.
Updated October 2026
How to use the Excel to JSON Converter
- 1Drop your Excel, ODS or CSV file or press Select files.
- 2Choose the sheet if the workbook has several.
- 3Decide whether the first row holds the column names.
- 4Decide whether to turn numbers and booleans into real types.
- 5Copy the JSON or download it as a .json file.
Choosing the output shape
A list of objects, such as [{"name":"Ann","age":31}], is easiest to use in code because each value is labelled by its column. It needs a header row. An array of arrays, such as [["Ann",31]], is more compact and keeps the order, which suits charts and imports that already know the columns.
With type conversion on, cells that look like whole numbers or decimals become numbers and true or false become booleans. Cells such as postcodes with leading zeros stay text so no zeros are lost.
Large workbooks work too, though the preview box shows only the start so the page stays fast. The full result is still copied and downloaded. If the file has several sheets, choose each in turn, and the download name includes the sheet name so you can keep the files apart without renaming them yourself.
Preparing the sheet
- Put the headers in the first row, with one short name per column.
- Remove summary rows, notes and merged cells above or below the table.
- Keep one value per cell, without line breaks in the middle if you can.
- Format date columns as text in the style you want.
- Delete hidden columns you do not need.
Related tools
The reverse job is done by the JSON to Excel Converter. To make a CSV instead, use Excel to CSV, and for a database script try the CSV to SQL Converter. The JSON Formatter tidies the output and the JSON Validator checks that it is correct before you send it on.
Features
- Reads .xlsx, .xlsm, .ods and CSV
- Pick any sheet
- List of objects or array of rows
- Optional type conversion
- Duplicate column names made unique
- Empty rows skipped, empty cells become null
- Private, nothing is uploaded
Frequently asked questions
How do I convert Excel to JSON?
Drop the workbook on this page, choose the sheet and copy or download the JSON. No software or macros are needed.
Which Excel formats are supported?
Modern .xlsx and .xlsm files, OpenDocument .ods and CSV or TSV. Old .xls files must be saved as .xlsx first.
What happens to formulas?
You get the calculated result of each formula, not the formula text.
How are dates handled?
They are written as text the way the sheet shows them. If you need ISO dates, format the column that way in Excel first.
What if two columns have the same name?
The second gets a number added, such as name_2, so no data is overwritten.
Can I convert all sheets at once?
Choose one sheet at a time. Each has its own JSON file that you can download.
Is my file uploaded?
No. It is read and converted inside your browser.