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

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
Answer
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 
-----------------------

* Beware of scammers posting fake support numbers here.

* Kindly Mark and Vote this reply if it helps, as it will be beneficial to more community members reading here.

17 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated September 19, 2021 Views 10,804 Applies to: