4GB CSV file won't open in excel :(
 

I have a 300k line 4GB CSV file that will not open in neither excel 2003 or 2010. I double click or file open it and excel will just open up a blank DB. Any advise? Won't open in notepad either. I am thinking I can open it in a better text editor and copy and paste it in quarters but there must be an easier way and this will cause problems when I save it and reopen it. Hope someone can help.

How much RAM you got?

split the file into multiple parts

Also maybe try in open office

Excel has a limit of about 65k lines (2^16). Look it up. I found it out a few weeks ago. annoying but true.

Import it into a relational DB, make your changes then export back to CSV (if you must).

I have 8GB ram, I5.

Excel 2010 can open a million rows apparently.

How do I split the file into multiple parts?

How do i do this?

Google "CSV splitter"

Ultraedit or notepad++

An easy to use splitter
It's a zipped exe but the source files are easy to scan.
downloads/csv-splitter-1.1.zip

thx will try those

Something like this.

http://www.tech-recipes.com/rx/2345/...ly_into_mysql/

are you using the 32 bit excel ?

i think there is a 2 gig file limit on the 32 bit.

edit plus, csv splitter, notepad++ = fail

trying ultraedit, currently loading.

think i am using 32bit yes.

Send it to me let me try. 24 gig ram and 64bit system.

ultraedit will open massive files :thumbsup

Use Microsoft Access to open the database.

notepad++ :thumbsup:thumbsup:thumbsup

32 bit system here, 4gb ram, i5, so almost identical. I've opened 10GB in ultraedit before.

I know you have full excel but maybe you could try a lightweight version - excel viewer or smth..find it on google..

ok, now I seriously hate you - wtf!!!! this must be a monster machine

Why in the world would you ever want to open a 4GB CSV in Excel?

I'd recommend importing it into a relational DB if you want to actually be able to DO anything with it, LOL

If you want I can write a quick script for a few bucks to split the 4GB file into 10 smaller files... icq: 33375924

try ultraedit. That's what I use when handling big files.

notepad++ opened it but froze for a few minutes everytime I tried to copy a portion of it. and I can only copy 2 or 3% of it without getting a too big for clipboard message, not going to copy it into 50 pcs. So theres no other program other than csv splitter that will split this into 4 pcs? CSV splitter split it into 1 467 kb file.

Try CSVed. I have used it for csv files 1gig +

CSVEd :thumbsup:thumbsup