Why does my Excel export look strange?

Issue:

When I exported a file from Web Governance, special letters are replaced with symbols such as commas. This caused some of the data to land in the wrong column. 

Answer:

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

1. Click the Export icon on the upper-right of the page.

   

2. In the Select your export file dialog box, select the file to export.

   

   The system displays the following message:

   copy

   Your export is currently being generated.
   You will receive an email when the export is ready.
   To see the current progress, click the user avatar on the upper right-hand side of the main page and select My Export.
   Alternatively, click the button below.

3. Click Go to My Export.

   

   The system displays the My Exports screen.

4. On the row for your export, click Download.

   

   The file is downloaded to your local machine.

5. Open Excel and click File > Import.

   

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

   

7. 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.

8. 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.
9. Click Finish.
10. Choose the existing sheet.
11. Click Import.