Welcome to WebmasterWorld Guest from 54.145.173.147

Forum Moderators: open

Message Too Old, No Replies

I Need More Than 65k Rows, What Can I Use?

Excel is limiting my froogle feed

   
4:32 pm on Dec 13, 2005 (gmt 0)

10+ Year Member



Hey Guys,

We have about 200k products to upload and I am stuck at the Excel limit of 65k rows. Can anyone tell me what program I should use to open up more space? Notepad doesn't have the resources for this sort of amount of data and I heard that OpenOffice allows more, but I downloaded it and it didn't.

Can anyone help?

Thanks,

Benny

6:04 pm on Dec 13, 2005 (gmt 0)

WebmasterWorld Senior Member jdmorgan is a WebmasterWorld Top Contributor of All Time 10+ Year Member



The new Office 12 Excel is said to support millions of rows, if that helps.

Jim

7:18 am on Jan 8, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Yeah, there are limits to different versions of excel. Thank sounds like the limit for Excel97 or so.

Even the one from Office 2000 (which you can pick up cheap) may solve your problem - someone else feel free to correct me if I'm wrong.

4:05 pm on Jan 8, 2006 (gmt 0)

WebmasterWorld Administrator ewhisper is a WebmasterWorld Top Contributor of All Time 10+ Year Member



office 2003 is limited to 65kish rows.

notepad is unlimited (although CSV or tab deliniated) are difficult to use in that format.

What I usually do (in notetab pro) is have hidden characters on (so can see the tabs, or other characters), word wrapping off (so one product per column) and work with it that way.

The other option is to work with 65k products at a time in excel, export the list to the proper format, and then paste the completed lists into a single notepad file.