How it works
The JSON to Excel converter transforms a JSON array of objects into a .xlsx spreadsheet β with one column per key and one row per object. Use it to turn API responses, database exports, and JSON data files into a spreadsheet for analysis, reporting, or sharing with non-developer stakeholders.
Developers work with JSON; business users work with Excel. JSON to Excel is a constant translation need: an API response containing 500 customer records needs to be sent to the sales team for review. A database export in JSON format needs to become a spreadsheet for the finance team. This tool handles the conversion instantly.
How to use it: paste a JSON array (e.g., [{"name":"Alice","age":30},{"name":"Bob","age":25}]) or upload a .json file. The tool detects the keys from the first object and uses them as column headers. Each object becomes one row. Nested objects are flattened (with dot notation: address.city). Click Convert and Download .xlsx.
Nested JSON flattening: {"user":{"name":"Alice","address":{"city":"NYC"}}} is flattened to columns: user.name, user.address.city. Arrays within objects become pipe-separated values in a single cell (e.g., ["tag1","tag2"] β "tag1|tag2").
Large datasets: JSON arrays with thousands of records convert in seconds and are fully supported by Excel's row limit (1,048,576 rows in modern .xlsx).
Privacy: JSON parsing and XLSX generation run in the browser using SheetJS.
Frequently Asked Questions
- Nested objects are flattened using dot notation: {"user":{"name":"Alice","age":30}} produces columns user.name and user.age. For deeply nested structures (3+ levels), the column names can become long. Toggle 'Flatten depth' to control how many levels are flattened vs. serialized as JSON strings.
- Yes β toggle 'Single object mode'. A single JSON object is converted to a two-column spreadsheet: Key | Value. This is useful for configuration files and API settings objects.
- JSON null values become empty cells in Excel. JSON undefined (not valid in strict JSON but sometimes present) is also treated as empty. Boolean true/false are output as Excel TRUE/FALSE values.
- Excel (.xlsx) supports up to 1,048,576 rows. JSON arrays with millions of objects will hit memory limits in the browser before hitting Excel's row limit. For very large JSON datasets (100,000+ rows), consider exporting to CSV instead β it processes more efficiently.