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.
New loaders are included in every release, and you can create one yourself easily.
2. Convert from any input format into any output format
$ vd -b input.csv -o output.json
3. Interactively select replacement for cli tools
$ mv $(ls | vd) /trash
Select files using any of the selection commands.
" to pull them into their own sheet.
Ctrl+Q to exit VisiData and write the current sheet to stdout.
4. Scrape HTML table data from a webpage
5. Parse and explore text-based log files
$ vd output.log
: to split each line by some string.
; with a regex with capture groups like
6. Explore a Python object from the REPL
7. Explore any pandas DataFrame
8. Create an adhoc data pipeline
$ vd -b -p foo.vd
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:
9. rename a bunch of files
Edit the filenames (documentation on editing commands).
z Ctrl+S to commit the changes (before v2.0, use
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.
- [written by Saul Pwanson 2019-03-24]
- [updated on 2020-10-15]
- [updated on 2021-07-24]
- [updated on 2022-03-21]