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:
[
{ "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.
{
"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.
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.