VisiData is an open source powertool for exploring and manipulating 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.
vd foo.json bar.csv baz.xls
vd -b input.csv -o output.json
vd --diff foo1.csv foo2.csv
import visidata as vd; vd.view(obj)
Shift+Rand give the sample size
Ctrl+D foo.vdto save the cmdlog, then
vd -b -p foo.vd
vd, edit the filenames, then
Ctrl+Sto commit (see video #4)
There are hundreds of other uses for VisiData. The only limit is your imagination!
VisiData loads data from many different sources, including json, csv, sqlite, shp, and html. New loaders are included in every release, and other data formats can be supported easily.
VisiData works on Linux and MacOS systems entirely within a terminal, and continues to work seamlessly over ssh and within tmux. It supports modern terminal features like wide Unicode characters, 256-colors, and even some mouse commands. Scatterplots are drawn with the Unicode braille character set.
$ cd data # if you have some data $ ls # and you're not sure what to do with that data $ vd . # it's time to VisiData
You can use VisiData from within any terminal-based shell or Python REPL. Remember, if you can
cd, you can
man vdor with
Ctrl+Hfrom inside VisiData).
My name is Saul Pwanson and I'm a software architect and amateur data journalist. I live in Seattle but the terminal is my home.
I am building an ecosystem and community for textpunk powertools. If you love the design of VisiData, send me an email; or you can support me on Patreon directly.
Share and enjoy!