Page History

By default, Microsoft Excel may not open a CSV in Unicode/UTF-8 encoding. This means that special characters may be improperly displayed and also can be "corrupted" during re-import of the CSV.

You need to tell Excel this CSV is Unicode, by importing it as follows

. (Please note these instructions are valid for Office 2007 and 2013. Other versions may vary)

• Open Excel (with an empty sheet/workbook open)
• Select "Data" tab
• Click "From Text" button (in the "External Data" section)
• Select your CSV file
• Wizard Step 1
  
  • Choose "Delimited" option
  • Start import at row: 1
  • In the "File origin" selectbox, select "65001 : Unicode (UTF-8)"
  • Click Next
• Wizard Step 2
  
  • Select "Comma" as the only delimiter
  • Click Next
• Wizard Step 3
  
  • Select "Text" as the "Column data format"
  • Click Finish
• Choose whether to open CSV in the existing sheet or a new one