How to import CSV file that uses UTF-8 encoding

In order to import in Excel 2016 and earlier versions a CSV file that uses UTF-8 encoding, you have to follow these steps.

  1. Open Microsoft Excel,
  2. Go to Data >> Get External Data >> From Text.

    1. Go to the location of the CSV file, that you want to import.

  1. Choose Delimited,
  2. Set the character encoding to 65001: Unicode (UTF-8) from the dropdown list.
  3. Check My data has headers. You have to use it because the first row of CSV file has column names.

  1. Click next to display the second step of Text Import Wizard.
  2. Because our data is separated by commas, set the delimiter to a comma.

  1. Click next to move to the third step.

  1. Select the General column and click the Advanced…
  2. Because we have big numbers in our example, we will set a thousand

  1. Click OK and then Finish.
  2. Keep the default values inside the Import Data window and click OK.

  1. This is the result.

  1. Now, you can save the file as an Excel document.