To avoid the problem, use the Unicode encoding option when importing the data into Excel ... Save the file in the CSV format. In OpenOffice, change the Character Set setting to "Unicode (UTF ...

I can't get these accented chars to show up properly no matter what character encoding I choose from the dropdown in Excel. I tried saving the file with several different txt apps and the result ...

you can select one of these encoding options in which to save the file. If you do not choose an option, Notepad saves your document in its default ANSI format. A UTF-8 character is also a Unicode ...