Excel → JSON

Paste cells or CSV
Loading editor…
JSON Output
Loading editor…

Excel to JSON Converter

Turn a spreadsheet into JSON in seconds. Upload an .xlsx or .csv file — or just copy a range of cells in Excel or Google Sheets and paste it. The first row becomes the object keys, and numbers, TRUE/FALSE and dates come out as real JSON types. Pick one sheet or convert the whole workbook at once.

Paste from Excel
Copy cells, paste, done — no file needed.
XLSX & CSV upload
Choose a sheet, or convert all sheets at once.
Real types
Numbers, booleans and ISO dates, not just strings.
Client-side
Your spreadsheet never leaves your browser.

How to Convert Excel to JSON

  1. Paste or upload. Select cells in Excel or Google Sheets, copy them (Ctrl/Cmd+C), and paste into the input panel. Or click Upload (or drag a file onto the panel) to open an .xlsx or .csv file.
  2. Choose a sheet. Workbooks with several sheets show tabs; pick one, or choose All sheets to get a single object keyed by sheet name.
  3. Header row. With First row is header on, each row becomes an object using the first row's values as keys. Turn it off to get each row as an array.
  4. Copy or download the JSON.

Example — these cells:

Order IDCustomerQuantityPaidOrder Date
1001Alice Johnson2TRUE2024-05-01
1002Bob Smith1FALSE2024-05-02

become:

[
  {
    "Order ID": 1001,
    "Customer": "Alice Johnson",
    "Quantity": 2,
    "Paid": true,
    "Order Date": "2024-05-01"
  },
  {
    "Order ID": 1002,
    "Customer": "Bob Smith",
    "Quantity": 1,
    "Paid": false,
    "Order Date": "2024-05-02"
  }
]

How Cell Values Are Converted

  • Numbers stay numbers, and TRUE/FALSE become JSON booleans.
  • Dates become ISO 8601 strings — 2024-05-01 for dates, 2024-05-01T14:30:00Z when there's a time.
  • Formulas output their calculated result, not the formula text.
  • Rich text and hyperlinks output their plain text; error cells output the error, like #DIV/0!.
  • Empty cells become null, and fully empty rows are skipped.
  • Leading zeros are preserved: a pasted zip code like 02134 stays the string "02134" instead of turning into 2134.

Blank header cells are named after their column (Column C), and duplicate headers get a suffix (Name_2) so no data is overwritten.

Paste from Excel or Google Sheets

You don't need to save a file first. When you copy a range of cells, the spreadsheet puts it on the clipboard as tab-separated text — paste it here and it's converted immediately. This works the same for Excel, Google Sheets, LibreOffice Calc and Numbers.

Pasted text is also remembered in your browser, so it's still there if you refresh. Need the reverse? Use JSON to Excel. Working with plain CSV text? See CSV to JSON.

Frequently Asked Questions

How do I convert an Excel file to JSON?

Click Upload (or drag the .xlsx file onto the input panel), pick the sheet you want, and the JSON appears on the right. Copy it or download it as a .json file. Nothing is uploaded to a server — the file is read in your browser.

Can I convert Excel to JSON without uploading a file?

Yes. Select the cells in Excel or Google Sheets, copy them, and paste into the input panel. Copied cells arrive as tab-separated text, which is converted straight to JSON.

Does it support multiple sheets?

Yes. Each sheet in the workbook appears as a tab. Convert one sheet at a time, or choose "All sheets" to get one JSON object with a key per sheet name.

Does it work with .xls files?

The old .xls format (Excel 97–2003) isn't supported. Open the file in Excel and use File → Save As → Excel Workbook (.xlsx) or CSV, then upload that. You can also simply copy the cells and paste them.

How are dates and numbers handled?

Numbers stay numeric and TRUE/FALSE become booleans. Date cells become ISO 8601 strings (2024-05-01, or with a time when present). Formulas output their calculated value.

Is my spreadsheet uploaded anywhere?

No. The workbook is read and converted entirely in your browser. Nothing is sent to a server.