Convert

Excel to JSON Converter

Turn a worksheet into JSON for an app, API test or script. Choose the sheet and which row holds the headers, decide how empty cells and types are handled, check the JSON and download it. Everything is processed in your browser; your data is not uploaded.

Back

1. Workbook and options

Local only

Processed in your browser; your files and data are not uploaded or stored. Formulas, macros and scripts in your data are never run.

2. JSON result

Live preview

Formula cells use the value last saved in the file; formulas are not recalculated and macros never run. Styles, comments, images and charts are not converted, and merged cells keep their value only in the first cell.

Workbooks up to 30 MB; JSON output up to 30 MB.

About this tool

About Excel to JSON Converter

Excel to JSON Converter turns one sheet of an .xlsx workbook into JSON. You choose the header row and first data row, the output shape (array of objects or array of arrays), how empty cells are written and whether numbers and TRUE/FALSE are converted.

Developers and analysts often need spreadsheet data as JSON for an API, a test fixture or a script. Doing it by hand is slow and error-prone. This tool keeps the conversion explicit — every option is visible, blank and repeated headers are handled predictably, and long numbers are never rounded.

How to use

Step by step

  1. Choose an .xlsx file and the sheet to convert.
  2. Enter the header row number (or 0 for none) and the first data row number.
  3. Choose array of objects or array of arrays.
  4. Set how empty cells are written and whether to convert numbers and TRUE/FALSE.
  5. Check the JSON, then download it or copy it.
Key features

What it offers

  • Sheet selection, header row and first data row
  • Array of objects or array of arrays output
  • Empty cells as "", null or omitted keys
  • Optional number and boolean conversion without precision loss
  • Unique keys for blank or repeated headers
  • Pretty or minified JSON with copy and download
Best practices

Tips for best results

  • Keep one header row with unique, short column names.
  • Leave values as text when IDs or codes have leading zeros.
  • Remove notes or totals rows from the sheet before converting.
  • Validate the JSON in the app that will consume it.
Benefits

Why people use it

Predictable

Every conversion choice is explicit and visible.

Lossless numbers

Long numbers and leading zeros are kept as text.

Private

The workbook never leaves your browser.

FAQ

Common questions

An array of objects gives one object per row, using the header row as keys — for example {"name": "Asha", "city": "Pune"}. An array of arrays gives one array per row with values in column order, and can include the header row as the first array.
Enter the sheet row number of the header (for example 1), or 0 if there is no header. The first data row must come after the header row. Rows above the first data row are ignored.
A blank header becomes column_N (for example column_3), and a repeated header gets a suffix such as name_2, so every key in an object is unique. The page tells you when this happens.
You choose: an empty string, null, or (for objects) leaving the key out of that row. Rows where every cell is empty can be skipped.
Only if you choose "Convert numbers and TRUE/FALSE". Then plain numbers become JSON numbers and TRUE/FALSE become true/false. Values with leading zeros (such as 00123) or more than 15 digits stay as text so nothing is lost. By default every value stays as text.
Formulas give the value last saved in the file and are never calculated. Cells formatted as dates become text like 2026-11-11 (with the time when there is one).
No. It is read in your browser and the JSON is created on your device. Nothing is uploaded or stored.
Private by design

This runs entirely in your browser

No file or text you enter here is uploaded. Encoding and decoding happen on your device using native browser APIs — close the tab and nothing remains on a server.

Install Toolisco Add it to your device for offline, one-tap access.