import CSV file has chinese characters garbled

There is a simple option if you use Excel yourself to do your lists to then export as a CSV file…

Make your Excel file…

Don’t save it simply as a CSV file…

Otherwise it will be displayed with the substituted characters if you then open that CSV file again in Excel or Notepad or something else…

So, save it as UTF-8 CSV…

And this happens when you then open that UTF-8 CSV file again in Excel or in Notepad or something else…