Excel to JSON
Convert Excel workbooks into JSON. Choose array of objects, array of arrays, or a map keyed by sheet.
Free & unlimited
All processing happens in your browser. No data is sent to any server.
About this tool
- 1
Upload your Excel file
Drag and drop or select an .xlsx file from your device.
- 2
Select the worksheet
Choose which sheet to convert if your workbook contains multiple tabs.
- 3
Configure header mapping
Specify whether the first row contains headers that should become JSON object keys.
- 4
Download the JSON
Copy the generated JSON or download it as a .json file.
- Clean up your Excel headers before converting - they become JSON keys and should be valid identifiers.
- Empty rows in the spreadsheet are skipped automatically to keep the JSON output clean.
- Columns without headers are assigned auto-generated keys like "column_1", "column_2".
- Use the "compact" option to remove null and empty values from the output for smaller file sizes.
- Maps header row to JSON object keys automatically
- Handles multiple data types (strings, numbers, dates, booleans)
- Supports multi-sheet workbooks with sheet selection
- Pretty-printed output with configurable indentation
- Processes files locally in the browser
- Convert Excel data exports into JSON for use in web applications and APIs
- Transform spreadsheet-based datasets into JSON for NoSQL database imports
- Generate JSON fixture data from Excel test case spreadsheets
- Convert Excel lookup tables into JSON configuration files
Numbers stay as numbers, text becomes strings, dates are converted to ISO 8601 format, and booleans map to true/false.
Merged cells are unmerged and the value is placed in the top-left cell. Other cells in the merged range will be empty.
Yes. You can choose to convert all sheets into a single JSON object where each key is the sheet name and the value is the array of row objects.