Skip to content

Instantly share code, notes, and snippets.

@rproenca

rproenca/gist:bfa316618823ff01c39a5643f90637a7

Created November 6, 2020 17:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rproenca/bfa316618823ff01c39a5643f90637a7 to your computer and use it in GitHub Desktop.
Save rproenca/bfa316618823ff01c39a5643f90637a7 to your computer and use it in GitHub Desktop.
Download ZIP
Transform an arbitrary JSON array into CSV
Raw
gistfile1.txt
cat input.json | jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv' > output.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment