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:
- Open Excel (with an empty sheet open)
- Select "Data" tab
- Click "From Text" button (in the "External Data" section)
- Select your CSV file
- Wizard Step 1
- Choose "Delimited" option
- 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
|