Funny Characters importing CSV to Excel

CSV’s files are generated to be UTF-8 compliant. This is done to ensure the CSV’s can be used on a variety of operating systems using a variety of programs.

You may have see an issue with importing the CSV into Excel if your results contains accented characters (such as é, ç, ü, etc) used in many different languages.

To resolve this you just need to tell Excel the file is UTF-8 format

  1. Open Excel
  2. Click “File” and “New”
  3. Click on the “Data” tab
  4. Click “From Text” and select the CSV file
  5. Select “Delimited”
  6. For “File origin”, select “65001 : Unicode (UTF-8)”
  7. Click “Next”
  8. Select “Comma”
  9. Click “Finish”

Excel should now show you the CSV file and display the characters correctly.

Was this helpful?