Convert JSON to CSV

Output selected fields as comma-separated values

jq -r '.[] | [.id, .name, .status] | @csv' data.json
tool
jq17 commands
tags
jq

More jq commands

  • Add field to every element
    jq '[.[] | . + {"env": "prod"}]' items.json

    Inject a new key-value pair into every array element

  • Walk and transform all strings
    jq 'walk(if type == "string" then ascii_downcase else . end)' data.json

    Recursively lowercase all string values in a JSON document

  • Pretty print JSON
    cat data.json | jq '.'

    Format and colorize a JSON file

  • Filter by field
    cat data.json | jq '.items[] | select(.status == "Running")'

    Select objects where a field equals a value

  • Extract specific fields
    cat data.json | jq '[.items[] | {name:.metadata.name, ns:.metadata.namespace}]'

    Project only specific fields into a new array

all 17 jq commands