open and edit a CSV file in UTF8

New Contributor

Hello all,

I'm "just" trying to EDIT a CSV UTF 8 encoded file, using Excel for Office 365, but can't find out how to proceed. it's insane I used to do that a lot in the past

All I see on the web is using the "convert" functionality but in my version the "Origin" option containing encoding methods has disappeared, so it will not help.

Also, in the DATA module there is an option to import CSV data and set the encoding to UTF8 but it will import the list as a datasource, for querying or data analyst, creating specific layout with colors, headers...

Isn't there an option just to open the CSV in UTF 8 and save it as it is ?

thanks a lot


4 Replies


If insert content of the CSV file into the Excel sheet you may use Power Query or enable legacy wizard


after that


and wizard shows the options



If open CSV file it shows the same wizard. If to save encoding shall be in Save As types


All above is for Office365 Excel on Windows.

@Sergei Baklan  sounds good, thanks for the tip.

Have a good day !



Victor, you are welcome

Thank you, this is the best way for me without having to have Open/Libre office installed, open it there and save to xlsx (saving to ODF and opening that in Excel would probably work too.



I was following the tutorial at and the sample (chinook) database contains Unicode characters that show up garbled when I open the CSV file I exported from sqlite3. Inserting the data with this method allows me to get the correct encoding and have names such as Bjørn and Gutiérrez appear correctly