So I have been trying EVERYTHING I can to get the product import tool to work and import HTML and it seems that no matter what I try, it fails.

Here is what I am doing:

Export list of all products, save as text file.
Import text file to Excel and trim down to only one item (for testing purposes to make it simple)
Add HTML code from Dreamweaver to either the PreTransformLongDescription or the LongDescritpion cell.
Save Text File.
Import

Every time I do this, it errors out and it seems to be because the cell has Returns in it. For example, if my HTML document has 10 lines in it, the import tool tries to import 10 new products (even thought all the date is in ONE cell) and errors out on every one of them. I have tried turning on text Wrap in that cell and it does not seem to help.

Is there any way around this? It seems like such a major issue but I have not found anyone having the same trouble on the board.

I have 180 products patiently waiting to be added to my site but I CANNOT FIGURE THIS THING OUT and it is driving my insane.

Do I need to somehow remove all the 'Returns' from the HTML code?

Please help!