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
