1
Someone shared an Excel file with me (.xlsx, not .csv). Looking at the data in Excel it's obvious that the file is encoded using UTF-8, but Excel is interpreting the data as Windows 1252 encoded text. For example, where I expected to see 'ã' Excel displays 'ã' instead. 'ã' is U+00E3 which is 0xC3 0xA3 encoded as UTF-8, which corresponds to 'ã' in Windows 1252.
How can I reload the file, without changing it, and have Excel interpret the data as UTF-8 encoded text?
Michiel van Oosterhout
Posted 2019-01-15T12:45:28.783
Reputation: 658