Opening CSV UTF-8 files correctly in Excel

You can open a CSV file encoded with UTF-8 normally if it was saved with BOM (Byte Order Mark). Otherwise, you can open it through either of the following ways. 

1. Through PQ (Power Query) using the Get Data dropdown. Navigate to Data tab > Get Data > From file > Get Data from Text/CSV. 
   

2. Use the "Get Data From Text" option. This option is available in "Tell me" and in the ribbon.
   
   It opens the Text Import Wizard and does not create external links to the workbook.