Excel to JSON
DataConvert Excel files (xlsx, xls, csv) to JSON format. Supports nested headers, sheet selection and key mapping. Choose the sheet and header row and keep numbers.
Related Tools
About Excel to JSON
This Excel to JSON converter uses the SheetJS library to parse xlsx, xls, and csv files locally in your browser, transforming them into structured JSON objects or arrays. Parsing supports multiple worksheet selection, header row positioning, nested header recognition, and custom key mapping. Unlike converting to plain text or CSV, JSON is about preserving and expressing structure: SheetJS implements a pure-JavaScript Office Open XML parser that reads cell values, formula results, and date and number types without any server component, so numbers stay numeric, dates become ISO 8601 strings, and formulas yield computed results rather than the formulas themselves. The conversion turns rows into objects keyed by the header, so whether the first row is truly the header and whether it contains merged cells decides whether keys line up correctly. The tidy JSON feeds directly into API integration, database imports, or frontend visualization. Files are parsed entirely in your browser and never uploaded, so commercial or customer data stays private.
How to Use
- Open the Excel to JSON tool
- Import or paste the data to process
- Adjust the output options as needed
- Click the Process button; results appear in real time
- Copy or export the result
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.
- API test fixtures — Turn test cases from Excel into JSON arrays to use as input data for API automation tests.
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.
What if the first row is not a header?
Use header row positioning to point at the real header row; if the header is made of merged cells, unmerge or restructure it first to avoid missing keys.
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 the files uploaded to a server?
No. All parsing runs locally via SheetJS and the content never leaves your device, safe for spreadsheets with commercial secrets.