csvtool

Extract specific columns from a CSV

$ csvtool col [1,3,5] [data.csv]

$ csvtool head [10] [data.csv]

$ csvtool transpose [data.csv]

$ csvtool paste [file1.csv] [file2.csv]

$ csvtool replace [column] [old] [new] [data.csv]

$ csvtool -t "[;]" col [1,2] [data.csv]

csvtool [options] command [arguments] file

csvtool is a fast CSV manipulation utility written in OCaml. It provides various operations for transforming, filtering, and analyzing CSV data from the command line.
The tool is designed for speed and handles large files efficiently. It supports common operations like column extraction, row filtering, transposition, and file joining. The call command enables running external commands for each row.
csvtool uses a streaming approach where possible, allowing it to process files larger than available memory for many operations. It properly handles CSV quoting and escaping.

col COLUMNS

Extract specified columns (1-indexed, comma-separated).

Output first N rows.

Drop first N rows.

Transpose rows and columns.

Paste files side by side.

Replace values in a column.

Join files on a column.

Run command for each row.

Input delimiter (default: comma).

Output delimiter.

Output file.

Column numbers are 1-indexed, not 0-indexed. Some operations require loading the entire file into memory. Quoting rules may differ from other CSV tools. Error messages can be cryptic.

csvtool was developed as a fast, lightweight CSV processor. Written in OCaml for performance, it provides an alternative to heavier tools when simple, fast transformations are needed on CSV data.

csvkit(1), cut(1), awk(1), miller(1)