A Tip A Day #13 – Data Load Non-English Characters into Salesforce

This post is a part of the daily blog series 

A Tip A Day, daily dosage of learning!

 Day #3 – Data Load Non-English Characters

If your csv file has Non-English characters (eg: Chinese characters) to data load into Salesforce.  Then are 2 settings you need to set for that data to load into Salesforce otherwise the data will be lost.

• Change the CSV file format to CSV UTF-8.  Open the csv or excel file, File–> Save as –> choose CSV UTF-8 (Note this is also .csv but just the encoding is different)

• Change Apex Data loader Settings: In Apex Data loader, open Settings–> and check these 2 checkboxes.  Read/Write all CSVs with UTF-8 encoding.

Read all other tips of the blog series here – A Tip A Day, daily dosage of learning!