flatten-json-to-csv-using-jq.md

title	date	tags	aliases
2025-01-27 - TIL - Flatten JSON to CSV Using JQ	2025-01-27 13:02:58 -0800	flatten-json-to-csv-using-jq resources til	today-i-learned things-i-learned

2025-01-27 - TIL - Flatten JSON to CSV Using JQ

How to flatten a JSON object into CSV using JQ.

Usage

$ cat file.json | jq -r '.value[] | [ keys[] as $k | .[$k] ] | flatten | @csv' > file.csv

Use Cases

• Convert JSON to CSV
• Flatten JSON array before converting to CSV

References

• JSON object values into CSV with jq | DJ Adams