Miller CLI – Like Awk, sed, cut, join, and sort for CSV, TSV and JSON
I always use sqlite3 for working with large CSV files:<p><pre><code>    $ sqlite3
    $ .mode csv
    $ .import my.csv foo
    $ SELECT * FROM foo WHERE name = 'bar';
</code></pre>
It reads the header in automatically for the field names and then stores all the values as strings.