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

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 the steps outlined below (refer to the accompanying screenshots for visual aid).

Unexpected display :

You want to enter a long number like 17897870708707312121212.

  • Excel shortens it to 1.79E+21.

  • Incorrect number: 17897870708707300000000

Step 1: Open a new file in Google Sheets.


Step 2 & 3: Select and import the CSV file containing the attendee list.







Step 4 (key step): When prompted, do not select the option to "convert text to numbers, dates, formulas" during the import process.



By following these steps, users can ensure that the check in qr data string column is displayed accurately without any unexpected symbols or trailing zeros. This method can help streamline the process of accessing and reviewing attendee information, ensuring a smoother experience for event organizers and administrators.



    • 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 ...
    • 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 ...
    • Custom QR Code for Check-in

      The EventX Check-in App supports scanning 3rd party QR codes. Organisers can import 3rd party QR code strings (eg. Eventbrite attendee QR code, or internal attendee QR code, etc) to the EventX platform. Steps In the CSV file that you are about to ...