csvkit

Command-line tools for converting and working with CSV files

brewmacoslinux
Try with needOr install directly
Source

About

Suite of command-line tools for converting to and working with CSV

Commands

in2csvcsvcutcsvgrepcsvlookcsvstatcsvjoincsvstackcsvformat

Examples

Convert Excel file to CSV$ in2csv data.xlsx > data.csv
Display specific columns from a CSV file$ csvcut -c name,email data.csv
Filter rows matching a pattern$ csvgrep -c status -m 'active' data.csv