5 ms·
I'm always astounded that there doesn't seem to be a decent general purpose CSV editor/viewer application. Excel is atrocious - it's always dog slow, and it ma
by thrower123 7y ago
I'm always astounded that there doesn't seem to be a decent general purpose CSV editor/viewer application. Excel is atrocious - it's always dog slow, and it mangles any CSV I've ever opened by trying to interpret the data to format it "smartly".
Having to build a table in a database and import the CSV into that feels a bit like hitting a house fly with a sledgehammer, but it's the most effective way I've seen.
- avmich 7y agoOne can convert CSV into JSON (a recipe is e.g. here - https://infiniteundo.com/post/99336704013/convert-csv-to-json-with-jq https://infiniteundo.com/post/99336704013/convert-csv-to-jso... ) - in streaming fashion - and then use jq ( https://stedolan.github.io/jq/ https://stedolan.github.io/jq/ ) to do what one needs.
- dbt00 7y agohttp://visidata.org/ http://visidata.org/ Is pretty fast if you’re comfortable in a terminal (not cli) app.
- phonon 7y ago> and it mangles any CSV I've ever opened by trying to interpret the data to format it "smartly". You should be using the Data -> From Text importer, not just double clicking. Also use the latest 64 bit version of Excel.
- zaphirplane 7y agoThere is csvkit and xsv and I’ve seen a few treat a csv file as a database projects around