csv tools

Jun 21, 2022

CSV querying libraries:

miller - slow but thorough and multi-format (json, csv, tsv) xsv - faster, but no release since 2018. Author seems busy with other stuff (not complaining) zsv - very fast csv tools, C, never used it qsv - very fast csv tools, rust, never used it. Will turn json to csv (not sure how) csvkit - slow, but the most thorough csv tools I know of

Or you could load and query your CSV through slqite

CSV terminal output

tv - tidy viewer:

Tidy Viewer (tv) is a cross-platform csv pretty printer that uses column styling to maximize viewer enjoyment.


VisiData is an interactive multitool for tabular data. It combines the clarity of a spreadsheet, the efficiency of the terminal, and the power of Python, into a lightweight utility which can handle millions of rows with ease.

has several of the functionalities of the querying libs, but also is a UI and can even show graphs in the terminal

↑ up