Mac Excel won't recognize Spanish/Portuguese accents (UTF8 or ANSI) I'm working with Excel to open a delimited (tabbed) txt file that contains Portuguese and Spanish accents. As you can see below, in the third row there is a title "Último Año" that is correct.



However when I import the file into Excel the text is misinterpreted as "Ãšltimo AÃ±o".



The correct codepage would be Unicode UTF-8 or ANSI. I tried several options, like using the import file options from Excel to select UTF-8 (and other formats) but the result is always weird.



Does anybody know how to interpret/display the correct latin accents on Mac Excel?
After several bumps in the wall I figure out this Terminal command (Shell Script) that will convert properly the files from UTF-8 for Latin 1:

iconv -f UTF-8 -t LATIN1 &lt;/path/sourceFile.txt &gt;/path/destinationFile.txt

Oddly enough, the Finder preview won't display the correct characters and TextEdit won't even open the file. But Excel recognize everything, which is fine for me.