How to: format descriptions of product imports

Hi,

Currently sussing out the file import file, and am struggling with getting the text descriptions to drop onto multiple lines.

Can this be done? or do I have to upload it, then format it?

Thanks

any chance of doing it from within an excel csv?

tried via text field too... got the following error...

.

thanks
i'll check it out in a few days...

Have a happy Christmas

with the csv import... how do I get text on the next lines... i did the usual "alt+enter" ... but this doesn't work
**** EDIT***
this does move the lines down on execl... but not when imported.


also, even when using the text editor / imort it still puts them all on the same line.


****** The text i was trying to import *******

product_code,product_description,categories
testnew1,"my
product
description
on
several
lines",11

**********************************************

sorry yes I meant I put the text on more lines in excel, but didn't work on the import.

no error, it just didn't split the lines.
i'll do it now.

my csv file has all the fields... but not populated yet as i'm just trying to get it worked out before I start putting in data.

product_parent_id,product_name,product_description,product_quantity,product_code,product_published,product_hit,product_created,product_sale_start,product_sale_end,product_delay_id,product_tax_id,product_type,product_vendor_id,product_manufacturer_id,product_url,product_weight,product_keywords,product_weight_unit,product_modified,product_meta_description,product_dimension_unit,product_width,product_length,product_height,product_max_per_order,price_value,price_currency_id,price_quantity,files,images,categories,related,size
,testnew,"""my description
on multiple
lines""",,testnew2,yes,,,,,,,,,,,0.1,,,,,,,,,,12,,,,thumbnail/umm.jpg,10,,



hmmm... it appears there is extra quote marks around the text...
i'll try removing this

I got rid of the "s from the csv... so the code is now this...


product_parent_id,product_name,product_description,product_quantity,product_code,product_published,product_hit,product_created,product_sale_start,product_sale_end,product_delay_id,product_tax_id,product_type,product_vendor_id,product_manufacturer_id,product_url,product_weight,product_keywords,product_weight_unit,product_modified,product_meta_description,product_dimension_unit,product_width,product_length,product_height,product_max_per_order,price_value,price_currency_id,price_quantity,files,images,categories,related,size
,test3,"my description
on multiple
lines",,testnew3,yes,,,,,,,,,,,0.1,,,,,,,,,,12,,,,thumbnail/umm.jpg,10,,


but.... this doesn't work either....

wow thats weird... i just checked the csv file, and there is no space in images.

when i paste the file text here... there is no space,

but once submitted, the space appears.

when pasted in the "import from text area" with no space in images, it doesn't split them.. i'll try using html

ok so back to it after the break, I hope you have had time to relax.


this is what i'm getting at the moment... before even trying to get it right in the .csv file.
This is the text import I tried.


.

gives me this.. which is correct,

.

But is displaying this.....

.

same result.

Sorry to be such a pain.