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.