Excel to JSON
Upload an .xlsx or .xls workbook and convert any sheet to a JSON array of objects — with options to treat the first row as headers, pick a specific sheet by name, and toggle pretty-print formatting. Large files are parsed using the SheetJS library entirely in your browser, so your spreadsheet data is never transmitted to a server.
Excel File
Drop .xlsx / .xls here or click to upload
Converted locally — your file never leaves your browser
Options
JSON
What is Excel to JSON Converter?
Excel workbooks are where a significant amount of business data lives — product catalogues, employee records, financial exports, survey results — but the applications that need that data increasingly speak JSON. Manually copying Excel data into a JSON structure is impractical beyond a few rows. This tool reads .xlsx workbooks directly in the browser using SheetJS, converts each row to a JSON object with header values as keys, and preserves native data types: numbers remain numbers (not strings), Excel dates are converted to ISO 8601 strings, and booleans stay booleans. Multi-sheet workbooks produce either separate JSON arrays per sheet or a combined output keyed by sheet name. Merged cells can be left as-is or filled across the merged range. Formula cells output their calculated values, not the formula text. The JSON is ready for API submission, database import, or application data loading without additional transformation.
How to Use
- 1
Upload Your Excel File
Click "Upload" to select a .xlsx or .xls file. The tool reads the workbook using SheetJS in the browser — no file is uploaded to any server. Files with multiple sheets are supported.
- 2
Select Sheet and Configure Options
Choose which worksheet to convert (or select "All Sheets" for a combined output). Set whether the first row is a header, how to handle merged cells, and whether to include empty rows.
- 3
Convert to JSON
Click "Convert to JSON". Each data row becomes a JSON object, with header values as keys. Numbers, dates, and booleans are preserved as their native JSON types rather than being converted to strings.
- 4
Copy or Download the JSON
Copy the JSON array for use in an API, database import, or data pipeline — or download it as a .json file.
Common Use Cases
API Data Loading
Convert business spreadsheets, product catalogues, or inventory files received as .xlsx into JSON arrays to load into REST APIs or databases without manual data entry or CSV intermediaries.
React / Vue Frontend Mocking
Convert Excel data exports from stakeholders into JSON fixture files to mock API responses during frontend development, enabling work to proceed before the backend is ready.
Data Pipeline Ingestion
Many organisations store master data in Excel. Convert these .xlsx files to JSON as the first step in ETL pipelines feeding into MongoDB, PostgreSQL, or cloud data warehouses.
Excel Report Processing
Automate processing of Excel reports by converting them to JSON and then applying transformations, filters, or aggregations using JavaScript or Python without requiring Excel installations.
Conversion Examples
Excel Sheet → JSON Array
The first row of the sheet becomes JSON keys; each subsequent row becomes an object.
Input JSON
Excel Sheet1: id | name | department | salary ---+-------+-------------+------- 1 | Alice | Engineering | 95000 2 | Bob | Marketing | 72000
Output CSV
[
{"id": 1, "name": "Alice", "department": "Engineering", "salary": 95000},
{"id": 2, "name": "Bob", "department": "Marketing", "salary": 72000}
]Multi-Sheet Excel → Multiple JSON Arrays
Each worksheet becomes a separate named JSON array in the output.
Input JSON
Sheet1 (Users): id, name, email Sheet2 (Orders): order_id, user_id, total
Output CSV
{
"Users": [
{"id": 1, "name": "Alice", "email": "alice@example.com"}
],
"Orders": [
{"order_id": 101, "user_id": 1, "total": 49.99}
]
}