CSV Terminal Tools
CSV (comma-separated values) stores tabular data as plain text with one record per line, and it stays the format that databases, spreadsheets and analytics tools can all read and write.
Terminal work with CSV divides into viewing and querying. Grid viewers and pagers show a wide file with aligned columns, frozen headers and search, while query engines run SQL against a file on disk, TSV and Parquet included, with no database to load it into first. Both come out when a file is too large for a spreadsheet or sits on a remote server.
Below is a list of terminal tools that work with CSV and other tabular data.
csvi
A simple cross-platform terminal CSV editor.
A simple cross-platform terminal CSV editor.
csvlens
a csv viewer like less but made for csv.
a csv viewer like less but made for csv.
daff
align and compare tables
align and compare tables
datui
Data Exploration in the Terminal.
Data Exploration in the Terminal.
miller
an all in one swiss army knife for data processing.
an all in one swiss army knife for data processing.
nless
Excel for your logs. Pipe in anything, wrangle it into columns.
Excel for your logs. Pipe in anything, wrangle it into columns.
octosql
A CLI tool which lets you query a plethora of databases.
A CLI tool which lets you query a plethora of databases.
parqeye
Peek inside Parquet files right from your terminal.
Peek inside Parquet files right from your terminal.
parqv
A TUI for visualizing and analyzing files with multiple formats.
A TUI for visualizing and analyzing files with multiple formats.
pqviewer
View Apache Parquet Files In Your Terminal.
View Apache Parquet Files In Your Terminal.
pspg
A UNIX pager optimized for tabular data.
A UNIX pager optimized for tabular data.
qo
An interactive minimalist TUI to query JSON, CSV, and TSV using SQL.
An interactive minimalist TUI to query JSON, CSV, and TSV using SQL.
qsv
Blazing-fast CSV data-wrangling toolkit
Blazing-fast CSV data-wrangling toolkit
sc-im
An ncurses spreadsheet program for terminal
An ncurses spreadsheet program for terminal
sheets
Minimal terminal based spreadsheet and CSV viewer.
Minimal terminal based spreadsheet and CSV viewer.
sqly
Easily execute SQL against CSV/TSV/LTSV/JSON and Excel with shell.
Easily execute SQL against CSV/TSV/LTSV/JSON and Excel with shell.
tabiew
A lightweight TUI application to view and query tabular data files.
A lightweight TUI application to view and query tabular data files.
textql
Execute SQL against structured text like CSV or TSV
Execute SQL against structured text like CSV or TSV
visidata
A terminal spreadsheet multitool for discovering and arranging data.
A terminal spreadsheet multitool for discovering and arranging data.
xan
The CSV magician.
The CSV magician.
xled
sed and awk for tabular data.
sed and awk for tabular data.
xql
An SQL REPL for SharePoint Lists and CSV files.
An SQL REPL for SharePoint Lists and CSV files.
xsv
A fast CSV command line toolkit written in Rust.
A fast CSV command line toolkit written in Rust.
Know any terminal tools that would be good for this list? Post a Tool here!
