I have a CSV file encoded with UTF-8, generated by myself on Mac, contains Chinese, English, and numbers. I can open it correctly with Mac text editor, VScode, Mac Numbers, and google forms. However, excel seems to have some issue with it, Chinese become some random characters.
I have tried and failed:
1. right click file -> open with excel
2. In excel, File -> Open...
3. In excel, File -> Import
4. In excel, Data -> acquire external data
I have read this article How to open UTF-8 CSV file in Excel without mis-conversion of characters in Japanese and Chinese language for both Mac and Windows and many other articles. Tried all the steps correctly, still failed.
The file I have is here https://drive.google.com/file/d/1gm3l6kKPWbNlmu-POvh8NKl0fHWFGA4A/view?usp=share_link. if you want to try it yourself.
I believe the standard procedure is helpless, and probably need to ask engineers to fix the bug. Or I missed something important.