XLSX to JSON Converter

Quick answer: Convert Excel sheets into JSON for APIs, configs, and seed data. Open XLSX 转 JSON — everything runs locally in your browser, and files never leave your device.

Steps

1. Upload the .xlsx to the Excel to JSON tool.
2. Confirm the first row supplies keys; toggle type inference.
3. Download the .json.

Important notes

• The header row must be clean — no merged cells; flatten two-level headers in Excel first.
• Dates export per Excel's stored value — confirm the ISO string and timezone match expectations.
• Delete blank rows/columns to avoid null fields in output.

Common questions

Multiple sheets? The first sheet converts by default; export others separately.

Merged cells? Only the top-left cell keeps a value — unmerge and fill in Excel first.

Pro tips

The most common downstream failure is type drift: Excel stores 2026-09-13 as a serial number, so dates can arrive in JSON as numeric serials instead of date strings depending on the cell format. Test with one row containing dates, decimals, and a long ID before converting the full sheet. If keys must stay stable across exports (for an API contract), freeze the header row and protect it from edits — a renamed column becomes a new key in the JSON and silently breaks consumers.

Can I export only visible (filtered) rows? Hidden rows still export — delete or move filtered-out rows to a separate sheet first if you need only the visible subset.