Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
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?
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.