Free tools that run in your browser. Use any tool without an account.

Favourites Cart
Sign in
Join free

Excel to JSON Converter

  • Free
  • Runs in your browser
  • No account needed

It converts an Excel .xlsx file in your browser to JSON. Pick one sheet or all sheets. The first row becomes keys for objects, or export rows as arrays. For example, two rows output a JSON array.

Choose an Excel file (.xlsx)Pick a sheet and the JSON shapeYour files stay on this device. Nothing is uploaded.
Runs in your browser. Your files and values are not sent to us. Report a problem
Advertisement

About the Excel to JSON Converter

This tool reads an Excel .xlsx workbook in your browser and converts a sheet, or every sheet, into JSON. You pick a sheet or export the whole workbook. The first row becomes object keys, or you can output rows as arrays. Numbers and TRUE/FALSE become JSON values. Dates are written as YYYY-MM-DD. Formulas are exported as their saved values and empty cells become null. The conversion runs locally in the browser, so files are never uploaded and results download straight to your device. Old .xls files must be saved as .xlsx first. Developers, analysts and reporters use this for quick exports, simple API fixtures, or dataset sharing without sending files to servers. The tool follows common JSON and date formats for compatibility with RFC 8259 and ISO 8601 style dates.

How to use it

  1. 1Upload an Excel .xlsx file from your device.
  2. 2Pick a single sheet or choose to convert every sheet.
  3. 3Choose JSON shape: objects using the first row as keys, or a list of rows.
  4. 4Convert and copy the JSON or download the .json file to your device.
Advertisement

Worked example

Input sheet 'Customers' with headers id,name,dob,active,total and two rows: Row 2: 1, Alice, 1988-05-12, TRUE, 123.45 Row 3: 2, Bob, FALSE, 0 Output JSON: [ {"id":1,"name":"Alice","dob":"1988-05-12","active":true,"total":123.45}, {"id":2,"name":"Bob","dob":null,"active":false,"total":0} ]

How it works

Reads an Excel .xlsx file and turns a sheet, or every sheet, into JSON: a list of objects using the first row as keys, or a list of rowsNumbers and TRUE/FALSE can become JSON values, dates are written as YYYY-MM-DD, formulas as their saved values and empty cells as nullCopy or download a .json fileOld .xls files must be saved as .xlsx firstRuns in the browser: files are never uploadedResults download straight to the device

Source: JSON specification (RFC 8259)Office Open XML (ECMA-376)Microsoft support: Date systems in Excel. Last checked 5 November 2026.

What it is good for

  • Runs entirely in your browser; no files are uploaded.
  • Preserves common types: numbers, booleans and dates as YYYY-MM-DD.
  • Copy the JSON or download a .json file straight to your device.
  • Does not read legacy .xls files; save them as .xlsx first.
  • Very large workbooks may be slow or memory heavy in the browser.
Advertisement

Questions people ask

Are my files uploaded to a server?

No. The conversion runs in your browser only. Files are not uploaded and the output downloads directly to your device.

How are dates written in the JSON output?

Dates are written as YYYY-MM-DD strings. The tool does not output Excel serial numbers for dates.

Will formulas be converted to formulas or values?

Formulas are exported as their saved (calculated) values. If you need the formula text, export it from Excel first.

How does the tool handle empty cells and booleans?

Empty cells become null in JSON. TRUE and FALSE cells become JSON true and false values.

Can I convert every sheet in a workbook at once?

Yes. You can choose a single sheet or convert every sheet. Each converted sheet is output as its own JSON structure.

What file types are supported?

The tool accepts .xlsx workbooks. Old .xls files need to be saved as .xlsx in Excel before conversion.

Help keep every tool free

FreeToolr stays free because people help it grow. Share a tool you like, tell us what to build next, or support us on Ko-fi.

Advertisement
Advertisement