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 + h (or Ctrl + ←) | Scroll one window left Ctrl + l (or Ctrl + →) | Scroll one window right 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 Enter (in Cell mode) | Print the selected cell to stdout and exit -S | Toggle line wrapping 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