csvlens
is a command line CSV file viewer. It is like less
but made
for CSV.
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. -
-t
,--tab-separated
: Use tab as the delimiter (when specified,-d
is ignored). -
-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 onEnter
key and then exit.
You can download the tar.xz
or zip
file matching your operating system from the
releases page, extract it and execute the csvlens
binary.
For macOS, csvlens
is available on Homebrew. You can
install it using:
brew install csvlens
csvlens
is available as an AUR package. You can install it using:
yay -S csvlens
For Windows, csvlens
is available on winget.
You can install it using:
winget install --id YS-L.csvlens
csvlens
is available on pkgsrc. If you're using NetBSD you can install it using:
pkgin install csvlens
If you have Rust installed, csvlens
is available on
crates.io and you can install it using:
cargo install csvlens
Or, build and install from source after cloning this repo:
cargo install --path $(pwd)