About Excel to JSON
Spreadsheets are where a lot of data starts: product catalogs, staff lists, price sheets, survey exports. Code, APIs and content systems usually want JSON instead. This converter bridges the two. Drop in an .xlsx, .xls or .csv file, choose the worksheet from the list (or all sheets at once), and it turns every row into an object keyed by the column headers in row one, with date cells converted to YYYY-MM-DD instead of serial numbers. The result is pretty-printed with two-space indentation, ready to copy or download as a file named after your workbook.
It is useful for developers who need seed data or fixtures, store owners moving a product list into a new platform, and teams where non-technical colleagues maintain content in Excel while the app reads JSON. Parsing is done by the SheetJS library inside your browser, so the spreadsheet never leaves your machine. For a clean result, make sure the first row holds your column names and the data starts directly underneath.
Why use it
- Goes straight from .xlsx or .xls to JSON with no scripts, plugins or desktop software.
- Header cells become object keys automatically, giving you a ready-to-use array of records.
- Output is indented and readable, so you can review it before it goes into your project.
- Numbers stay numbers and text stays text, which saves type clean-up in most cases.
- The file is processed locally, which matters for internal or customer data.
How to use
Prepare the sheet
Make sure row one contains the column names, for example id, name and price, and the data starts in row two.
Add your file and pick a sheet
Drag an .xlsx, .xls or .csv file onto the drop area, then choose a sheet from the list, or All sheets.
Press Convert to JSON
The formatted result appears with the number of rows converted; copy it or download it as a file named after your workbook.
Review the output
Check the keys and values before using the JSON in your project.
Examples
Product catalog import
A sheet with sku, title, price and stock across 1,200 rows becomes an array of 1,200 objects, the first looking like {"sku": "TS-01", "title": "Cotton tee", "price": 19.5, "stock": 42}.
Translation strings
Writers keep UI text in columns key, en and de. Convert the sheet, then map the array into per-language dictionaries in your build script.
Mock data for a demo
A developer types 40 fake customers into Excel in a few minutes, converts them, and drops the JSON into the front-end's fixtures folder.
Survey export
A form tool exports responses to Excel with one column per question. After conversion, each respondent is an object that a quick script can analyse.
| In Excel | In the JSON |
|---|---|
| Row 1 (headers) | Key names in every object |
| Each data row | One object in the array |
| Numeric cell, e.g. 19.5 | Number value 19.5, no quotes |
| Text cell | String value in quotes |
| Empty cell | null for that key, so every object has every key |
| Other worksheets | Pick a sheet from the list, or All sheets for one key per sheet |
Tips
- Move the sheet you need to the first tab before converting; other tabs are skipped.
- Use short headers without spaces, such as product_name, so the keys are easy to work with in code.
- Delete title rows, logos or notes above the table, because whatever sits in row one is treated as headers.
- Date cells are converted to YYYY-MM-DD automatically (with the time when there is one), so there is no need to turn date columns into text first.
- Run the result through a JSON validator or formatter if you plan to edit it by hand.
Your workbook is read and converted in the browser with SheetJS; it is not uploaded to any server.
Frequently asked questions
Which Excel formats are supported?
Modern .xlsx files and legacy .xls files. For comma-separated files, use the CSV to JSON converter instead.
Does it convert every worksheet?
It can. After you upload the file, a list shows the sheet names; choose one sheet, or All sheets to get an object with one key per sheet.
What does the JSON look like?
An array of objects. Each object is one row, and its keys come from the header row. The file is indented with two spaces per level.
What happens to empty cells?
They come through as null, so every column key is present on every record, which makes the data easier to handle in code.
How do dates appear in the JSON?
Date cells become text in YYYY-MM-DD format, such as 2026-10-30, with an ISO time added when the cell has one. Dates typed as text in Excel are kept exactly as typed.
Are formulas included?
You get the last calculated value of each formula, not the formula itself. Save the workbook in Excel after your final edit so the values are current.
Is my spreadsheet uploaded?
No. The page loads the parsing library, but your file is opened and converted on your own device.
What is the output file called?
It takes your workbook name with a .json extension, such as products.json. You can also copy the result directly.
My sheet has no header row. What happens?
The first row is always used as keys, so your first record would turn into key names. Insert a header row before converting.
Does it handle non-English text?
Yes. Arabic, accented letters and other Unicode text are kept as-is in the JSON output.
How large a file can I convert?
There is no fixed limit in the tool; your device's memory sets the practical ceiling. Tens of thousands of rows usually work fine, while very large workbooks can make the page slow.
Why do I get an error?
The file may be password-protected, damaged, or not really an Excel workbook. Open it in Excel, save a fresh copy as .xlsx and try again.
Last updated: