How to edit cells
For a summary of all editing commands, see the man page.
||edit contents of current cell|
||set contents of current column for selected rows to text|
||replace matching regex in current column for selected rows with subst|
||evaluate Python expr over each selected row and set current column to the result|
Modifications made to rows on derived sheets will be reflected on the source sheets. This includes the Frequency Table: editing the key column there will change all instances on the source sheet, and if that sheet is derived from another source sheet, it will be reflected there, and so on.
This does not apply to adding or deleting rows, only changes to existing rows.
Commands while editing
While in editing mode, or anytime VisiData expects input (with e.g.
;), typical readline commands become available:
||opens external $EDITOR to edit contents|
||reloads initial value|
||moves to beginning/end of line|
||deletes previous character|
||sets contents to previous/next in history|
||autocompletes input (when available)|
How to rename columns
||edits name of current column|
||sets names of all unnamed visible columns to contents of selected rows (or current row)|
||sets name of current column to contents of current cell|
||sets name of current column to combined contents of current column for selected rows|
How to set the header in an Excel sheet?
For most filetypes (e.g. csv, tsv, xls(x)) the loaders assume that the dataset's first
options.header rows contain the column names.
If the Excel file has multiple sheets with varying number of header rows:
--header=0while loading the file.
vd file.xlsx --header=0
- For each sheet, press
tto select the rows which represent the header rows.
g^to set the names of the headers to the contents of selected rows.
How to rename columns using the Columns sheet
Shift+Cto open the Columns sheet.
- Within the name column, move the cursor to the row which represents the source sheet.
eand then input the new column name. Press
qto return to the source sheet and see the renamed column.