VisiData 2.0 is coming soon.

Help us test the new features!

Data science without the drudgery

VisiData is an interactive multitool for tabular data. It combines the clarity of a spreadsheet, the efficiency of the terminal, and the power of Python, into a lightweight utility which can handle millions of rows with ease.

Install Now

Latest Version: 1.5.2 (2019-01-12)

Any data format!
screenshot of VisiData in action
Open 1m+ rows in the blink of an eye!
Instant histogram with Shift+F! Press Enter to dive in!
Scatterplots in the terminal!
Plotting a map with colours
8-color maps!
Save sessions for replay later! Adhoc data pipelines in batch mode!

Become a VisiData Wizard

10 Ways to Use VisiData

1. explore datasets effortlessly, no matter the format

$ vd albums.json dropbox/*.xls* agents.sqlite

Use the arrow keys to move around and q to quit.

VisiData loads data from many different sources and formats, including anything pandas can load!

New loaders are included in every release, and you can create one yourself easily.

2. convert from any input format into any output format

Within VisiData, press Ctrl+S to save the file in the format specified by the extension.

Convert directly from the command-line with:

$ vd -b input.csv -o output.json

3. as an interactive replacement for grep, awk, sed, cut, sort, uniq

$ netstat -an | vd -f fixed -o used-ports.txt

Press Ctrl+Q to exit VisiData and save to the given output file.

4. scrape HTML table data from a webpage:

$ vd

5. see a visual diff of two sheets with the same structure

$ vd --diff foo1.csv foo2.csv

6. explore an object from the Python REPL

>>> visidata.view(obj)

7. explore any pandas DataFrame

>>> vd.view_pandas(df)

8. create an adhoc data pipeline

VisiData can also be used in batch mode with scripts without requiring any interaction.

Save the cmdlog to a .vd file with Ctrl+D foo.vd, then replay the saved .vd file:

$ vd -b -p foo.vd

9. rename a bunch of files

  1. Launch vd in the directory with the files
  2. Edit the filenames (documentation on editing commands)
  3. Ctrl+S to commit (see this video showing how to use the directory browser)

10. see all the available options and commands

There are many other ways to use VisiData! To learn more, press Ctrl+H to see the manpage, or z Ctrl+H to see the full list of commands available on the current sheet.

About the Author

My name is Saul Pwanson and I'm a software architect and amateur data sleuth. I live in Seattle but the terminal is my home.

I am building an ecosystem of textpunk powertools. If you love the design of VisiData, send me an email; or you can support me on Patreon directly.

Share and enjoy!