# visidata

> Terminal interface for exploring and arranging tabular data with support for CSV, JSON, SQLite, Excel, and many other formats.

Stars: 9.4k · Language: Python · License: GPL-3.0 · Categories: Data

- Repository: https://github.com/saulpw/visidata
- Website: http://visidata.org
- Page: https://www.trmn.sh/tools/visidata

## Install

- pip: `pip3 install visidata`
- pipx: `pipx install visidata`
- pipx (with format support): `pipx install visidata --preinstall openpyxl --preinstall lxml`

## Overview

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

```bash
# via pip
pip3 install visidata
```

```bash
# via pipx
pipx install visidata
```

```bash
# via pipx (with format support)
pipx install visidata --preinstall openpyxl --preinstall lxml
```

![VisiData frequency table interface](https://media.trmn.sh/cached/473a92e735cdf74aaaa900391fdd71a9c8023d42dd08f524c913dfdac8eb188d.gif)

## Alternatives

- [jc](https://www.trmn.sh/tools/jc.md): 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. (Python, 8.7k stars)
- [mycli](https://www.trmn.sh/tools/mycli.md): MySQL command line client with auto-completion, syntax highlighting, and smart context-aware SQL suggestions (Python, 12.0k stars)
- [pgcli](https://www.trmn.sh/tools/pgcli.md): Interactive PostgreSQL client with auto-completion, syntax highlighting, and smart context-sensitive suggestions. (Python, 13.4k stars)
- [litecli](https://www.trmn.sh/tools/litecli.md): Command-line client for SQLite databases with auto-completion and syntax highlighting. (Python, 3.3k stars)
- [dolphie](https://www.trmn.sh/tools/dolphie.md): Real-time terminal interface for monitoring MySQL/MariaDB and ProxySQL database performance and analytics (Python, 1.2k stars)

## Guides

- [Best CSV Tools for the Command Line](https://www.trmn.sh/best/csv-tools): Compare Miller, VisiData, xsv, qo and csvlens for querying, transforming and browsing CSV files from the terminal.

---

Canonical: https://www.trmn.sh/tools/visidata