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