DOCUMENT & SPREADSHEET FLAGSHIP
Excel To JSON
At a glance
Excel to JSON — Convert an Excel workbook into structured JSON, with every worksheet becoming a named array of row objects.
Free for the core workflow, no account required. Files are processed in the browser for these workflows and are not intentionally uploaded by the tool.
About Excel to JSON
Convert an Excel workbook into structured JSON, with every worksheet becoming a named array of row objects.
JSON is the native language of web applications, and a spreadsheet is the native language of people who maintain lists, so a lot of real work is moving a table from the second world into the first. The conversion has one decision that matters more than the rest: what the output is shaped like. This tool turns every worksheet into a named array of row objects, using the first row of each sheet as the keys, which maps directly onto what an API, a JavaScript program, or a static site generator expects to receive. Worked example — a workbook with two sheets. The Employees sheet has the header name, role, salary, and three rows: Ava Chen, Engineer, 92000; Marco Ruiz, Designer, 68000; Priya Nair, Support Lead, 61000. The Departments sheet has the header dept, headcount, and two rows: Engineering, 14; Design, 6. The JSON output is an object with two keys, Employees and Departments, each holding an array of row objects, so the first employee appears as {"name": "Ava Chen", "role": "Engineer", "salary": 92000}. Add the salaries and you get 221,000, and add the headcounts and you get 20, which matches the two sheets. The check that matters is the row count: three objects under Employees and two under Departments, one per spreadsheet row, with nothing duplicated and nothing missing. Table — how each kind of cell becomes JSON: a number becomes a JSON number, so 92000 stays 92000; text becomes a JSON string; a date becomes an Excel serial number such as 45658 for 1 January 2025, or an ISO string when the cell is formatted as text; a TRUE or FALSE cell becomes the JSON boolean true or false; an empty cell is left out of its object; a formula becomes its calculated value, never the expression; an error cell such as #DIV/0! becomes its error text as a string. Before / after — before: two worksheets in a workbook, readable by a person, invisible to code; after: one JSON document where every sheet is a named array and every row is an object with named fields, ready to paste into a script, a config file, or an API test. The most common mistake is a header row that was written for humans rather than for code. A header like User ID with a space becomes the key "User ID", which works in JSON but is awkward in most languages, and a header with a duplicate name collides with its twin. Rename headers in Excel first, using short names with underscores, and the JSON needs no cleanup at all. A document rarely needs just one pass. The CSV to TSV converts comma-separated CSV data into a tab-separated file for databases, mainframe feeds, and command-line tools that prefer tabs and the TSV to CSV converts tab-separated values into a standard comma-separated CSV file, with quoting handled correctly on the way over. The CSV Column Extractor pulls one column out of a CSV file by its header name and returns a clean text list of its values as well. Sources: ECMA-404, The JSON Data Interchange Syntax (2017); Microsoft Support, Excel specifications and limits (accessed November 2026); MDN Web Docs, JSON (accessed November 2026). Content last reviewed: November 2026. Each worksheet becomes a named array of row objects, using the first row as keys. This structure maps directly onto what APIs and JavaScript code expect, making it the fastest path from a spreadsheet to a working data feed.
Primary objective: Convert an Excel workbook into structured JSON while retaining separate worksheet names.
Privacy assurance: Files are processed in the browser for these workflows and are not intentionally uploaded by the tool.
How to Use Excel to JSON
- Open the workbook in the converter and check that every sheet you need has a clean header row.
- Rename any header that has spaces, duplicates, or special characters, using short names with underscores.
- Run the conversion and review the JSON: each sheet name should appear once, with one object per row.
- Count the objects under each sheet name and compare them with the row counts in the workbook.
- Copy the JSON into your code, API test, or data file, and keep the workbook as the source of truth.
Key Use Cases & Applications
- Turning a content spreadsheet into JSON for a static site generator.
- Preparing translation tables for a localisation pipeline.
- Feeding a price list into a web application during development.
- Inspecting a workbook as structured data before writing an import script.
- Preparing translation tables for a localization pipeline.
Frequently Asked Questions
Why are my dates numbers like 45658 in the JSON?
Excel stores dates as serial numbers counting days from its epoch, and 45658 is 1 January 2025. If your code needs readable dates, format the column as text in ISO form, YYYY-MM-DD, before converting, or convert the serials in code.
How do I get one flat array instead of an object with sheet names?
The output is always an object keyed by sheet name, because a workbook can hold many sheets. For a single-sheet workbook, take the array under that one key and use it directly; it already holds every row as an object.
Why do some of my rows have missing keys?
Trailing empty cells are left out of a row object, so a row that ends early simply has fewer keys. If the missing value matters, fill the cell in Excel first rather than guessing after the fact.
Can I convert a workbook with 100,000 rows?
It usually works, but the JSON text is much larger than the workbook and the browser holds it all in memory. For very large sheets, split the workbook into smaller files first and convert each one separately.
By Shehzad Hussain — owner and editor of ExpTool, based in Multan, Pakistan. He builds and tests every tool on this site himself.
Last updated: 2026-11-04