CSV Export: Why are the special Characters displayed incorrectly in Microsoft Excel? - macOS-Version / Print / Export - Outbank Helpdesk

CSV Export: Why are the special Characters displayed incorrectly in Microsoft Excel?

Microsoft Excel cannot handle the export format UTF-8 out-of-the-box. Therefore, to open the CSV export from Outbank in Excel, please follow the steps below:

  1. Start Microsoft Excel and start a new blank workbook
  2. Click on ‚File‘ > ‚Import‘
  3. Select ‚CSV file‘ for the file type and click on ‚Import‘
  4. Select the export CSV file from Outbank in the Finder window and click on ‚Get data
  5. The Text Import Wizard window will be opened. Under ‚File origin‘ select the option "Unicode (UTF-8)".
    If you click on ‚Next‘, you can select other options for reading the file and use the preview to check your Settings.
    Click on ‚Finish‘ import the file in the selected form.