Excel to JSON

Convert Excel sheets into JSON arrays using the first row as keys. Perfect for developers and data imports.

  • Free, no sign-up
  • Files stay on your device
  • Works on mobile
Loading tool…

Excel to JSON reads an XLSX workbook directly and turns a sheet into a JSON array, using the first row as keys. You skip the step of exporting to CSV first, and you can pick which sheet to convert when a workbook has several tabs, such as Products, Prices and Suppliers.

It is popular with developers who receive data from non-technical colleagues as spreadsheets: translations, store catalogs, quiz questions or configuration tables. Because Excel cells have types, numbers and true/false values can come through as real JSON numbers and booleans rather than text, which saves cleanup in your code.

How to use Excel to JSON

  1. Choose or drop an .xlsx or .xls file into the main area.
  2. In the settings panel on the right, select the sheet and confirm the first row holds the column names.
  3. Press Convert to JSON.
  4. Copy the JSON or download it as a .json file.

Features

  • Workbooks are processed on your device and not uploaded.
  • Reads the spreadsheet directly, without exporting to CSV first.
  • Choose a specific sheet from multi-tab workbooks.
  • Numeric cells come through as numbers; empty cells may be omitted or set to empty values.
  • Merged cells, formatting and charts are ignored.

When to use it

  • Converting a translator's spreadsheet of app strings into a JSON language file.
  • Turning a marketing team's product sheet into data for a website.
  • Loading quiz questions written in Excel into a learning app.

Frequently asked questions

How is this different from CSV to JSON?

Excel to JSON reads .xlsx files directly, lets you choose a sheet, and keeps cell types like numbers. CSV to JSON works with plain text CSV, where every value starts as text.

What if my headers are not in row 1?

Delete the rows above the header in Excel, or move the header to row 1, so the correct names become keys.

How are dates converted?

Dates may come through as text or as Excel's internal date numbers depending on the cell format. Check the date fields in the result.

Does it read formulas?

It reads the stored result of each formula, not the formula text.

Can I convert every sheet at once?

One sheet is converted per run. Select each sheet in turn if your workbook has several tabs you need.