The tool accepts a JSON array of objects or a single JSON object (automatically wrapped in an array). Each object's keys become Excel column headers and values become rows. You can paste JSON directly or upload a file up to 50MB.
In Flatten mode, nested arrays are expanded into separate rows (one row per array item) and duplicate rows are automatically removed. In Non-flatten mode, all data stays in a single row per object and multiple values for the same key are joined with a semicolon (; ).
Nested objects are flattened into column names using underscore separators. For example, {"address":{"city":"Delhi"}} becomes a column named address_city in the Excel sheet — in both Flatten and Non-flatten modes.
Yes — but only in Flatten mode. After expanding arrays into rows, the tool compares all column values and removes exact duplicate rows, keeping your Excel output clean and free of redundant data.
You can upload JSON files up to 50MB. Files larger than 50MB will be rejected. All processing happens in your browser — your data is never sent to any server.
The output is a .xlsx file named json-to-excel-YYYY-MM-DD.xlsx with today's date. Column widths are auto-calculated based on content (capped at 50 characters). The first row contains headers and subsequent rows contain data.