Importing Products with HTML Descriptions

I’m trying to import products from another store. The description field contains HTML formatting that I’d like to keep. On my first attempt, the description field was NOT imported. Does anyone have a tip to make this work?

Here’s a tip, but it’s tricky…



Open Office is easier to work with than Excel for this type of procedure. Sometimes you have to do a search and replace to deal with the quotation marks, which is the biggest problem.



I start by building a spreadsheet in Open Office. I can usually import the “easy” data such as SKU and price. Description is the real issue.



Sometimes “description” imports OK, other times not. I can’t tell you why it works differently sometimes, but it’s the combination of commas and quotation marks I guess.