Print CSV column with awk


This post goes over how to print CSV column with awk:

Prerequisites

Given file.csv:

headerA,headerB
row2A,row2B
row3A,row3B

CSV first column

Print the first column:

awk -F',' '{ print $1 }' file.csv

Output:

headerA
row2A
row3A

Print the first column excluding the header:

awk -F',' '{ print $1 }' file.csv | tail -n +2

Output:

row2A
row3A

CSV second column

Print the second column of a CSV file:

awk -F',' '{ print $2 }' file.csv

Output:

headerB
row2B
row3B

Print the second column excluding the header:

awk -F',' '{ print $2 }' file.csv | tail -n +2

Output:

row2B
row3B


Please support this site and join our Discord!