Valideer JSON
Valideer JSON-code op fouten
JSON to CSV
Convert JSON data to CSV format. Supports nested objects and arrays, automatic header detection, and configurable delimiters and quoting — ready for Excel, Google Sheets, or any spreadsheet application.
JSON-hulpmiddelen
Input JSON
Output CSV
Gereedschapsopties
Delimiter
String Quoting
Auto (recommended)
Only quote cells that contain the delimiter, a double-quote, or a newline. Keeps output clean and minimal.Always quote
Wrap every cell in double-quotes, regardless of its content.Headers
Use JSON keys as column names in the first row. Recommended for readability and import compatibility.
JSON to CSV Voorbeelden
Array of objects
Convert multiple JSON objects into CSV rows, one row per object.
Input
[
{ "name": "John Doe", "age": 25, "city": "New York" },
{ "name": "Jane Doe", "age": 30, "city": "Los Angeles" },
{ "name": "Bob Smith", "age": 22, "city": "Chicago" }
]
[
{ "name": "John Doe", "age": 25, "city": "New York" },
{ "name": "Jane Doe", "age": 30, "city": "Los Angeles" },
{ "name": "Bob Smith", "age": 22, "city": "Chicago" }
]
Output
name,age,city
John Doe,25,New York
Jane Doe,30,Los Angeles
Bob Smith,22,Chicago
name,age,city
John Doe,25,New York
Jane Doe,30,Los Angeles
Bob Smith,22,Chicago
Delimiter
String Quoting
Auto (recommended)
Only quote cells that contain the delimiter, a double-quote, or a newline. Keeps output clean and minimal.Always quote
Wrap every cell in double-quotes, regardless of its content.Headers
Use JSON keys as column names in the first row. Recommended for readability and import compatibility.
Nested object (dot notation)
Nested keys are flattened using dot notation (e.g. address.city).
Input
[
{
"name": "John Doe",
"age": 25,
"address": {
"street": "123 Main St",
"city": "New York",
"state": "NY",
"postalCode": "10001"
},
"hobbies": ["reading", "running"]
}
]
[
{
"name": "John Doe",
"age": 25,
"address": {
"street": "123 Main St",
"city": "New York",
"state": "NY",
"postalCode": "10001"
},
"hobbies": ["reading", "running"]
}
]
Output
name,age,address.street,address.city,address.state,address.postalCode,hobbies[0],hobbies[1]
John Doe,25,123 Main St,New York,NY,10001,reading,running
name,age,address.street,address.city,address.state,address.postalCode,hobbies[0],hobbies[1]
John Doe,25,123 Main St,New York,NY,10001,reading,running
Delimiter
String Quoting
Auto (recommended)
Only quote cells that contain the delimiter, a double-quote, or a newline. Keeps output clean and minimal.Always quote
Wrap every cell in double-quotes, regardless of its content.Headers
Use JSON keys as column names in the first row. Recommended for readability and import compatibility.
Sparse rows
Missing keys are filled with empty values to keep columns aligned.
Input
[
{ "name": "Alice", "age": 30 },
{ "name": "Bob", "city": "Paris" },
{ "name": "Carol", "age": 25, "city": "Rome" }
]
[
{ "name": "Alice", "age": 30 },
{ "name": "Bob", "city": "Paris" },
{ "name": "Carol", "age": 25, "city": "Rome" }
]
Output
name,age,city
Alice,30,
Bob,,Paris
Carol,25,Rome
name,age,city
Alice,30,
Bob,,Paris
Carol,25,Rome
Delimiter
String Quoting
Auto (recommended)
Only quote cells that contain the delimiter, a double-quote, or a newline. Keeps output clean and minimal.Always quote
Wrap every cell in double-quotes, regardless of its content.Headers
Use JSON keys as column names in the first row. Recommended for readability and import compatibility.
Alle JSON-hulpmiddelen
JSON verfraaien
JSON-code opmaken en verfraaien
JSON verkleinen
Verklein JSON door witruimte te verwijderen
Stringify JSON
Objecten converteren naar JSON-string
JSON naar XML
Converteer JSON naar XML-formaat
Ontsnappen aan JSON
Speciale tekens in JSON ontsnappen
JSON vergelijken
Vind verschillen tussen twee JSON-objecten