It is important to ensure that your CSV file is encoded with the Unicode UTF-8 Internet standard character set for displaying international characters.
UTF8 encoding of your import file is important to ensure that international characters render correctly in browsers worldwide.
Unfortunately Microsoft Excel is known to save CSV files in different encodings which differ by Office version and operating system. For this reason, we usually steer our international users away from relying solely on Excel to import and export data, though it can be done with careful use.
In Excel 2007, in the "Save As" window, click the Tools button. From there, choose Web options, Encoding tab. Select Unicode (UTF-8) from the "Save this Document as"
Another tool to use is Google Spreadsheet (which is similar to Excel, free and Web-based).
To change a CSV file to use UTF-8 encoding with Google Spreadsheets, follow these steps:
- Create a new, empty Google Spreadsheet by following the link above.
- Choose File, Import from the Google Spreadsheet menu, and choose Upload, then select your CSV file from your computer.
- Choose File, Download As...,Comma Separated Values (csv)
The resulting file will be a correctly formatted CSV file with all characters properly encoded.