Skip to main content

Quick Start Card — First 30 Minutes

This is the only page you need for your first VisiData session. Learn these 20 keys first. Everything else can wait.

tip

Bookmark this page. The full Keyboard Map has 100+ keys — come back to that after your first hour.


Open VisiData

vd filename.csv # open a CSV file
vd filename.xlsx # open Excel
cat file.json | vd -f json # pipe JSON from stdin
vd directory/ # browse a directory

The 20 Keys That Matter First

Move Around

KeyDoes what
Arrow keys or hjklMove cursor
g + ArrowJump to edge (first/last row or column)
qGo back one sheet (exit if on last)

Understand Your Data

KeyDoes what
Shift+IProfile all columns — null counts, min, max, mean
Shift+FFrequency table for current column — value counts
[ / ]Sort ascending / descending by current column

Select and Filter Rows

KeyDoes what
| + patternSelect rows matching regex in current column
z| + exprSelect rows matching Python expression
"Open new sheet with only selected rows
guDeselect all

Change Column Type (do this before sorting or aggregating)

KeyDoes what
#Cast to integer
%Cast to float
@Cast to date

Edit and Transform

KeyDoes what
eEdit current cell
Ctrl+CCancel an edit (inside edit mode)
gs then g=Bulk set selected rows to Python expression
UUndo last change

Save

KeyDoes what
Ctrl+SSave current sheet
Shift+D then Ctrl+SSave workflow as replayable .vdj

Your First 5-Minute Workflow

vd ~/github/practice-folder/visidata/01-loading/01-employees.csv

# 1. Look at the data — just scroll around with arrow keys
# 2. Press Shift+I → see how many nulls, what types you have
# 3. Press q → back to source
# 4. Move to 'salary' column → press % → cast to float
# 5. Press ] → sort by salary descending — see top earners
# 6. Move to 'department' column → press Shift+F → see department counts
# 7. Press q → back to source
# 8. Move to 'department' → press | → type Engineering → Enter
# → Engineering rows turn yellow (selected)
# 9. Press " → open filtered sheet with only Engineering employees
# 10. Press Ctrl+S → save to /tmp/engineering.csv
# 11. Press q → back to full sheet

If You're Stuck

SituationKey
Don't know what key to useSpace — command palette, type a keyword
Lost in the sheet stackShift+S — see all open sheets
Want to cancel somethingCtrl+C
Accidentally deleted somethingU — undo
Want to quit cleanlygq — quit all sheets

Common Beginner Mistakes

MistakeFix
Sort gives wrong order (1, 10, 2)Cast column to # or % first
" opens empty sheetNo rows were selected — use | first
q exits VisiDataThat was the last sheet — use Ctrl+^ to swap instead
Expression gives #ERRColumn not cast — cast to % or # before using in g= or =

What's Next

When you're ready for the full reference: