Why some text characters displayed incorrectly in the exported CSV file?
Analytics, Site Configuration
Oracle Service Cloud all versions
By default, all CSV files created in ANSI encoding and that may affect how non-English characters are displayed while viewing the file.As for example ANSI apostrophe, the one that is used in English [ ' ] will look normally as oppose to UTF-8 (mostly used in non-English languages) apostrophe [ ’ ] which will be displayed as "â€™".
And there is no option to select the file encoding during the export; however, encoding can be changed once a file is generated.
To change the file encoding simply open it in "notepad" select File > Save As. At the bottom of the dialog window change encoding from ANSI to UTF-8 and save it as a new file.