While Data Migration from external system to salesforce many of us face this issue.
Just follow these steps and create salesforce compatible CSV files in minutes.
- Open spreadsheet in Microsoft Excel.
- Click on Save As which will open a dialog box.
- In Save as type dropdown select CSV(Comma delimited).
- Click on Tools button on same dialog box and select web options.
- In newly opened dialog box select Encoding tab and select Unicode(Big-Edian) from drop down list.
- Click ok.
- click save.
- Voila the CSV file is ready.
Hope this will help.