What JSON formats are supported?
The tool supports array of objects (where each object becomes a row with properties as columns) and array of arrays (where each sub-array becomes a row). Nested objects are flattened automatically.
How are nested JSON objects handled?
Nested objects are automatically flattened using dot notation. For example, {user: {name: 'John'}} becomes a column named 'user.name' with value 'John'.
Can I convert large JSON files?
Yes, the tool can handle JSON files up to 50MB. For very large datasets, the conversion is optimized to maintain performance while preserving data integrity.
What happens to different data types?
Numbers remain as numbers, strings as text, booleans as TRUE/FALSE, dates are formatted appropriately, and null values become empty cells in Excel.
Are column headers automatically created?
Yes, for array of objects, property names become column headers. For array of arrays, generic column headers (A, B, C...) are created, or you can specify custom headers.
Can I preview the Excel structure before downloading?
Yes, the tool provides a preview showing how your JSON data will appear in Excel format, including column headers and data organization.