Sometimes we have special characters like John Villase�or in the csv file that is provided by external system or Client. If we directly load the data by using dataloader ,you dont get exact text in salesforce.
Please follow the below steps to resolve the issue.
1.First save it in excel format(.xls) //suppose file name is test.xls
2.Now open the text.xls file and select file--->save as--->choose desktop(As ur wish) --> then give the file name 'sample' and save as type :unicode text
3.Then open the sample file in notepad,here you have tab space in between the headers,so you need to replace the tab space with ','(use replace all option in notepad).
4.Then save the file as below
filename:test.csv
saveastype: all file
Encoding:UTF-8
Please follow the below steps to resolve the issue.
1.First save it in excel format(.xls) //suppose file name is test.xls
2.Now open the text.xls file and select file--->save as--->choose desktop(As ur wish) --> then give the file name 'sample' and save as type :unicode text
3.Then open the sample file in notepad,here you have tab space in between the headers,so you need to replace the tab space with ','(use replace all option in notepad).
4.Then save the file as below
filename:test.csv
saveastype: all file
Encoding:UTF-8
