csvtool

Utility to filter and extract data from CSV formatted sources. More information: <https://github.com/maroofi/csvtool>.

Install

All systems
curl cmd.cat/csvtool.sh
Debian Debian
apt-get install csvtool
Ubuntu
apt-get install csvtool
image/svg+xml Kali Linux
apt-get install csvtool
CentOS
yum install csvtool
Fedora
dnf install csvtool
Windows (WSL2)
sudo apt-get update sudo apt-get install csvtool
Raspbian
apt-get install csvtool
Dockerfile
dockerfile.run/csvtool

Utility to filter and extract data from CSV formatted sources. More information: <https://github.com/maroofi/csvtool>.

  • Extract the second column from a CSV file:
    csvtool --column 2 path/to/file.csv
  • Extract the second and fourth columns from a CSV file:
    csvtool --column 2,4 path/to/file.csv
  • Extract lines from a CSV file where the second column exactly matches 'Foo':
    csvtool --column 2 --search '^Foo$' path/to/file.csv
  • Extract lines from a CSV file where the second column starts with 'Bar':
    csvtool --column 2 --search '^Bar' path/to/file.csv
  • Find lines in a CSV file where the second column ends with 'Baz' and then extract the third and sixth columns:
    csvtool --column 2 --search 'Baz$' path/to/file.csv | csvtool --no-header --column 3,6

© tl;dr; authors and contributors