1. Home
  2. Zero BS 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, Zero BS CRM can import records with accents and uncommon characters in.

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

Occasionally it seems as though Zero BS CRM doesn’t deal very well with accents and special character encodings, e.g. the ‘é’ in México. This ultimately is to do with the input format, not ZBS.

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

Ultimately what you need to do is save your file in ‘UTF-8 Encoding’ – which means, in a common-format which ZBS uses to store characters. (This is typical of all best case web-apps which provide accessible software for multiple continents.) If this doesn’t work, please see this guide.

Make your file UTF8 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)’

Make your file UTF8 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.

Make your file UTF8 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 October 2, 2019

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.
CONTACT SUPPORT

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.