/visidata

A terminal spreadsheet multitool for discovering and arranging data

Primary LanguagePythonGNU General Public License v3.0GPL-3.0

VisiData v1.5.2 CircleCI

A terminal interface for exploring and arranging tabular data.

Dependencies

  • Linux or OS/X
  • Python 3.4+
  • python-dateutil
  • other modules may be required for opening particular data sources

Getting started

Installation

Each package contains the full loader suite but differs in which loader dependencies will get installed by default.

The base VisiData package concerns loaders whose dependencies are covered by the Python3 standard library.

Base loaders: tsv, csv, json, sqlite, and fixed width text.

Platform Package Manager Command Out-of-box Loaders
Python3.4+ pip3 pip3 install visidata Base
Python3.4+ conda conda install --channel conda-forge visidata Base, http, html, xls(x)
MacOS Homebrew brew install saulpw/vd/visidata Base, http, html, xls(x)
Linux (Debian/Ubuntu) apt full instructions Base, http, html, xls(x)
Linux (Debian/Ubuntu) dpkg full instructions Base, http, html, xls(x)
Windows WSL Windows is not directly supported (use WSL) N/A
Python3.4+ github pip3 install git+https://github.com/saulpw/visidata.git@stable Base

Please see /install for detailed instructions, additional information, and troubleshooting.

Usage

$ vd [<options>] <input> ...
$ <command> | vd [<options>]

VisiData supports tsv, csv, xlsx, hdf5, sqlite, json and more (see the list of supported sources).

Use -f <filetype> to force a particular filetype.

Documentation

Help and Support

If you have a question, issue, or suggestion regarding VisiData, please create an issue on Github or chat with us at #visidata on freenode.net.

vdtui

The core vdtui.py can be used to quickly create efficient terminal workflows. These have been prototyped as proof of this concept:

Other workflows should also be created as separate apps using vdtui. These apps can be very small and provide a lot of functionality; for example, see the included viewtsv.

License

The innermost core file, vdtui.py, is a single-file stand-alone library that provides a solid framework for building text user interface apps. It is distributed under the MIT free software license, and freely available for inclusion in other projects.

Other VisiData components, including the main vd application, addons, loaders, and other code in this repository, are available for use and distribution under GPLv3.

Credits

VisiData is conceived and developed by Saul Pwanson <vd@saul.pw>.

Anja Kefala <anja.kefala@gmail.com> maintains the documentation and packages for all platforms.

Many thanks to numerous other contributors, and to those wonderful users who provide feedback, for helping to make VisiData the awesome tool that it is.