Convert JSON arrays to CSV format instantly
Showing preview. Full data available in CSV output above.
Save on currency conversion fees when processing international e-commerce data. Wise offers the real exchange rate with transparent fees for multi-currency analytics.
[
{
"id": 1,
"name": "Product A",
"price": 29.99,
"category": "Electronics"
},
{
"id": 2,
"name": "Product B",
"price": 19.99,
"category": "Books"
}
]
[)
You need a JSON array containing objects. Each object becomes a row in the CSV, and object properties become columns. Nested objects are automatically flattened (e.g., user.address.city becomes a column). Mixed structures (objects with different properties) will work, but may result in empty cells for missing properties.
Nested objects are flattened using dot notation (parent.child). Arrays are converted to comma-separated strings. For example, {"user": {"name": "John", "age": 30}} becomes columns user.name and user.age. {"tags": ["tag1", "tag2"]} becomes a single column with value "tag1,tag2".
Excel-safe encoding ensures proper handling of special characters like commas, quotes, and line breaks within cells. Without it, Excel may misinterpret CSV data. This option wraps all fields in quotes and escapes existing quotes by doubling them (standard CSV format). It also handles international characters and prevents formula injection security risks.
Comma (,) is the standard CSV delimiter used in English-speaking countries. Semicolon (;) is commonly used in European countries where comma is used as decimal separator (e.g., 29,99 instead of 29.99). Choose semicolon if you're working with European Excel or locale settings that use comma as decimal separator.