What does this tool do?
You get a spreadsheet from a PM and need JSON your code can consume — or you have a JSON array from an API and someone wants it as a spreadsheet. This tool converts in both directions: Excel → JSONuses the first row as field names by default to create an object array, with an optional 2D-array mode and each sheet shown separately;JSON → Excel downloads a .xlsx file from a pasted JSON array, using object keys as the header row.
Parsing and generation run entirely in your browser. Files are never uploaded, so internal data stays on your machine.
How to use
- Excel to JSON: open the “Excel → JSON” tab, click or drop a file, choose object-array or 2D-array output, then browse each sheet and copy the result;
- JSON to Excel: open the “JSON → Excel” tab, paste a JSON array, and click “Export Excel” to download data.xlsx.
FAQ
- Is my file uploaded to a server?
- No. Reading and parsing happen entirely in your browser, and spreadsheet contents never leave your device. The site only uses Cloudflare to collect anonymous usage and performance metrics.
- Which file formats are supported?
- Both .xlsx and .xls. Workbooks with multiple sheets are fully parsed, and each sheet can be viewed and copied separately.
- What shape must the JSON be for JSON-to-Excel?
- A non-empty JSON array of objects. Object keys become the header row, and each object becomes one data row. Nested objects and arrays are saved as JSON text; integers outside JavaScript’s safe range must be quoted.
- What is the difference between object arrays and 2D arrays?
- Object arrays use the first row as field names and preserve numbers and booleans, making them ideal for reversing a JSON export. 2D arrays preserve the sheet’s row structure and displayed values for worksheets without fixed headers. Empty cells become null in both modes.
