VisiData
I deal with columnar data regularly. and I recently found a tool called VisiData. This is one of the most useful things I've ever used, and so I wanted to make sure to mention it.
It's a bit difficult to describe. I found it to be something of a swiss army knife of a tool for csv, tsv, sqlite databases, json exports, pretty much any data set.