CSV tools for terminal? - command line

Looking for terminal tools to query / write to large CSV file efficiently, and also easy to interact (few simple commands or commands that resemble SQL query ...

Since I'm tying together various command line tools that have no concept of the CSV format, there are some contents that this does not handle well. For ...

csvkit is a suite of command-line tools for converting to and working with CSV, the king of tabular file formats. It is inspired by pdftk, GDAL and the original ...

Useful CSV inspection tools were critical here—and they had to be reasonably fast.) The key ingredients for helping me with my task were ...

Note: To use it independetly as a command-line tool, make sure you have ~/.local/bin in $PATH variable. Change to your home directory by: cd $HOME ...

... CSV files are handled properly by all the standard UNIX command line data tools. ... CSV parsing tool. If we used the ASCII delimiters ...

External programs are required to convert between SC format and CSV. The psc tool (CSV -> SC only) is installed with SC and works like so:

I am probably a little bit too late, but there is another tool worth mentioning: csvkit. It has a lot of command line tools that can:.

As somebody who used to work with massive amounts of CSV data, I highly recommend xsv, a command line csv processing tool that allows you to ...

Is there any tool to interact with CSV files similar to jq for json? Thanks.