How to save the CSV file as UTF-8 character set in Microsoft Excel?


Steps are as given below:

  1. Open the CSV file with a Microsoft Excel sheet.
  2. Navigate to the File menu option and click Save As. The window appears as shown below:

       

  1. Click Browse to select a location to save the file.
  2. The Save As window appears as shown below:


  1. Next, enter the name of the file.
  2. Select the Save as type as CSV (Comma delimited) (*.csv) option.
  3. Click Tools drop-down box and click Web Options. A new window for web options appears as shown below:



  1. Under the Encoding tab, select the option Unicode (UTF-8) from Save this document as: drop-down list.
  2. Finally, click Ok, and save the file.

Note : Please refer below link to check procedure for other software like Libre Office,Google Spreadsheet

Link: https://www.webtoffee.com/how-to-save-csv-excel-file-as-utf-8-encoded/