Forum Discussion

Vittorio175's avatar
Vittorio175
Copper Contributor
Nov 27, 2019

open and edit a CSV file in UTF8

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...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 27, 2019

Vittorio175 

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.

  • fdgfd's avatar
    fdgfd
    Copper Contributor
    Jan 04, 2021

    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 https://www.sqlitetutorial.net/sqlite-tutorial/sqlite-export-csv/ 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 🙂

  • Vittorio175's avatar
    Vittorio175
    Copper Contributor
    Nov 27, 2019

    SergeiBaklan  sounds good, thanks for the tip.

    Have a good day !

    Victor

Resources