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.


    • Related Articles

    • How to download video files?

      NOTE: Videos cannot be downloaded in bulk and must be downloaded one-by-one. Click Dashboard Click Speaker module Click Reports button Click Presenters tab Click Go for All Presenters #2 report Click Advance Click Download Excel In the list of ...

    • How to Download a List of Registrants?

      How to Download ALL Attendee Registrations? This download will generate an excel file with ALL registrations containing registration status values that are Complete, Incomplete. Pending and Cancelled. Use the filter feature in excel to filter the ...

    • How to Send an Email to/Download report for Attendees who have NOT Completed their Registration and Payment?

      Click Dashboard Click Attendee Module Click Reports button Under the Attendees tab, click on Go beside 'Incomplete Attendees' Click Send Email Click Download Excel for a Report Edit the Email reply-to, Email from, Subject, Message Body Click Preview ...

    • Frequently Downloaded Reports

      Not sure how to find the statistics area for your conference? Please see this article. Select the appropriate date range for the data you want to view in the date picker. Who watched which Sessions? Click More on the Program Data & Videos Card  Click ...

    • How to Download the list of Contacts?

      There are two (2) different methods for downloading a list of Contacts. 1. You may use the Reports section or 2. use the Manage screen filters. Downloading Contacts from the Report section Click Dashboard Click Contacts Module Click the Download ...