Cyrillic Letters do not work with CSV import HELP

[Tip-C]

One of the fields (short description) I use for my product is written in Cyrillic Letters. The problem is when the CSV file is imported into presta shop i get a bunch of question mars: "??????? ???:"

How can I import the text so that it remains in Cyrillic letters.

Thanks

[Tip-C]

bump...Can anybody help me out?

[Tip-C]

bump...

[Tip-C]

I finally found the solution on another forum.

Here it is if it may help anybody else:

UTF8 CSV files.
We're getting lists to be imported into MySQL in Excel (.xls) formats.
When we use MS Office to export it into CSV,
reading the data gives us gibberish, because
the default encoding is plain old ASCII.

There is not obvious setting available to change the ASCII to UTF8
for the csv file in Microsoft Office.

So I tried Open Office to see if it offers anything better.
In Save As, Change the Type to CSV, then the 'Edit Filter Settings'
checkbox will be enabled. Check this, and when you click save,
a dialog will appear requesting which Character Set to use.

And sure enough, it works like a charm.
The CSV loads up and saves into MySQL OK.

Hooray Open Office. Works better for multilingual requirements.

BTW, if anyone has the solution to export as UTF8 CSV from
MSOffice, please post it here.

yk

[Jorkoo]

Here is a way to open csv file with excel,

1. Rename the original file from something.csv to something.csvv
2. open excel, click Open file, for file type choose (All files - star.star) (*.*)
3. A wizard pops up, choose next
4. Choose Delimiters : Comma
5. Click Finish

I've made screenshot animation to show you what the steps are.

Link to screenshots - Open CSV as UTF8 with excel



I've even attached it to the post.