Skip to content
ToolPlankDEV
JSON Tools
100% In-Browser Execution

Updated:

Excel to JSON Converter Online

Convert Excel to JSON in your browser. Drop an .xlsx, CSV or TSV file, or paste cells copied from Excel, then pick a format and copy or download clean JSON. Your spreadsheet is never uploaded.

Processing in browser...

Loading the tool. It runs entirely in your browser, so your data is never uploaded.

More free tools you may need next.

Quick Guide

How to use Excel to JSON

Simple step-by-step instructions to get the exact output you need.

  1. 01

    Add your spreadsheet

    Drop an .xlsx, .csv or .tsv file on the Excel / CSV file tab, or open the Paste cells tab and paste cells you copied from Excel. The Sample button fills in a small example so you can see the result first.

  2. 02

    Choose the JSON shape

    Pick Array of objects, 2D array or Keyed object. If your workbook has several sheets, choose the sheet. Leave First row is header on when row 1 holds column names.

  3. 03

    Decide how empty cells and values behave

    Set empty cells to null, an empty string or left out. Keep Detect numbers, booleans & dates on to get real JSON numbers and true/false values, or switch it off to keep every value as text.

  4. 04

    Copy or download the JSON

    The JSON updates as you change an option. Press Copy JSON to put it on your clipboard or Download .json to save a file. The badge above the result shows the row and column count. The preview shows the start of large results, while Copy and Download always contain everything. The swap button between the panels sends the JSON to JSON to Excel.

How Excel to JSON Conversion Works

A spreadsheet is a grid and JSON is a tree, so converting one into the other means choosing how rows and columns map onto objects and arrays. This excel to json converter reads your file inside the browser tab, finds the data range on the sheet you pick and builds the JSON from it. No server is involved, so a customer list or payroll export never leaves your device.

The default output is an array of objects. The first row becomes the keys and every other row becomes one object:

JSON
[
  { "id": 1, "name": "Ada Lovelace", "active": true, "salary": 5200.5 },
  { "id": 2, "name": "Grace Hopper", "active": false, "salary": 6100 }
]
  • Array of objects: best for APIs, front-end code and databases. Blank or repeated headers are renamed to column_3 or name_2 so no data is overwritten.
  • 2D array: every row, including the header row, as a plain list. It is the most compact form and keeps column order exactly.
  • Keyed object: the first column becomes the key of each entry, which gives fast lookups by id or code.

Real-World Use Cases

  • API payloads: turn a price list or product sheet from a colleague into the JSON body an endpoint expects.
  • Database migration: convert an Excel export into a JSON file you can import into MongoDB, Firebase or a seed script.
  • Data analytics: feed spreadsheet data into a JavaScript chart or a notebook without writing a parser.
  • QA fixtures: keep test cases in a spreadsheet that non-developers can edit, then export them as JSON fixtures.
  • Static sites and apps: ship translations, menus or store locations as a JSON file maintained in Excel.

If you need to go the other way, JSON to Excel flattens JSON back into a spreadsheet. To tidy the text in a column before converting, use the Excel Case Converter. If the JSON has to travel inside another JSON string, see JSON Escape and JSON Unescape.

Data Type Mapping and Formatting Guide

Excel stores typed values, while CSV and pasted text are only characters. With Detect numbers, booleans & dates switched on, the tool maps values like this:

  • Numbers: a cell such as 5200.50 becomes the JSON number 5200.5. Text that looks like a number is converted too, except values with leading zeros (007) or more than 15 digits, which stay text so no digit is lost.
  • Booleans: TRUE and FALSE cells, and the words true and false in pasted text, become JSON true and false.
  • Dates: real Excel date cells become ISO 8601 text, such as 2024-03-15, or 2024-03-15T09:30:00.000Z when a time is present. JSON has no date type, so dates are always strings. Dates in CSV text are kept exactly as written.
  • Formulas: the last calculated value is exported, not the formula itself. If a file was never calculated in Excel, the value can be empty.
  • Hyperlinks and rich text: the visible text is exported.
  • Errors such as #N/A: exported as that text.
  • Merged cells: the value sits in the top-left cell and the other cells are treated as empty.

Empty cells follow your choice. null keeps the key with a null value, an empty string keeps it as an empty string and Leave out drops the key from that object. In the 2D array format a position cannot be dropped, so Leave out writes null instead.

