How to convert arbitrary simple JSON to CSV using jq?

by

First, obtain an array containing all the different object property names in your object array input. Those will be the columns of your CSV:

(map(keys) | add | unique) as $cols

Then, for each object in the object array input, map the column names you obtained to the corresponding properties in the object. Those will be the rows of your CSV.

map(. as $row | $cols | map($row[.])) as $rows

Finally, put the column names before the rows, as a header for the CSV, and pass the resulting row stream to the @csv filter.

$cols, $rows[] | @csv

All together now. Remember to use the -r flag to get the result as a raw string:

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

More Related Contents:

  1. Passing bash variable to jq
  2. How to merge 2 JSON objects from 2 files using jq?
  3. Select objects based on value of variable in object using jq
  4. jq not working on tag name with dashes and numbers
  5. converting CSV/XLS to JSON? [closed]
  6. Convert nested JSON array into separate columns in CSV file
  7. Iterating through JSON array in Shell script
  8. passing arguments to jq filter
  9. Modify a key-value in a json using jq in-place
  10. how to parse a JSON String with jq (or other alternatives)?
  11. How to convert a JSON object to key=value format in jq?
  12. Using jq how can I split a very large JSON file into multiple files, each a specific quantity of objects?
  13. jq: Object cannot be csv-formatted, only array
  14. jq: print key and value for each entry in an object
  15. How to format a JSON string as a table using jq?
  16. Get outputs from jq on a single line
  17. How do I update a single value in a json document using jq?
  18. Exporting JSON to environment variables
  19. How to convert a JSON object stream into an array with jq
  20. Convert a JSON array to a bash array of strings
  21. How to use jq when the variable has reserved characters?
  22. How to filter array of objects by element property values using jq?
  23. How to get key names from JSON using jq
  24. Reusable function to group_by but return an object with group as key
  25. Split a JSON file into separate files
  26. Create JSON using jq from pipe-separated keys and values in bash
  27. Constructing a JSON object from a bash associative array
  28. Parsing JSON with Unix tools
  29. How to fetch JSON file in Angular 2
  30. Which Perl module would you recommend for JSON manipulation?

Leave a Comment