csvlens

csvlens is a command line CSV file viewer. It is like less but made for CSV.

Usage

Run csvlens by providing the CSV filename:

csvlens <filename>

Pipe CSV data directly to csvlens:

<your commands producing some csv data> | csvlens

Key	Action
`hjkl` (or `← ↓ ↑→` )	Scroll one row or column in the given direction
`Ctrl + f` (or `Page Down`)	Scroll one window down
`Ctrl + b` (or `Page Up`)	Scroll one window up
`Ctrl + d` (or `d`)	Scroll half a window down
`Ctrl + u` (or `u`)	Scroll half a window up
`Ctrl + h`	Scroll one window left
`Ctrl + l`	Scroll one window right
`Ctrl + ←`	Scroll left to first column
`Ctrl + →`	Scroll right to last column
`G` (or `End`)	Go to bottom
`g` (or `Home`)	Go to top
`<n>G`	Go to line `n`
`/<regex>`	Find content matching regex and highlight matches
`n` (in Find mode)	Jump to next result
`N` (in Find mode)	Jump to previous result
`&<regex>`	Filter rows using regex (show only matches)
`*<regex>`	Filter columns using regex (show only matches)
`TAB`	Toggle between row, column or cell selection modes
`>`	Increase selected column's width
`<`	Decrease selected column's width
`Enter` (in Cell mode)	Print the selected cell to stdout and exit
`-S`	Toggle line wrapping
`r`	Reset to default view (clear all filters and custom column widths)
`H`	Display help
`q`	Exit

-d <delimiter>: Use this delimiter when parsing the CSV (e.g. csvlens file.csv -d $'\t').

Specify -d auto to auto-detect the delimiter.
-i, --ignore-case: Ignore case when searching. This flag is ignored if any uppercase letters are present in the search string.
--echo-column <column_name>: Print the value of this column at the selected row to stdout on Enter key and then exit.

csvlens is available on crates.io, so you can install it using:

cargo install csvlens

Or, build and install from source:

cargo install --path $(pwd)

csvlens is also available on pkgsrc. If you're using NetBSD you can install it using:

pkgin install csvlens