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 can now export the attendee list report anytime from the Organizer portal. This feature is available on our Enterprise plan. To export the attendee list report: Step 1: Log in to ...

    • 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 ...

    • People List

      Adding New Custom Fields If an organizer would like to add a new custom field into the attendee list, it can be done by clicking on the Manage Fields button under the Attendee List. Please refer to this article for detailed steps on how to add a new ...

    • How To Import Attendees As Registered Status (to skip registration)

      The steps below will summarize how to use the attendee importing feature. To know more regarding this attendee importing feature, please refer to this article. Procedures Before uploading your CSV file containing the attendee data, be sure to add the ...

    • Adding an individual attendee record

      Bulk importing helps when you need to upload a high volume of new records all at once. However, we also understand that event organisers might want to import single attendee records one-by-one in certain situations. Please follow the steps below to ...