VisiData

Terminal spreadsheet multitool for exploring and arranging tabular data

VisiData is an interactive terminal application for exploring, summarizing, and transforming tabular data. It opens CSV, JSON, SQLite, Excel, and many other sources and supports keyboard-driven filtering, pivots, and frequency tables.

Key features

Opens dozens of tabular formats
Keyboard-driven filtering and sorting
Frequency tables and pivots
Scriptable command log

Try it on DevTools Daily

CSV tools

Similar tools

Miller
Like awk, sed, cut, and sort for name-indexed data such as CSV, TSV, and JSON
FreeOpen sourceCLI, macOS, Windows +1
jq
Lightweight command-line JSON processor, like sed for JSON data
FreeOpen sourceCLI, macOS, Windows +1
yq
Portable command-line YAML, JSON, XML, and TOML processor with jq-like syntax
FreeOpen sourceCLI, macOS, Windows +1
Datasette
Explore and publish SQLite data as an interactive website and JSON API
FreeOpen sourceCLI, Web, Self-hosted
DuckDB
In-process analytical SQL database for fast queries over local and remote files
by DuckDB LabsFreeOpen sourceCLI, macOS, Windows +2
ClickHouse
Open-source column-oriented database for real-time analytics
by ClickHouseFreemiumOpen sourceLinux, macOS, Self-hosted +2