On: How To Open and Manipulate Large CSV Files On A Ma...

[gav]

SQLite does a great job of importing CSV, and then you're able to use something like "DB Browser for SQLite"[1] to browse the data.

I use something like this to fix up column names and import:

    sed -i '' -e '1 s/ \/ /_/g; 1 s/[() ]/_/g' $csv_file
    sqlite3 $db_file <<SQL
    .mode csv
    .import $csv_file $table_name
    SQL

[1] https://sqlitebrowser.org/

[alecdibble → gav]

Amazing, I will definitely try this out. Thank you!