JSONからCSV変換ツール

JSON配列をスプレッドシート用のCSV形式に変換します。ネストされたオブジェクトはドット表記でフラット化されます。

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 - 技術的な詳細

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