csvq

csvq is a CLI package for parsing and transforming CSV files. This is useful because often trimming down a CSV file can make processing it easier.

Install

Download the latest release for your architecture.

Usage

Extract first_name and last_name columns (in that order). Sort results.

csvq -keep first_name,last_name ~/Downloads/report.csv | sort -u

Change delimiter used in report.csv.

csvq -d';' user_id,dob,email ~/Downloads/report.csv

Output CSV columns in a table.

csvq -keep first_name,last_name -format table

Combine multiple files.

csvq -keep user_id,email ~/Downloads/report1.csv ~/Downloads/report2.csv

Supported and tested platforms

• 64-bit Linux (Ubuntu, Debian), macOS, and Windows

License

Apache License 2.0 - See LICENSE for details.