Easy Populate CSV: problem when open Complete File in excel

[henryvuong]

If anyone wants to look at my full tab-delimited file to help me out, you can download it here:

http://shockingprice.com/external/Full-EasyPopulate.txt

Save the file in text format and open it in excel, you'll see what I said.

[misty]

deleted..see post below

[misty]

File is correct EXCEPT there is NO unique model number
for EACH and EVERY product...also use Open Office...
works better with EP than Excel

[henryvuong]

I figured it out, it's the HTML tags "<TABLE> <TR> <TD>" that cause Excel to format the file incorrectly. I removed them and it works fine now.

Now I have another problem: the product description is truncated when opened with Excel. The maximum number of characters in each cell is 255. Most of my product description has longer length than that. How do I lift this limit? With this limit, the whole purpose of using Easy Populate is defeated because I cannot update product information with truncated description!

(I know my file lacks the product model, but I can work on it later.)

[henryvuong]

Well after wandering online for a few hours, I figure out Excel always has this problem when importing a text field longer the 255 characters, even though each cell can contain up to 32,767 characters.

But I found a simple solution for all the problems: use MS Access to import the file, then export it back to Excel (or I can just use Access to edit the info). With Access, I don't even have to remove the HTML tags.

Thank you all for your help.