How to open UTF-8 CSV file in Excel without mis-conversion of characters in Japanese and Chinese language for both Mac and Windows?

Question

Could you please guide me on how to open a UTF-8 CSV file in Excel without garbled Japanese text in both Windows and Mac environments? Thank you.

Answer 1

Hi Ankit Abhinav (aabhinav),

Based on your description, you want to open CSV files which have UTF-8 coding from Excel on Mac and Windows. Here are the steps:

Excel on Mac: please refer to this official article: Import data from a CSV, HTML, or text file.

Excel on Windows:

1. Open Excel, search "Get Data From Text" to open a wizard when you want to open a CSV file.
2. Go to the location of the CSV file, that you want to import.
3. Choose Delimited, set the character encoding to 65001: Unicode (UTF-8) from the dropdown list.
4. Check My data has headers. You have to use it because the first row of CSV file has column names.
5. Click next to display the second step of Text Import Wizard.
6. Because our data is separated by commas, set the delimiter to a comma.
7. Click next to move to the third step.
8. Select the General column and then Finish.
9. Keep the default values inside the Import Data window and click OK.

If you still have problems on it, please feel free to post back.

Best regards,

Jazlyn

Answer 2

Hi Ankit Abhinav (aabhinav),

Can you open CSV file with UTF-8 in Excel successfully now?

Best regards,

Jazlyn