I export Salesforce data out to CSV on a frequent basis especially in a foreign language like Mandarin.

Even if I check the UTF-8 options on Dataloader settings :

enter image description here

The file that gets exported out from Dataloader is a file without any extensions. What I usually do is rename the file to append '.csv'. But to my surprise all the Chinese characters end up becoming like 'å®æ³¢é¦™æ ¼é‡Œæ‹‰å¤§é…’店'

So I have to do the lengthy way of opening up a blank Excel -> go 'Data' tab -> From Text/CSV -> Choose the file I want to format. Then I noticed that the file churned out by dataloader is always Western European.

enter image description here

Any ideas how to default the files churned out by Dataloader to UTF-8?

Dataloader version : 45.0.0

1 Answer 1


You need to change the encoding before you can see the proper character displayed in Excel. Excel can display the unicode characters correctly if the format is UTF-8 with BOM/Unicode

You can use Sublime Text, vscode or even Notepad (or any editor that supports this):

  • In Sublime Text: File | Save with Encoding
  • In vscode: View | Command Palette | Change File Encoding | Save with Encoding
  • In Notepad: File | Save As (choose encoding as UTF-8 or Unicode)

Open in Excel.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.