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 bindings

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

Optional parameters

• -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.

Installation

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)

Linux package managers

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

pkgin install csvlens