vd

Open a CSV file

$ vd [file.csv]

$ vd [file.json]

$ vd [file1.csv] [file2.xlsx]

$ vd [https://example.com/data.csv]

$ cat [file.csv] | vd

$ vd [database.db]

$ vd -f json [file.txt]

$ vd --readonly [file.csv]

vd [options] [file...]

vd (VisiData) is a terminal-based spreadsheet and data exploration tool. It opens tabular data from many formats including CSV, JSON, Excel, SQLite, and remote URLs.
Navigation uses vim-style keys. Sheets stack like buffers; q closes current sheet, returning to previous. The sheets sheet (S) shows all open sheets.
Data analysis features include frequency tables (F), column statistics (I), and aggregations (+). Group rows with g prefix commands. Create pivot tables and perform joins between sheets.
Selection (s/t/u) marks rows for operations. Use | to select by regex or , for exact match. " opens selected rows as new sheet.
Changes can be saved back to files with Ctrl+s. Command logs enable reproducible transformations and batch processing with -b.

-f filetype

Force input file type.

Replay command log in batch mode.

Replay command log file.

Output to file after replay.

Disable saving/modifying.

Field delimiter for text files.

Execute cmdlog file.

Show diff between sources.

Display help information.

Display version information.

h/j/k/l or arrows

Navigate cells.

Go to first/last row.

Go to first/last column.

Search in current column.

Select rows matching regex.

Select rows where current column equals current cell.

Select/toggle/unselect current row.

Select/toggle/unselect all rows.

Sort by current column ascending/descending.

Frequency table for current column.

Describe (statistics) sheet.

Add aggregator to column.

Save current sheet.

Quit current sheet.

Large files may use significant memory. Some formats require additional Python packages. Editing support varies by file type. Complex operations have learning curve.

VisiData was created by Saul Pwanson and first released in 2016. It was designed as a universal tool for exploring tabular data in the terminal, inspired by sc but supporting many formats. The project emphasizes keyboard efficiency and exploratory data analysis. VisiData has grown to support dozens of data formats and is widely used for data journalism and analysis workflows.

sc-im(1), csvkit(1), miller(1), xsv(1)