If you prefer working from the terminal, you should check out VisiData (https://github.com/saulpw/visidata). It's a curses tabular data tool that can start browsing terabyte .csv files immediately, with few dependencies and no clicking.
Been using this daily. Great tool. I almost forgot the awk commands :) BUT I still love awk!
I was looking through the comments hoping to find a tool like this. You did not let me down, fellow HNer! I try to use the command line whenever I can. Somehow there is a command line tool for just about everything, except for the obvious cases where it not useful like visual media and graphs.
I don't want to dissuade you if curses-based UIs are your thing. But one thing that's been crucial to me from Day 1 is that you can type "tad foo.csv" at the command line and immediately get a usable view of your data with no extra config or tweaking needed. I mostly launch tad from the command line.
I just launched "tad 311_Service_Requests_from_2010_to_Present.csv" (a 10GB dataset from data.cityofnewyork.us) and it ate up all my memory without ever showing any data. "vd 311_Service_Requests_from_2010_to_Present.csv" shows the first rows instantly, and I can start rearranging columns while it is still loading, and I can press Ctrl-C to stop the load (and the rows already loaded are still available). No config or tweaking needed.