How to Upload Data in Different Languages in Salesforce

Upload Data in Different Languages in Salesforce

Way 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

Not an “All Access” Pass Member Yet?

Get Download Access to this & 150+ More Step-by-Step Guides with “All Access” Pass. A simple and single plan to access our entire library of courses, guides, workshops & masterclasses on Salesforce.

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

Leave a Comment

Your email address will not be published. Required fields are marked *

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

Scroll to Top
Introducing All Access Pass