Import CSV using MS Excel - seperate fields?

[wackyracer8]

I've exported my demo content from my store and it puts each product in one field like so;

4;"http:jpg";"Printed Dress";"demo_4";"Evening Dresses";"50.994153";"61.19";"900";"1";

I have seen other people have each title in a separate field within Excel, making it a lot easier to manage. See below. Can this be done with the Prestashop import/export? and if so how would I go about it?

 

[shokinro]

If you exported to CSV format, you should be able to open with MS Excel.

I guess the data you export is in different format of CSV. it seems the separator is different from your sample data.

 

Please try to replace ";" with "," of your data by using general text editor such as note pad. and try again to use Excel, it should be fine.