How to import CSV document with cyrillic symbols to Excel and correctly render them in this program

Question:

I have exported my document to CSV. When I open it in text editors Cyrillic symbols are rendered correctly, it seems that the problem is only when I open CSV document  in MS Excel. How to fix this?

Answer:

Please see the screenshot below that shows how MS Excel should import the data with Cyrillic characters:

And the detailed explanation regarding the same approach can be found here: http://stackoverflow.com/questions/6002256/is-it-possible-to-force-excel-recognize-utf-8-csv-files-automatically

In short:

• Save the exported file as a CSV,

• Open Excel

• Import the data using Data-->Import External Data --> Import Data

• Select the file type of "csv" and browse to your file.

• In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier).

• Change the Delimiter to comma (or any other sign that you would like to use).

• Select where to import to and Finish.

This way the special characters should be shown correctly.