You are here:
Why doesn’t Data Loader import special characters?
If Data Loader fails to import special characters such as ö, ñ, or é, your source data file isn’t properly encoded.
To ensure that the file is properly encoded:
- Modify your source data file in .xls format.
- In Microsoft® Excel®, save a copy of your file as a Unicode Text file.
- Open the Unicode Text file you saved with a text editor.
- To change these file settings, click :
- File name extension—.csv
- Save as type—All Files
- Encoding—UTF-8
- Click Save, and close the file.
Note Don’t open the file after you have saved the settings or you can revert the encoding changes. - Import the data using Data Loader as you normally do, and select the newly created .csv file.
Did this article solve your issue?
Let us know so we can improve!
