When trying to import an Org. List I get the error
Error importing organisation list: source sequence is illegal/malformed utf-8
That can occur because of particular characters in the csv file such as 'control' or non-English characters.
They might have come from the software that you used to export/create the CSV file.
If your CSV file contains unwanted strange (or ‘control’) characters, then:
- Edit the CSV to find strange/control characters to either remove or replace them.
Tip: If there are many such characters then use Find-and-Replace functionality in an editor like Notepad or Sublime Text. A shortcut to do that in those editors is to press CTRL+H
If your CSV file contains unusual characters that you want to keep, such as non-English characters, then:
- Open the CSV file in the useful text editor ‘Sublime Text’ and use its menu option:
File => Save with Encoding => UTF-8
to fix the file, and then try importing again.