Understanding Sheets

VisiData’s workflow revolves around “sheets.” As with traditional spreadsheet programs, VisiData’s sheets are composed of columns and rows.

But VisiData’s takes the sheet concept to the next level: In VisiData, nearly everything — even the program’s own settings panel — is a sheet.

In VisiData, there are three types of sheets:

  • Source sheets - The data you’ve loaded directly into VisiData
  • Derived sheets - Sheets that are based on data in your source sheets. E.g., a frequency table, or a filtered subset of rows.
  • Metasheets - These are sheets that help you navigate and customize VisiData. Two of the most powerful are the Sheets Sheet (discussed below) and the Columns Sheet (discussed in the “Understanding Columns” chapter).

How to use the Sheets Sheet

VisiData’s “Sheets Sheet” lists all currently-open sheets and makes it easy to jump between sheets.

From anywhere in VisiData, you can open the Sheets Sheet by pressing Shift-S.

If you’ve just launched VisiData with a single dataset, pressing Shift-S will open a Sheets Sheet that looks something like this:

 name                type        | shortcut | nRows#| nCols#| nVisibleCols#| cursorDisplay | keyC> 
 sheets             ║ SheetsSheet | S        |     2 |    10 |           10 | sheets        | name  
 faa-wildlife-strik… CsvSheet    | 1        | 73448 |    16 |           16 | BUSINESS      |       
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
                                                                                                    
S› sheets|                                                                    S           2 sheets  

Not very exciting. But as you start juggling more sheets — frequency tables, multiple datasets, et cetera — the Sheets Sheet becomes very handy.

You can navigate the Sheets Sheet much like you would any other sheet, with one main difference: Pressing Enter will open that row’s sheet.

Warning

Pressing d on a Sheets Sheet will send that row’s sheet to the “sheets graveyard.” (You can type gS to visit the graveyard, and revive sheets there via Enter.)

How to rename a sheet

There are two ways to rename a sheet:

  • Go to the Sheets Sheet, and navigate to the row representing the sheet you want to rename. Press e to go into editing mode, type the new name, and then press Enter to complete the renaming.
  • Alternatively, while in the sheet you want to rename, press Space to raise the type-a-command prompt. Then, type rename-sheet and press Enter. At the next prompt, type the new name, and press Enter to complete the renaming.

How to close/remove a sheet

To close the current sheet (removing it from VisiData), press q.

To close all sheets (and, hence, quitting VisiData in its entirety), type gq.

To access the “sheets graveyard”, a listing of recently-closed sheets, type gS.

How to prevent sheet closure/removal

You can prevent VisiData from quitting a sheet by “guarding” it. To do so, press Space to raise the type-a-command prompt. Then, type guard-sheet and press Enter.

Quickly toggling between sheets

To flip back and forth between your current sheet and the previous one, press Control-^.

Additionally, VisiData assigns every sheet a numeric shortcut, visible at the bottom-left corner of the interface. You can jump to a sheet by pressing Alt plus the shortcut number — for instance Alt-1 to go to the first sheet you loaded.