Accented Characters not Displaying Properly when opening downloaded report

Accented Characters not Displaying Properly when opening downloaded report

If your contact data contains accented or foreign characters, the characters may not display properly when attempting to directly open the .csv file in excel. To resolve this issue, use one of the below methods to open your file.

Method 1

  1. On a Windows computer, open the CSV file using Notepad.
  2. Click "File > Save As".
  3. Select "ANSI" from the "Encoding" field. Then click "Save".
  4. Open new CSV file using Excel

Method 2

  1. On a Windows computer, click "File > New" in Excel.
  2. Click "Data" tab.
  3. Then click "From Text" option. Select the exported CSV
  4. Excel will display "Text Import Wizard".
  5. In step-1 of this wizard:
  6. "Delimited" = Comma
  7. "File origin" field - select "65001 : Unicode (UTF-8)".
  8. Click Load button

Method 3

  1. When opening the file in Excel, click the Data menu
  2. Select From Text/CSV option

On a Mac:

  1. Open the file using the "Numbers" application instead of Excel.