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

Forum Moderators: open

Message Too Old, No Replies

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

Excel is limiting my froogle feed

BennyBlanco

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

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

jdMorgan

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

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

Jim

rise2it

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

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.

eWhisper

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

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.