csv files printer
cat for csv files
tbl lets you print out csv files to your terminal, formatted and "prettified".
A lot of the hard work is done with the rapidtables package, check it out!
- Python 3.4+
pip install --user clitbl
tbl -h / tbl --help to see help.
- The most common use it to just print the table
The headers options lets you explicitly specify the headers for the table. Use this option when you csv files does not include headers, (e.g exampleFile
tbl file.csv --headers '#Index#Item#Cost#Tax#Total'
The select options lets you select what columns to print (similar to SQL SELECT)
tbl file.csv --select '#Item#Tax'
select use the first charcter as a separator,
it can be any character (kinda like a
:exclamation: The headers specified with this option are case-sensitive
select headers can be used together
The format options lets you specify the format used when printing the table.
The available formats are:
There are several cases
tbl does not support:
- Duplicated headers, all headers must be distinct
- Very long headers, while tbl can wrap long paragraph of text in a cell, it cannot wrap text in the headers, which may lead to disfigured output
:exclamation: This is not the use case for tbl anyway, but dont try to print huge tables (several GBs), as tbl (and rapidtable) read the entire table to memory before printing
* Example csv were downloaded from here
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.