Step 1:  Open Excel and go to the "Data" tab

Step 2: Look for the "Get & Transform Data" section and click on "From Text/CSV"

Step 3: In the "Import Data" dialog box, navigate to the location of your CSV file and then click "Import"

Step 4: If the data appears in an unknown format or code, click on "File Origin" to choose the right language.

For example, this .CSV file is in Taiwan Chinese language, and you can choose Chinese Traditional in File Origin field.

Step 5: After choosing the correct language, click "Load".

You successfully imported a .CSV file containing data in the correct language.