csvlens, for interacting with metadata (and other csv/tsv on the command line)

Hi all,
I recently came across csvlens. While not a bioinformatics tool per se, bioinformaticians are often interacting with csv/tsv files on the command line so I thought I'd share this in case others find it helpful. I've found it to be a useful way to view/search sample metadata files without having to open them in Excel/Google Sheets/etc.

For example, here's a view of the Moving Pictures sample metadata using csvlens:

csvlens -t sample-metadata.tsv

Screenshot 2024-01-17 at 10.48.38 AM

Search for the text right:

/right 

Screenshot 2024-01-17 at 10.49.29 AM

6 Likes

This is a very useful tool. Some key bindings and optional parameters can be found here: CSV Lens - Command line csv/tsv viewer

2 Likes