[SalesForce] Special character CSV dataloader issue

My requirement is to upload records with special characters.

i am following these steps :

  • Save the Excel sheet as "Unicode Text (.txt)".The new "*.txt" file is TAB delimited, not comma delimited, and therefore is not a true CSV.
  • Unless you can use a TAB delimited file for import in data loader, use
    your favorite text editor and replace the TAB characters with commas
    ",".
  • Launch data loader, click update
  • select object and browse the ".csv" file.

data loader stops at initializing the file and do not respond afterwards.

enter image description here

Best Answer

You need to convert your CSV encoding to UTF-8. Then try to insert data into Salesforce. This should work.

Please refer this link for converting CSV format to UTF-8. I'm highlighting those steps below:

  1. Make any modifications to your source data file in .xls format.

  2. In Microsoft® Excel®, save a copy of your file as a Unicode Text file.

  3. Open the Unicode Text file you just saved with a text editor.

  4. Click File | Save As to change the following file settings: File name extension—.csv

  5. Save as type—All Files Encoding—UTF-8

  6. Click Save, and close the file.

Below are some snapshots of my Developer org:

  1. Exporting Account having Name in Special Characters in CSV format:

enter image description here

  1. Below CSV file contents:

enter image description here

  1. Again imported that CSV file into my Dev org:

enter image description here

  1. Salesforce Org data snapshot:

enter image description here

Related Topic