Why does my Excel export look strange?

Issue:

I have exported a file from Web Governance, but special letters are being replaced with symbols such as commas, and this causes 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.

• Export: Click the Export button on the upper right side of the window.

  

• Select: Select your export file. A dialog box opens, chose the file to export.

  

  A dialog box opens: "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."

• Click Go to My Export, in the dialog box.

  

  The My Exports window opens.

• On the same row as the export, click Download.

  

  The file downloads to the local machine, normally to the downloads folder.

• Open Excel and click File --> Import.

  

• An Import dialog opens. Select CSF file type and then click Import.

  

• Browse to Downloads and select the file. Click Get Data.

  The Import Wizard dialog opens.

• Select:
  • Delimiters: Choose the one that your document uses to separate the data:
    • semicolon
    • commas.
  • File Origin: UTF-8: This ensures that special letters appear normally and that data is placed in the correct column in the Excel sheet.
• Click Finish.
• Choose the existing sheet.
• Click Import.