visidata

VisiData is a powerful terminal-based interface for exploring and manipulating tabular data. It provides an interactive, spreadsheet-like experience directly in your command line, allowing you to navigate, filter, sort, and analyze data files without leaving the terminal environment.

The tool supports an impressive range of data formats including CSV, TSV, JSON, SQLite, Excel (xlsx), HDF5, and many others, making it a versatile choice for data analysts, developers, and researchers working with diverse datasets. VisiData's strength lies in its ability to handle large datasets efficiently while providing intuitive keyboard-driven navigation and data manipulation capabilities.

With hundreds of available commands and options, VisiData offers sophisticated data exploration features like frequency tables, pivoting, joining datasets, and creating visualizations. The tool is designed for users who prefer working in terminal environments and need quick, powerful data analysis capabilities without the overhead of GUI applications. Whether you're doing exploratory data analysis, data cleaning, or need to quickly inspect and transform datasets, VisiData provides a fast and efficient workflow.

Installation

# via pip
pip3 install visidata