Opening CSV UTF-8 files correctly in Excel

Applies To
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. 
    Opening txt/csv through Data tab

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

    Text import wizard