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

Table of Contents 


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?


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:

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.