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.
.. toctree:: :maxdepth: 1 scripts/in2csv scripts/sql2csv
.. toctree:: :maxdepth: 1 scripts/csvclean scripts/csvcut scripts/csvgrep scripts/csvjoin scripts/csvsort scripts/csvstack
To change field values (i.e. to run
awk-like commands on CSV files), consider miller (
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
Output and Analysis
.. toctree:: :maxdepth: 1 scripts/csvformat scripts/csvjson scripts/csvlook scripts/csvpy scripts/csvsql scripts/csvstat
- To draw plots, consider jp.
- To diff CSVs, consider daff.
- To explore CSVs interactively, consider VisiData.
.. toctree:: :maxdepth: 2 common_arguments