This way the special characters should be shown correctly. In the import wizard change the File_Origin to '65001 UTF' (or choose correct language character identifier).Ĭhange the Delimiter to comma (or any other sign that you would like to use). Select the file type of 'csv' and browse to your file. step 2 after opening the file go to file > save as. click on open and select the file from the computer that you want to save as a utf 8 encoded file. Step 1 to save a csv file as utf 8 encoded, follow the steps below: open libreoffice and go to files from the menubar. Import the data using Data->Import External Data -> Import Data Details: Convert excel to csv utf 8 format.
Please see the screenshot below that shows how MS Excel should import the data with Cyrillic characters:Īnd the detailed explanation regarding the same approach can be found here: 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.
