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

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Table of Contents 

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.

Feedback
randomness