Why does my Excel export look strange?

Issue:

My export replaced special letters with symbols such as commas. This caused some of the data to land in the wrong column. 

Solution:

Web Governance Excel exports are created in a format that allows special characters, but this must be selected at the time of import.

1. Export the file per the instructions in How to do an export.
2. Open Excel and click File > Import.
3. 

4. In the Import dialog box, select CSV file and click Import.

   

5. Browse to the file that you downloaded to your local machine, select it, and click Get Data.

   The system displays the Import Wizard dialog box.

6. Select:
   • Delimiters: Select semicolon or commas based on the data separator in the document.
   • File Origin: Select UTF-8 to ensure that special letters appear normally and data is placed in the correct column in the Excel sheet.
7. Click Finish.
8. Choose the existing sheet.
9. Click Import.