VisiData is an open source supertool 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 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
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 armchair data journalist. I live in Seattle but the terminal is my home.
I am building an ecosystem of textpunk powertools, and ideally a community of people to appreciate them. If you love VisiData, please send me an email; or if that's too much work, you can just support me on Patreon.
Share and enjoy!