JSON to CSV Converter
Convert JSON arrays to CSV format for spreadsheets. Nested objects are flattened using dot notation.
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 - Technische Details
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).
Kommandozeilen-Alternative
# 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