Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Viewing a very large CSV file?

Tags:

database

csv

I have a very large 3.5 GB CSV file that I'd like to be able to read, sort through and filter for results based on various inputs. I'm pretty sure I can just import it to a MySQL database and go from there, but is there any program or online tool available that involves simply uploading the CSV and the rest is automatic?

like image 287
David michael Avatar asked Nov 12 '13 18:11

David michael


1 Answers

Yes, there is.

You can use OpenRefine (or Google Refine). OpenRefine is like a spreadsheet on steroids.

The file size that you can manipulate depend on your computer's memory.

like image 149
Estevão Lucas Avatar answered Sep 20 '22 12:09

Estevão Lucas