4GB CSV file won't open in excel :( - GoFuckYourself.com

mkx · 10-03-2010, 07:52 PM

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.

Tube Ace · 10-03-2010, 07:56 PM

How much RAM you got?

tical · 10-03-2010, 07:56 PM

split the file into multiple parts

Adam_M · 10-03-2010, 07:59 PM

Also maybe try in open office

Kevin Marx · 10-03-2010, 08:01 PM

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

Babaganoosh · 10-03-2010, 08:13 PM

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

mkx · 10-03-2010, 08:14 PM

I have 8GB ram, I5.

Excel 2010 can open a million rows apparently.

How do I split the file into multiple parts?

mkx · 10-03-2010, 08:15 PM

Quote:

Originally Posted by Babaganoosh

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

How do i do this?

tical · 10-03-2010, 08:21 PM

Quote:

Originally Posted by mkx

I have 8GB ram, I5.

Excel 2010 can open a million rows apparently.

How do I split the file into multiple parts?

Google "CSV splitter"

ladida · 10-03-2010, 08:21 PM

Ultraedit or notepad++

HighEnergy · 10-03-2010, 08:25 PM

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

mkx · 10-03-2010, 08:29 PM

thx will try those

Babaganoosh · 10-03-2010, 08:33 PM

Quote:

Originally Posted by mkx

How do i do this?

Something like this.

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

sandman! · 10-03-2010, 08:37 PM

are you using the 32 bit excel ?

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

mkx · 10-03-2010, 08:48 PM

edit plus, csv splitter, notepad++ = fail

trying ultraedit, currently loading.

think i am using 32bit yes.

tiger · 10-03-2010, 10:24 PM

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

papill0n · 10-03-2010, 10:47 PM

Quote:

Originally Posted by ladida

Ultraedit or notepad++

ultraedit will open massive files

InfoGuy · 10-03-2010, 11:43 PM

Use Microsoft Access to open the database.

v0id · 10-04-2010, 01:48 AM

Quote:

Originally Posted by ladida

Ultraedit or notepad++

notepad++

ladida · 10-04-2010, 03:23 AM

Quote:

Originally Posted by mkx

edit plus, csv splitter, notepad++ = fail

trying ultraedit, currently loading.

think i am using 32bit yes.

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

adult-help · 10-04-2010, 04:41 AM

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

Antonio · 10-04-2010, 06:01 AM

Quote:

Originally Posted by tiger

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

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

BestXXXPorn · 10-04-2010, 06:37 AM

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

woj · 10-04-2010, 07:01 AM

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

u-Bob · 10-04-2010, 07:04 AM

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

mkx · 10-04-2010, 07:04 AM

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.

Helix · 10-04-2010, 08:21 AM

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

Kolargol · 10-04-2010, 08:38 AM

Quote:

Originally Posted by Helix

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

CSVEd

10-03-2010, 07:52 PM	#1
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	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.

10-03-2010, 07:59 PM	#4
Adam_M Confirmed User Industry Role: Join Date: Mar 2006 Location: Australia Posts: 3,796	Also maybe try in open office __________________ DiscountedPorn.Com ReviewedPorn.com

10-03-2010, 08:01 PM	#5
Kevin Marx Confirmed User Join Date: Apr 2007 Location: Phoenix, AZ Posts: 1,888	Excel has a limit of about 65k lines (2^16). Look it up. I found it out a few weeks ago. annoying but true. __________________ ICQ: 370 037 008

10-03-2010, 08:13 PM	#6
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	Import it into a relational DB, make your changes then export back to CSV (if you must). __________________ I like pie.

10-03-2010, 08:21 PM	#10
ladida Confirmed User Join Date: Nov 2005 Posts: 2,167	Ultraedit or notepad++ __________________ agentGFY at gmail.com

10-03-2010, 07:56 PM	#2
Tube Ace So Fucking Banned Industry Role: Join Date: Nov 2008 Location: with your dream girl Posts: 4,941	How much RAM you got?

10-03-2010, 07:56 PM	#3
tical Confirmed User Join Date: Feb 2002 Location: Las Vegas Posts: 6,504	split the file into multiple parts

10-03-2010, 08:14 PM	#7
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	I have 8GB ram, I5. Excel 2010 can open a million rows apparently. How do I split the file into multiple parts?

10-03-2010, 08:25 PM	#11
HighEnergy So Fucking Banned Join Date: Apr 2007 Posts: 806	An easy to use splitter It's a zipped exe but the source files are easy to scan. downloads/csv-splitter-1.1.zip

10-03-2010, 08:29 PM	#12
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	thx will try those

10-03-2010, 08:37 PM	#14
sandman! Icq: 14420613 Industry Role: Join Date: Mar 2001 Location: chicago Posts: 15,432	are you using the 32 bit excel ? i think there is a 2 gig file limit on the 32 bit. __________________ Need WebHosting ? Email me for some great deals [email protected]

10-03-2010, 08:48 PM	#15
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	edit plus, csv splitter, notepad++ = fail trying ultraedit, currently loading. think i am using 32bit yes.

10-03-2010, 10:24 PM	#16
tiger Confirmed User Industry Role: Join Date: Apr 2002 Location: Los Angeles Posts: 6,986	Send it to me let me try. 24 gig ram and 64bit system. __________________

10-03-2010, 11:43 PM	#18
InfoGuy 80/20 Rule Industry Role: Join Date: Apr 2010 Location: Los Angeles Posts: 3,051	Use Microsoft Access to open the database. __________________ Support American Heroes \| How Bad is My Batch? \| Vaccine Deaths & Adverse Reactions \| Free Speech Coalition \| <WARNING> ePayService / Guerra Capital, INC / MTACC payments \| Flirt4Free Fucks their Affiliates \| Don't do business with piece of shit Andy Alvarez from Webmaster Central / VR3000, who said: "If it was up to me, they would have shot all 30,000 of those country loving shitheads"

10-04-2010, 04:41 AM	#21
adult-help Confirmed User Industry Role: Join Date: Mar 2008 Posts: 2,450	I know you have full excel but maybe you could try a lightweight version - excel viewer or smth..find it on google.. __________________ Adult web templates, Adult WordPress Themes, TGP, MGP.. also Complete Wordpress PaySite Development - Adult WordPress Blog Themes - Free FHG Templates - Free PaySite Script - Adult Tutorials Directory - Adult Domain Marketplace - Adult Jobs

10-04-2010, 06:37 AM	#23
BestXXXPorn Confirmed User Join Date: Jun 2009 Location: Asheville, NC Posts: 2,277	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 __________________ ICQ: 258-202-811 \| Email: eric{at}bestxxxporn.com

10-04-2010, 07:01 AM	#24
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	If you want I can write a quick script for a few bucks to split the 4GB file into 10 smaller files... icq: 33375924 __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

10-04-2010, 07:04 AM	#25
u-Bob there's no $$$ in porn Industry Role: Join Date: Jul 2005 Location: icq: 195./568.-230 (btw: not getting offline msgs) Posts: 33,063	try ultraedit. That's what I use when handling big files.

10-04-2010, 08:21 AM	#27
Helix Confirmed User Join Date: Feb 2002 Location: Michigan Posts: 5,958	Try CSVed. I have used it for csv files 1gig + __________________ Free jscott !!! Free OneHungLo !!! Free Baddog !!!