Home › Spreadsheets & Data › Excel to JSON
{}

Excel to JSON

Convert an Excel sheet to JSON.

✓ Free✓ No watermark
Advertisement
  1. 1Upload
  2. 2Settings
  3. 3Download

How to use Excel to JSON

Add your file (or type your content) using the box above.
Adjust the options if you want something different from the defaults.
Click the button, then download your result.

About Excel to JSON

Developers, analysts and no-code builders often need spreadsheet rows as JSON so they can feed them to an app, a website or an API. This free tool reads an .xlsx workbook in your browser and produces a formatted JSON file, without any script or upload.

By default the first row is used as the field names and each following row becomes an object. Blank headings are named column1, column2 and so on. Switch the option off and you get an array of arrays instead. A single sheet gives a JSON array; choosing all gives an object with one array per sheet, named after the sheets. Dates are written as ISO text and formulas as their calculated values.

How it works: the first row of the chosen sheet becomes field names and each later row becomes a JSON object, giving you an array ready for code, APIs and configuration.

Step by step: 1) add the .xlsx file; 2) select the sheet; 3) convert; 4) copy or download the JSON and look at a few records.

Realistic limits: unique, non-empty headers produce the best keys. Formulas are exported as values, merged cells and formatting are ignored, and dates may become serial numbers or text depending on cell type, so verify them. Empty cells may become empty values. Very large sheets rely on browser memory.

Typical uses: building mock data for a front end, loading a product list into an application, or migrating a table into a JSON database.

Preparing the sheet: use short, unique headings in row one, ideally without spaces or special characters, since they become JSON keys. Remove merged cells, empty rows and summary lines. Make sure numbers are real numbers and dates are consistent, as these affect how values appear in the output.

Using the result: JSON can be loaded directly in JavaScript, Python and most data tools. Validate it with a parser before use and spot-check against the sheet. If your application needs a nested structure, convert first and reshape in code. For large workbooks, test with a small extract so mistakes are caught early.

Tips for better results

  • Put the column names in the first row and keep them unique. Duplicate names would overwrite each other inside an object.
  • Remove empty rows and notes above the table before converting, or they will become records.
  • Use the sheet box with a name or a number to pick one sheet, or all for the whole workbook.
  • To go the other direction, use JSON to Excel; for text tables, Excel to CSV.
  • Use one clean header row and no merged cells.
  • Check how dates come out before importing.
  • Remove blank rows beforehand.