Skip to main content
DevTools24

Конвертер JSON в CSV

Преобразование массивов JSON в формат CSV для электронных таблиц. Вложенные объекты выравниваются с использованием точечной нотации.

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 - Технические детали

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).

Альтернатива командной строки

# 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