jq -r '.[] | [.name, .age] | @tsv' data.json

Category: Data Science & Analysis

jq -r '.[] | [.name, .age] | @tsv' data.json

Convert JSON objects to TSV lines

The -r flag outputs raw strings instead of JSON-quoted text. The filter .[] streams each array element, [.name, .age] builds a two-value array, and @tsv renders it as a tab-separated line. This turns a JSON array into a TSV (tab-separated values) table for spreadsheet tools. Use @csv instead of @tsv for comma-separated output.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.