Thread: Problem with description format when uploading excel csv file

Hi all,
This is my first post on this forum. I am having a problem with the format of my descriptions when I import an excel file. It seems that the line breaks in my excel file are automatically deleted when they go through the system. This is what I want it to look like:
"AIR WICK" SCENTED OIL REFILL
*Calming Magnolia and Cherry
*Glass fragrance bottle with quick snap for easy installation
*Depending on setting can will last for up to 60 days
*Use Airwick warmer only (Sku no. 1338763)
*Help creates the desired mood in any room, family room, bedroom and bathroom
*Boxed

This is what I am getting:

"AIR WICK" SCENTED OIL REFILL *Calming Magnolia and Cherry *Glass fragrance bottle with quick snap for easy installation *Depending on setting can will last for up to 60 days *Use Airwick warmer only (Sku no. 1338763) *Help creates the desired mood in any room, family room, bedroom and bathroom *Boxed

Thanks to anyone who can help.

Could you paste the HTML code you're using? If you're just typing each listing on its own line in the spreadsheet cell, I don't think that works. You can force a linebreak like so:

Code:

"AIR WICK" SCENTED OIL REFILL<br>
*Calming Magnolia and Cherry<br>
*Glass fragrance bottle with quick snap for easy installation<br>
*Depending on setting can will last for up to 60 days<br>
*Use Airwick warmer only (Sku no. 1338763)<br>
*Help creates the desired mood in any room, family room, bedroom and bathroom<br>
*Boxed

Try wrapping them in bullet points

Example

<ul>
<li>Bullet point</li>
<li>Bullet point</li>
<li>Bullet point</li>
</UL>

I am adding about 2000 items at a time through excel in .xls format. Are you saying that I have to upload in xlm format? How do you upload in bulk in html? Forgive my newbness.

You will upload in .xls (Excel Spreadsheet) format, as you have been. This really has nothing to do with XML (That's a different monster).

You will need to use HTML to format your text inside the .xls file. Skriver's suggestion to use an unordered list is probably your best bet. Paste that HTML code into your spreadsheet cell, and once it is imported, the storefront knows to format the text using your HTML. It doesn't know how to format text using Excel Spreadsheet formatting.

Thank you for everyone's help. Just to make sure i'm implementing it correctly here's one I did:
<ul>"LUNDMARK" ANTI-SLIP ALL-WAX

<li>Self-polishing pure Carnauba<li>

wax, dries to a high gloss

<li>For floors in school & office<li>

buildings

<li>Black heel mark resistant<li>

<li>*Waterproof<li>

<li>Plastic bottle<li>

<li>Qt.<li>
</UL>

Only a few problems with the syntax of your HTML, you'll want to use closing tags around list items.

At the beginning of the list item:

Code:

<li>

At the end of the list item:

Code:

</li>

Also, I normally don't put the title of the description inside the UL tag. This might give you a better effect:

Code:

"LUNDMARK" ANTI-SLIP ALL-WAX
<ul>
<li>Self-polishing pure Carnauba wax, dries to a high gloss</li>
<li>For floors in school and office buildings</li>
<li>Black heel mark resistant</li>
<li>*Waterproof</li>
<li>Plastic bottle</li>
<li>Qt.</li>
</ul>

Check out http://www.w3schools.com/ for some simple HTML tutorials.

Worked Great! Thanks for the help, I really appreciate it