Issue:

I have exported a file from Acquia Optimize, 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:

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

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

   

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

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

   

   The My Exports window opens.

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

   

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

5. Open Excel and click File --> Import.

   

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

   

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

   The Import Wizard dialog opens.

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