JQ. Cheatsheet

jq.md

JQ

Key/Value Shape

[{"Name": "Jonny Bravo","Age": "58"},{"Name": "Dexter","Age": "34"}]

Map JSON to CSV

cat example.json | jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv'

Output

"Name","Age"
"Jonny Bravo",58
"Dexter",34

---

## Array Shape

[["Name", "Age"],["Jonny Bravo", 58],["Dexter", 34]]

Map JSON to CSV

cat example.json | jq -r '.[] | @csv'

Output

"Name","Age"
"Jonny Bravo",58
"Dexter",34