visidata
Terminal interface for exploring and arranging tabular data with support for CSV, JSON, SQLite, Excel, and many other formats.
VisiData is a terminal-based data exploration tool that provides an interactive interface for working with tabular data. It operates through keyboard commands and displays data in a spreadsheet-like format within the terminal, allowing users to browse, filter, sort, and manipulate datasets without leaving the command line.
The tool supports a wide range of data formats including CSV, TSV, JSON, SQLite databases, Excel files (xlsx), HDF5, and many others. Users can load data from files or pipe data directly from other commands. VisiData provides hundreds of commands for data manipulation, accessible through keyboard shortcuts, with Ctrl+H displaying a quick reference guide.
VisiData targets data analysts, researchers, and developers who need to quickly examine and manipulate datasets in a terminal environment. It requires Python 3.8+ and runs on Linux, macOS, and Windows with WSL. Additional Python packages like openpyxl and lxml are needed for specific file formats, which can be installed alongside the main tool using pipx or pip.
Installation
# via pip
pip3 install visidata
# via pipx
pipx install visidata
# via pipx (with format support)
pipx install visidata --preinstall openpyxl --preinstall lxml
Alternatives & related tools
jc
Converts output of CLI tools, file types, and strings to JSON or Python dictionaries so it can be piped to jq and used in scripts.
mycli
MySQL command line client with auto-completion, syntax highlighting, and smart context-aware SQL suggestions
pgcli
Interactive PostgreSQL client with auto-completion, syntax highlighting, and smart context-sensitive suggestions.
litecli
Command-line client for SQLite databases with auto-completion and syntax highlighting.
dolphie
Real-time terminal interface for monitoring MySQL/MariaDB and ProxySQL database performance and analytics
add a badge to your README
Maintain visidata? Show that it's featured on trmn. The badge links back to this page.
[](https://www.trmn.sh/tools/visidata?utm_source=badge)<a href="https://www.trmn.sh/tools/visidata?utm_source=badge"><img src="https://www.trmn.sh/badge/visidata.svg" alt="Featured on trmn" height="20"></a>