JSON
{
  "1": { "name": "Ada Lovelace", "email": "ada@example.com" },
  "2": { "name": "Grace Hopper", "email": null }
}

The example above is the Keyed object format with the id column as the key.

Online Converter vs Power Query vs Python and JavaScript

There is more than one way to export an Excel sheet as JSON. The right one depends on whether you do it once or every day.

  • This online converter: quick for one-off jobs. No install, no code, and you can see the JSON before you save it. It converts in the background of your browser tab, so the page stays responsive, but very large files are limited by your device memory.
  • Excel Power Query: Excel can load data and write it back out, but it has no built-in one-click JSON export. You normally need a custom M script or a VBA macro, so it suits people who already automate in Excel.
  • Python with pandas: the best choice for repeat jobs and very large files. It can also clean and join data on the way.
  • JavaScript: a library such as ExcelJS or SheetJS inside a Node script fits when the conversion is part of your build or app.
Python
import pandas as pd

df = pd.read_excel("people.xlsx", sheet_name="Sheet1")
df.to_json("people.json", orient="records", indent=2, force_ascii=False)

The pandas version needs Python, pandas and openpyxl installed. It writes the same array of objects that this tool produces with the default settings, although number and date handling can differ in small ways.

Privacy and Limits

Files are read with your browser's own file API and converted with JavaScript on your device. You can confirm in your browser's Network tab that no request carries your data. The Privacy Policy describes what the site does collect.

  • Excel files up to 60 MB, CSV and TSV files up to 200 MB, and pasted text up to 5,000,000 characters.
  • Up to 20,000,000 cells in one sheet. Excel sheets have at most 1,048,576 rows and 16,384 columns. CSV and TSV files can have up to 5,000,000 rows and 100,000 columns.
  • Password-protected or damaged workbooks cannot be opened. Only the selected sheet is converted at a time, so choose another sheet to convert the next one.
  • Images, charts, pivot tables, comments and formatting are not part of JSON and are ignored.

Frequently Asked Questions

Technical Q&A for Excel to JSON

Common questions about edge cases, character encoding, and privacy guarantees.

Drop your .xlsx or .csv file here, or paste cells copied from Excel, then pick the JSON shape. This converter for Excel to JSON turns the sheet into an array of objects in your browser, and you can copy or download it. No macro, script or Excel add-in is needed.

Excel files up to 60 MB and CSV or TSV files up to 200 MB, with up to 20,000,000 cells in a sheet. A CSV can have up to 100,000 columns, and an Excel sheet has at most 16,384 because that is Excel's own limit. The work runs in the background of your tab, so the page stays usable, and the preview shows only the start of a large result. Copy and Download always give you the complete JSON.

Yes. Press the swap button between the two panels to open JSON to Excel with your result already loaded, then download an .xlsx, CSV or TSV file.

Keep Detect numbers, booleans & dates switched on. Numeric cells become JSON numbers, TRUE and FALSE become true and false, and date cells become ISO 8601 text because JSON has no date type. Values with leading zeros, like 007, and numbers longer than 15 digits stay text so no digits are lost. Switch the option off if you want every value kept as text.

Drop your .xlsx file, leave Output format on Array of objects and keep First row is header on. Each row becomes one object and the header cells become the keys. The old .xls format is not read directly: open it in Excel, choose File > Save As > Excel Workbook (.xlsx), then drop that file.

Excel has no Save As JSON option. Drop the workbook into this tool, check the result and press Download .json. You can also select the cells in Excel, copy them, open the Paste cells tab, paste and download from there.

In Python, pandas.read_excel followed by to_json(orient="records") does the job and is best for automation or very large files, but needs Python, pandas and openpyxl installed. An online converter needs no setup and shows the result immediately, which is better for a one-off file. This tool runs in your browser, so the file is not uploaded.

Yes. When a workbook has more than one sheet that contains data, a Sheet menu appears and you convert one sheet at a time. Empty cells can be written as null, as an empty string or left out of the object, and fully empty rows are skipped. Switch off Skip empty rows if you want them kept.

The conversion runs in your browser, and the file is not uploaded to our servers. You can check this in your browser's Network tab while converting. Close the tab and the data is gone from memory.

JSON cannot store a date, so real Excel dates are written as ISO 8601 strings such as 2024-03-15. If a date column shows as a plain number, the cell was formatted as a number in Excel, not as a date.