Excel to JSON
DataConvert Excel files (xlsx, xls, csv) to JSON format. Supports nested headers, sheet selection and key mapping. 100% client-side with SheetJS.
About Excel to JSON
This Excel to JSON converter uses the SheetJS library to parse xlsx, xls, and csv files locally, transforming them into structured JSON. Parsing supports multiple worksheet selection, header row positioning, and custom key mapping. SheetJS implements a pure-JavaScript Office Open XML parser that reads cell values, formulas, and dates without server components.
How to Use
- Open the Excel to JSON tool page
- Enter or paste your data into the input area
- View the real-time results and use the copy button to get the output
Use Cases
- API data integration — Convert Excel data from business teams to JSON for direct use as API request bodies or response data.
- Database import — Transform customer or product data in Excel to JSON for batch import into MongoDB or PostgreSQL via scripts.
- Config file generation — Convert Excel-maintained configuration parameter tables to JSON config files for frontend or backend loading.
- Data migration — Convert legacy system Excel exports to JSON intermediate format for migration to new system data structures.
- Frontend visualization — Convert Excel data to JSON for direct rendering by chart libraries like ECharts or D3.js.
FAQ
What Excel file formats are supported?
It supports xlsx (Office Open XML), xls (BIFF8), and csv formats. The SheetJS parser auto-detects file type and parses correctly.
Can it handle multiple worksheets?
Yes. The tool lists all worksheet names in the file; you can select a specific sheet or convert all sheets one by one.
Are date and number types preserved?
Yes. SheetJS recognizes Excel date serial numbers and converts them to ISO 8601 strings; numbers remain numeric type, not strings.
Does it support merged cells?
Merged cell values use the top-left cell value; other positions are empty. Unmerge or adjust data structure before conversion for best results.
Are files uploaded to a server?
No. All parsing runs locally via SheetJS in your browser; file content never leaves your device, safe for confidential spreadsheets.
Comments
Comments are stored locally in your browser. Configure Giscus for cloud-based comments.