1

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.

enter image description here

However when I import the file into Excel the text is misinterpreted as "Último Año".

enter image description here

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.

enter image description here

Does anybody know how to interpret/display the correct latin accents on Mac Excel?

  • UTF-8 utf8-chartable.de/unicode-utf8-table.pl – Ruskes Nov 12 '18 at 17:57
  • @Buscar yeah that one, I just need Excel to use it... – Mateus Ribeiro Nov 12 '18 at 19:16
  • does it works if you try to Insert a Symbol and choose yours ? – Ruskes Nov 12 '18 at 19:31
  • @Buscar웃 yes the input is fine, I can type all characters, no problem. Its an import issue. Maybe I can create an autocorrect table for the weird entries and run it as a workaround. – Mateus Ribeiro Nov 12 '18 at 19:46
0

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 </path/sourceFile.txt >/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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .