What is a simple way to UTF-8 encode your CSV file by using Excel 2010?
UTF-8 encoding of CSV files
How many times have you had to UTF-8 encode your CSV files? Here's a simple way to do that using Excel 2010.
Open your file in Excel and save as CSV (Comma Delimited). Then, scroll down and choose Tools. Choose Web Options from the Tools drop-down menu. Then, select the Encoding tab and choose UTF-8 from the Save this document as: drop down menu and select OK. Now your file is saved as a UTF-8 encoded CSV file.