Special characters in my language don’t display after import
Non-English characters, for example in French à, é, ï, etc., sometimes don't show correctly after you import them. You might see squares or weird characters. It's annoying, isn't it?
Quickfix: copy and paste your data in the textarea
The easiest way to get around this problem is to use the text area, and not the file import. Simply select all your data in your CSV, copy it, and paste it in the multi line input on the Import page.
Save your CSV in UTF-8
When you save your file, you should have an option to pick the Encoding.
Unfortunately, Excel doesn't allow you to select the encoding. Here's an easy workaround found in Yahoo Answers.
Most simple text editors let you choose the encoding standard. You need to search in the saving options for of your program that opens your CSV or in the settings of your CSV file itself.
What is UTF-8 encoding?
In short, encoding are language standards for computers. Some may speak French, others Hindi.
For example, browsers generally understand pages in multiple languages. An HTML page simply needs to tell the browser what language it should display it. For example, you might have seen "Western European" or "ISO 8859-1" for French speakers.
Most of the World Wide Web has adopted the UTF-8 which supports nearly 650 languages.
With UTF-8, an HTML page doesn't need to tell the browser its in Romanian or Turkish. Instead, the browser will automatically show the correct language characters.