Convert JSON to CSV jq
Output selected fields as comma-separated values
jq -r '.[] | [.id, .name, .status] | @csv' data.json
more jq
all 17 commands →
Add field to every element
jq '[.[] | . + {"env": "prod"}]' items.json
Walk and transform all strings
jq 'walk(if type == "string" then ascii_downcase else . end)' data.json
Pretty print JSON
cat data.json | jq '.'
Filter by field
cat data.json | jq '.items[] | select(.status == "Running")'
Extract specific fields
cat data.json | jq '[.items[] | {name:.metadata.name, ns:.metadata.namespace}]'