Attendee report in CSV file is showing unreadable symbols, how to display the correct characters in the file?

Attendee report in CSV file is showing unreadable symbols, how to display the correct characters in the file?

When trying to open a CSV from exporting attendee list with Asian (Japanese, Chinese, Korean etc) words, the characters are replaced with unreadable symbols in opened up excel files. Follow these steps to open the export in Excel to correctly display the Asian characters.

Step 1: Open Excel, select “DATA” tab then choose “From text” option under “Get External Data”

Screenshot_2021-02-08_at_11.50.17_AM.png

Step 2: Open the CSV file and the Text Import Wizard (image below) will pop up. Select “Unicode (UTF-8). Notice the preview will change to readable characters.

Screenshot_2021-02-08_at_11.52.31_AM.png

Step 3: In Step 2, select “comma”. Notice now each item is separated in each cell instead of lumped together.

Screenshot_2021-02-08_at_11.53.01_AM.png

Step 4: Click finish and it’s all done.

Screenshot_2021-02-08_at_11.53.29_AM.png

Step 5: All characters can display correctly in the excel file.
Screenshot_2021-02-08_at_11.53.55_AM.png

    • Related Articles

    • Exporting Attendee List Report

      To keep a record of all the participants who attended your event, you may now export the attendee list anytime from the Organizer portal. This feature is available on Enterprise plan. To export the attendee list report: Step 1: Log in to your account ...

    • Attendee Management

      This article will cover the aspects that are related to attendee management on organizer portal. Attendee List Features Adding New Custom Fields Video Guide To view a video recording on this, please refer to this video. Article Guide Organizers can ...

    • Advanced Attendee Importing and Bulk Update

      Attendee Importing The New Attendee Importing will be live and effective for all users after Aug 6, 2024. Our import tool helps you add or update attendee contacts in EventX. Import from upload a comma-separated value file (CSV) like Microsoft Excel ...

    • Attendee Importing

      RSVP Invitation Video Guide For a video recording on this feature, please refer to this link. Article Guide Wondering if your invited participant is interested to attend your event or not? Worry no more because the RSVP invitation function would ...

    • How to ensure the attendee list shows the check in qr data string column correctly .

      When downloading the attendee list via the portal, some users may encounter unexpected symbols or trailing zeros in the check in qr data string column. One solution to this issue is to advise the client to open the file using Google Sheets and follow ...