jsonecho

Excel to JSON

Drop an Excel workbook here and get JSON, one object per row.

Loading the tool...

How to use Excel to JSON

  1. Click Upload or drag your .xlsx file onto the box.
  2. Choose whether to convert only the first sheet or all of them.
  3. Copy or download the JSON.

About Excel to JSON

Business data lives in Excel. Getting it into a web app, an API call or a script usually means exporting to CSV first and fixing the damage afterwards. This tool reads the .xlsx file directly: the first row supplies the key names, and each following row becomes an object.

Cells formatted as dates are converted to proper date strings instead of the serial numbers Excel stores internally. Booleans stay booleans and numbers stay numbers. If your workbook has several sheets, tick "All sheets" and each one comes back under its sheet name.

Frequently asked questions

Is my spreadsheet uploaded to a server?

No. The file is opened in your browser, and the conversion happens there.

Does it support the old .xls format?

No, only .xlsx and .xlsm. Open an old .xls file in Excel and save it as .xlsx first.

Are formulas converted?

You get the last calculated value that Excel stored in the file, not the formula text.

Why do some dates look like numbers?

Excel stores dates as numbers and only the cell format tells it to show a date. If a cell has a general format, we cannot know it was meant as a date. Format the column as a date in Excel and try again.

What happens to empty cells?

They become null. Rows that are completely empty are skipped.

More in Converters

All tools →