Exporting to Excel for languages not in english

In CPW, the Export to Excel function creates a CSV file and opens it in Microsoft Excel. If you encounter issues with the formatting of special characters, you must update the Microsoft Excel settings.

  1. Export the CSV file.
  2. Open a blank workbook in Microsoft Excel.
  3. On the Data tab, import the CSV file then select From text/csv.
  4. Select the appropriate column delimiter during import. You can select comma or semicolon.
  5. Click Load.
    The CSV file exported from CPW matches the settings in Microsoft Excel.