- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Chinese characters exported using developer tool is un-readable
Problem: I have manually created some products and rate plans in this tenant. The product name and rate plan names are in Chinese. When I export them using developer tool, they are un-readable.
Solution:
The text changes to un-readable format due to the MS excel formatting condition.
We were able to change the un-readable text into Chinese text, please follow the steps provided below.
Step 1: Open the file in Excel and go to the Data -> Get Data -> From File -> From Text/CSV
Open the Same file Again in the Pop-Up window
Step 2:Select Unicode (UTF-8) in the File origin
Step 3:
Once selected you will see the format change in the field, Click on load and save the sheet in the format - CSV UTF-8 (Comma delimited)(*.csv)
Note : If suppose you are trying to make changes in the file and uploading it again in the API loader, we suggest you use the Text Editor instead of excel and save the file in .csv format.