In most cases your .CSV file needs to be saved in UTF-8 format:

1. First, ensure all your fields are properly filled in Excel or Open Office Calc.
2. Create and edit a copy of your .CSV file.
3. Save the file as Comma Separated Values (.CSV) if you haven’t already done so.
4. Open the file with a text editor such as NOTEPAD or TEXTEDIT.
5. Go to File > Save As .Your filename should end with “.csv.” Example:import.csv
6. Under Save as type select All files (*.*)
7. Under Encoding (Plain Text Encoding in TEXTEDIT) select UTF-8
8. Save the file ready for reimporting into Magento
9. Run the import again now all products will be imported without any error.