Reference

csvkit is composed of command-line tools that can be divided into three major categories: Input, Processing, and Output. Documentation and examples for each tool are described on the following pages.

Input

• in2csv
• sql2csv

Processing

• csvclean
• csvcut
• csvgrep
• csvjoin
• csvsort
• csvstack

To transpose CSVs, consider csvtool. Install csvtool on Linux using your package manager, or on macOS using:

brew install ocaml
opam install csv
ln -s ~/.opam/system/bin/csvtool /usr/local/bin/
csvtool --help

To run sed-like commands on CSV files, consider csvsed.

Output and Analysis

• csvformat
• csvjson
• csvlook
• csvpy
• csvsql
• csvstat

To diff CSVs, consider daff. An alternative to csvsql is q.

Common arguments

• Arguments common to all tools