This Excel tutorial explains how to import Chinese CSV to Excel with correct encoding. (解決CSV轉EXCEL亂碼)
You may also want to read:
Export Chinese Excel to CSV
Excel VBA Import CSV into Excel using Workbooks.OpenText Method
Excel VBA convert CSV to Excel
Import Chinese CSV to Excel
When you import Chinese CSV to Excel, some Chinese characters will become a question mark "?" or convert to unexpected Chinese characters, same will happen for symbols and other languages such as Japanese,...
Read More