How to Upload Data in Different Languages in Salesforce

(This blog post was originally written in July 2012. It has now been updated with a more simplified process, screenshots with the step-by-step guide and option to download the PDF)

Upload Data in Different Languages in SalesforceWay back in 2012, while working on a project, I had the requirement of uploading data containing Chinese, Thai, Vietnamese etc. characters in Salesforce. The data to be uploaded was available in Microsoft Excel format. However from Excel, when I tried to save the data in CSV format a lot of characters were converted to ‘ ? ‘ (question mark) resulting in the loss of data. Earlier Excel did not allow us to specify the encoding of the CSV file (when this blog post was originally written back in 2012).

So here is the revised solution to this kind of requirement:

  1. Once you have the data in Excel format, save the file as ‘CSV UTF-8 (Comma delimited)’ (this option is available in Excel)
  2. Launch the Data Import Wizard in Salesforce and select your file to Import and the Encoding in the drop-down list. This could be either in UTF-8 or UTF-16 format, depending on the selection you used when saving the CSV file.
  3. Import data in Salesforce from the CSV file

To get the PDF copy of the presentation above (link to download the PDF will be emailed to the email address specified below)

Check to subscribe and get notified for new guides

(You'll never be spammed on my watch and that's a promise)

1 thought on “How to Upload Data in Different Languages in Salesforce”

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top