jq Cheat Sheet/Convert array to TSV row

Output a JSON array as tab-separated text.

Section: Strings and Formatting

Convert array to TSV row

bash
bash
echo '["alice",30,"SF"]' | jq -r '@tsv'
Explanation

`@tsv` is useful for shell tables and spreadsheet imports.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Strings and Formatting
Convert array to CSV row
Output a JSON array as CSV.
OpenIn sheetbashsame section
Join array into string
Join array items with a delimiter.
OpenIn sheetbashsame section
Split string into array
Break a string apart using a delimiter.
OpenIn sheetbashsame section
String interpolation
Build human-readable text from JSON values.
OpenIn sheetbashsame section
URL-encode a string
Encode a string for use inside URLs or query parameters.
OpenIn sheetbashsame section
Base64-encode string
Encode a string as base64.
OpenIn sheetbashsame section