Saving A UTF-8 encoded CSV File
Google Spreadsheet correctly exports UTF-8 encoded CSV files by default. From the File menu, choose Download As and select Comma-separated values. The downloaded file will be UTF-8 encoded.
Navigate to the File menu option and click Save As. The window appears as shown below
Click Browse to select a location to save the file.
The Save As window appears. Select CSV (Comma delimited) (*.csv) as the file type and enter the name of your file.
Important: make sure you use the Save As dialog to export the CSV file and explicitly select the ‘CSV UTF-8 (Comma-delimited)’ option when saving the file.
Navigate to File > Export To > CSV.
Under Advanced Options, select Unicode(UTF-8) option for Text Encoding.
Click Next. Enter the name of the file and click Export to save your file with the UTF-8 encoding.
BOM characters are not visible but they exist and they can cause the processing of your file to fail.
To remove them:
1. Download Notepad++.
2. Open the CSV file in Notepad++ and look at the bottom right corner. If it says UTF-8-BOM then the file contains the BOM characters.
3. To remove the BOM characters, go to the Encoding menu and select Encode in UTF-8.
4. Save the file.