Visidata

VisiData v2.6

2021-09-23

visidata.org
jsvine.github.io/intro-to-visidata

Open the help menu

Display list of commands available on the current sheet

Undo/Redo

Abort the current command

Quit the current VisiData "sheet"

Force-quit VisiData entirely

Open a file

Save current sheet to filename

Copy (column for) selected rows to clipboard

Sheets Sheet

Sheets Graveyard

Columns Sheet

Global options sheet

This-sheet options sheet

to the last row

to the first row

to the leftmost column

to the rightmost column

one page down (forward)

one page up (backward)

Search forward in current column

Search backward in current column

Search forward in all columns

Search backward in all columns

Move to next matching row

Move to previous matching row

in ascending order of current column

in descending order of current column

in ascending order of key columns

in descending order of key columns

Select the current row

Unselect the current row

Toggle the current row between selected / unselected

Select all rows

Unselect all rows

Toggle all rows between selected / unselected

Select all rows where regex matches the current column

Unselect all rows where regex matches the current column

Select all rows where regex matches any column

Unselect all rows where regex matches any column

Select all rows where the current column matches the current cell

Select all rows where any column matches the current cell

Select all rows where expr evaluates to True

Unselect all rows where expr evaluates to True

Move row up

Move row down

Move column left

Move column right

Integer

Float

Currency

Date

Text

Rename current column

Set names of all unnamed columns to the values in the current or selected row(s)

Set names of all visible columns to the values in the current or selected row(s)

Adjust the width of current column to fit text in all visible rows

Adjust the width of all columns to fit text in all visible rows

Set the current column's width to n characters

Shrink the current column's width in half

Hide the current column by setting its width to 0

Unhide all columns

Create new sheet of selected rows

Create new sheet with "deep copy" of selected rows

Create frequency table of current column

Create frequency table of key columns

Add aggregator to column

Calculate one-time aggregation of column

Create a "Describe Sheet," with summary stats for each column

Create a blank column

Create an increment column (1,2,3…)

Create a new column from a Python expr evaluated against each row

Create new column(s) by splitting current column on regex

Create new column(s) by extracting regex groups from current column

Create "frozen" copy of current column, with all cells evaluated

Create pivot table sheet, with key column(s) as rows and current column as values

Create "melted" sheet, with key columns as non-melted values

Create a transposed sheet, where columns become rows and v.v.

Begin editing current cell

Finish editing

Cancel editing

Move to beginning of cell

Move to end of cell

Clear contents from cursor's position to end of line

Copy current/selected row(s)

Paste previously copied rows

Copy/paste current cell

Copy/paste column for selected rows

Paste from clipboard to current/selected cell(s)

Make current column a "key" column

Reload sheet

Toggle between current and previous sheet

Open long-name command prompt