Why isn’t Data Loader importingspecial characters?
- Make any modifications to your source data file in .xls format.
- In Microsoft® Excel®, save a copy of your file as aUnicode Text file.
- Open the Unicode Text file you just saved with a text editor.
- Click File | SaveAs to change the following file settings:File name extension—.csvSave as type—All FilesEncoding—UTF-8
- File name extension—.csv
- Save as type—All Files
- Encoding—UTF-8
- Click Save, and close the file.Note Don’topen the file after you have saved the settings or you may revertthe encoding changes.
- Import the data using Data Loader as you normallywould, and select the newly created .csv file.