Be advised that ISO-8859-1 is missing some characters from WINDOWS-1252 as shown here: | Char | ANSI | Unicode | ANSI Hex | Unicode Hex | HTML entity | Unicode Name | Unicode Range | This encoding is a superset of ISO-8859-1 (aka LATIN1 and others), so you can fallback to ISO-8859-1 if you cannot use WINDOWS-1252 for some reason. Both versions at least include a corresponding 'File origin' or 'File encoding' selector which correctly reads the data.ĭepending on your system and the tools you use, this encoding could also be named CP1252, ANSI, Windows (ANSI), MS-ANSI or just Windows, among other variations.
Since its basically Microsofts own proprietary character set, one can assume it will work on both the Mac and the Windows version of MS-Excel.
I found the WINDOWS-1252 encoding to be the least frustrating when dealing with Excel.
