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.
Any data format!
||Instant histogram with Shift+F!|
Scatterplots in the terminal!
||Save sessions for replay later!|
man vdor with
Ctrl+Hfrom inside VisiData).
$ 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.
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
$ netstat -an | vd -f fixed -o used-ports.txt
Ctrl+Q to exit VisiData and save to the given output file.
$ vd https://en.wikipedia.org/wiki/List_of_largest_cities
$ vd --diff foo1.csv foo2.csv
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
vdin the directory with the files
Ctrl+Sto commit (see this video showing how to use the directory browser)
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.
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!