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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .