Skip to end of metadata
Go to start of metadata

It is possible to open CSV files directly in Excel by just double clicking on them in an explorer window.  But doing this does not allow Unicode characters to display correctly.  CSV files with Unicode characters should be imported into Excel and have the encoding set to UTF-8.

To import a file into Excel and change the encoding follow these steps:

  1. Open Excel
  2. Create New Blank Workbook
  3. Click Data and select From Text/CSV on the upper left side of the screen
  4. Browse to and select your CSV file
  5. Change File Origin to 65001: Unicode (UTF-8)

If you open the CSV file directly, the cells will appear like this:


This is what you will see if you import as UTF-8:

  • No labels