Set character encoding in MAC OS and Microsoft Excel

by okuoub   Last Updated October 14, 2018 14:01 PM

I have a csv with words in Hebrew. (It was generated with Python using df.to_csv(encoding='utf-8')) But the words are not presented good:

enter image description here

When open it in TextEdit, I see the Hebrew properly. I am using Mac OS High Sierra 10.13 and Microsoft Excel 16.16. Any ideas how to fix it?

Related Questions

Change default encoding of Excel to UTF-8?

Updated October 02, 2015 14:00 PM

Cyrillic export from Excel to CSV

Updated June 11, 2015 22:00 PM