I need to use Unicode (UTF-8) encoding charset on Excel365 with Mac OS. How can I set that in Preferences?

Hi @Sukru Alemdar Based on the information you provided, I understand that Turkish characters are displaying incorrectly when you open external CSV files directly in Excel for Mac, even though they appear correctly in Word 365 using UTF-8 encoding.

I’ve tested this in my own environment and found that Excel for Mac often struggles to automatically detect the correct encoding when a CSV file is opened directly. To fix this, you can use the Power Query method, which gives you manual control over the encoding.

Instead of double-clicking the file to open it, follow these steps:

1. Open a blank workbook in Excel.
2. Go to the Data tab in the top ribbon.
3. Click on Get Data (Power Query).
4. Select Text/CSV.
5. Choose your external CSV file and click Get Data.
6. In the preview window that appears, look for the File Origin dropdown menu.
7. Select 65001: Unicode (UTF-8) (or Turkish Windows/Mac if UTF-8 isn't automatically recognized).
8. Once the characters look correct in the preview, click Load.

In my testing, this method successfully preserves Turkish characters and prevents the encoding errors you're seeing. It treats the data as a proper import rather than just a "quick open," which is much more reliable for UTF-8 files.

Please give that a try and let me know if those characters are finally behaving themselves!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.