When I double-click and open a csv file in Excel, the OSX Excel always opens it in Macintosh format destroying the visualisation of UTF-8 files with malformatted umlaut characters such as ö and ä. I want to avoid opening files in OSX Excel in UTF-8 format by manually typing the UTF-8 format with options such as Import.

How can I change the default file option to UTF-8 in OSX so files can be opened in UTF-8, instead of Macintosh format, automatically even in the GUI and Finder?

Microsoft Excel for Mac: Version 15.30.

OSX: macOS Sierra, Version 10.12.1

Related questions in Superuser but not focus on OSX

  1. Change default encoding of Excel to UTF-8

  2. How to set character encoding when opening Excel

  • I don't think you can - you need to use get external data on the data tab. – Raystafarian Jan 27 '17 at 21:28

You must log in to answer this question.

Browse other questions tagged .