Huge CSV file

[jrwrita]

Hey guys,

How can I deal with a huge CSV file? I need to extract some data but a lot of lag and freezing and errors, making it very hard to work with. When trying to copy and paste columns from it and paste into new worksheet I get errors, im guessing because the file is huge. Even when I try copy and pasting a small amount, it is efficinet as their are probably 200,000 rows. It is over 300 mb.
Any tricks to managing a file this size?

Any input would be appreciated.

 

[NilsMoon]

Hm is the file on a network? It might help putting it on your local computer then. Otherwise use databases like ms access?

 

[jrwrita]

Local meaning like saved to desktop? Yes it is saved to desktop atm.