JSON to CSV Converter

Convert JSON arrays to CSV format for spreadsheets. Nested objects are flattened using dot notation.

Delimiter

Include headers

Flatten nested objects (e.g., address.city)

JSON Input (array of objects)

About JSON to CSV Conversion

Input should be a JSON array of objects
Nested objects are flattened using dot notation (address.city)
Arrays are JSON-stringified in the output
Values containing delimiters or quotes are properly escaped

JSON to CSV - Détails techniques

Converting JSON to CSV is useful for exporting API data to spreadsheets, generating reports, or data analysis. Nested objects are flattened using dot notation (e.g., address.city).

Alternative en ligne de commande

# Using jq to convert JSON to CSV\njq -r '(.[0] | keys_unsorted) as $keys | $keys, map([.[ $keys[] ]])[] | @csv' data.json\n\n# Or use json2csv npm package\nnpx json2csv -i data.json