CSV Import from MS Excel

[kezzmania]

Hello everyone,

First, I wish to say thanks to Presta developers who are giving such a great web shop to us. Also greetings to users community. I'm reading here great advices which are helping me a lot.

 

 

Second, made this topic, because I have problem with CSV importing from Microsoft Excel. I downloaded example from my Presta store. Then I imported it in a few steps in my MS Excel: Blank document > Data > From Text > Delimited, UTF 8 > Next > Delimiters: " ; " (like it's in Presta, and also de-select other ones) and then finish. 

 

After pasting my clients in columns, I saved it in CSV (MS-Dos) format.

 

When I import it in Prestashop, I got it in wrong order, like this one on attached screenshot:

 

What am I doing wrong? Thanks in advance.

 

 

 

 

[sershio]

Try save your document to .xms, next try convert your file extension with a something tool in the web for convert .xms to .csv.

I work with this metodology.

Other, your name fields have a () try deleting this characters...

 

Good luck!

[kezzmania]

Thanks Sershio for this idea. I tried it, saved it in excel format *.xlsx, and then convert it with online tool to *csv, but still no luck. It gives me the same result. 

[msward]

I found that changing form ; delimited to , comma solved my problem, although I am exporting form Visual FoxPro not excel, it should be no different but the field never came in to the correct place when I tried ;.