Convert JSON object arrays to Excel (.xlsx) file and download online. All processing is done locally in your browser.
TL;DR: Free online JSON to Excel converter that exports JSON object arrays as .xlsx files. Field names are auto-inferred as header columns with nested data flattening. Instant download, processed locally.
This tool runs entirely in your browser. Open DevTools → Network panel and search your input — it appears in no request.
Usage Guide
API response JSON, structured log records — when you need Excel pivot analysis or team sharing, JSON is not intuitive. This tool converts JSON arrays (or nested objects) into .xlsx files, auto-mapping fields to columns and records to rows, with local file generation and download.
1. How to use
- Paste a JSON array (each item is an object) into the input area or copy directly from an API response.
- The tool auto-detects field structure, flattening nested objects into column names (e.g., user.name → user_name).
- Click download to get an .xlsx file, ready to open in Excel, WPS or Numbers.
2. Handling nested data
- One-level nesting auto-flattens: { "user": { "name": "A" } } → user_name column.
- Array fields (tags: ["a","b"]) become comma-separated strings in a single column.
- Data nested deeper than three levels: flatten manually with a JSON formatter tool first.
- Very large datasets (10000+ rows) may stall — batch conversion is more stable than one shot.
3. Data integrity in conversion
Converted Excel cells default to text format because the JSON number/string boundary is lost during flattening. If downstream analysis needs numeric operations, select the column in Excel → Text to Columns → Finish to convert text numbers back to numeric format. Also: JSON null becomes an empty cell, while undefined fields are dropped entirely (column header missing) — they look identical in Excel but carry different semantics.
FAQ
Completely free with no registration. JSON is converted locally in your browser and the .xlsx file is generated without any server upload.
The tool scans field names across all objects and uses their union as header columns, filling blank cells for missing fields.
Nested objects and arrays are automatically flattened or serialized into strings to keep the spreadsheet intact.
Related Tools
Related Articles
Excel to JSON: Dates Become Numbers / Chinese Garbled — Fix
When converting Excel to JSON, dates turn into numbers like 44927, Chinese is garbled, empty cells vanish? Explains Excel serial dates and encoding pitfalls, with our Excel to JSON tool.
The Complete Guide to Table Format Conversion: Excel, CSV, JSON, Markdown, and HTML
A full walkthrough of converting between Excel, CSV, JSON, Markdown, and HTML tables: format characteristics, conversion paths, hands-on workflows, and common pitfalls — 12 free online converters in one place.
JSON Parse Error 'Unexpected token'? 5 Common Causes and How to Fix Them
Getting a JSON parse error 'Unexpected token'? This article covers the 5 most common causes of JSON format errors — trailing commas, single quotes, unescaped characters, BOM headers, and comments — with fixes and code examples for each.