CSV files created via exported report don’t decode special characters correctly with Excel

Products

Webtrends Analytics 9.x

Issue

When you open a file in Excel that was created via export, special characters aren’t decoded properly.

Cause

The file exported is encoded in UTF-8 because it is the encoding used to collect data. Excel defaults to ANSI when opening files.

To resolve the issue, open the file in the following manner:

1. In a new worksheet, click on the Data menu bar option in Excel.
2. Click on the From Text icon.
3. Navigate to the location of the file that you want to import.
4. Click on the filename and then click on the Import button.
5. The Text Import Wizard – Step 1 or 3 window will now appear on the screen.
6. Leave the radio button for Delimited selected.
7. Choose 65001: Unicode (UTF-8) from the drop-down list that appears next to File origin.
8. Click on the Next button to display the Text Import Wizard – Step 2 or 3 window.
9. Place a check mark next to comma and remove the check from the check box from Tab.
10. Click on the Next button to display the Text Import Wizard – Step 3 of 3.
11. Click on the Finish button to finish importing your data into Excel.