1. Home
  2. Jetpack CRM Extensions
  3. CSV Importer Pro
  4. Can CSV Importer Pro deal with uncommon Characters? (e.g. accents)

Can CSV Importer Pro deal with uncommon Characters? (e.g. accents)

Yes, Jetpack CRM can import records with accents and uncommon characters in.

e.g. the ‘é’ in México.

Jetpack CRM supports accents and special character encodings, but occasionally some characters, e.g. the ‘é’ in México can seem to display incorrectly. This is caused by the input format, not Jetpack CRM.

How to fix it if your characters are importing incorrectly with Jetpack CRM CSV Importer

You may need to save your file with ‘UTF-8 Encoding’, (the common encoding format which Jetpack CRM uses to store characters). UTF8 is used throughout Jetpack CRM to provide accessible software covering multiple languages. If following the guides below does not work, please see this guide.

Save your file with UTF8 encoding in Excel:

To save a text file as tab-delimited, UTF-8 encoded in Excel:

  1. Choose File -> “Save as” from the file menu
  2. In the ‘Save as type’ dropdown > select ‘Text (Tab delimited) (*.txt)’
  3. Select ‘Web Options’ in the ‘Tools…’
  4. Select the ‘Encoding’ tab.
  5. In the ‘Save this document as:’ dropdown, select ‘Unicode (UTF-8)’

Save your file with UTF8 encoding in (Windows) Notepad:

  1. Open the CSV file with Notepad.
  2. Navigate to File > Save As option.
  3. Next, select the location to the file.
  4. Select the Save as type option as All Files(*.*).
  5. Specify the file name with .csv extension.
  6. From Encoding drop-down list, select UTF-8 option.
  7. Click Save to save the file.

Save your file with UTF8 encoding in Google Sheets:

  1. First, open your Google Drive account. Click on the NEW button on the top left corner, and click Upload files option.
  2. Browse for the required CSV file and start uploading it.
  3. Open the uploaded file with Google Spreadsheet.
  4. Navigate to File > Download as, and select Comma-separated values (.csv, current sheet) option.
  5. The downloaded file gets saved as UTF-8 encoded by default and can be imported correctly when uploaded into CSV Importer PRO.

Still stuck? Please see this guide on overcoming this WordPress core bug.

Updated on May 28, 2020

Was this article helpful?

Related Articles

Still not found an answer?
If you've searched the knowledge base and still can't find a solution, please submit a ticket.