Exporting QR Code Data for Bulk Printing

Registrant CSV files can be exported to allow bulk printing of event badges with QR codes by third-party badge printing services.

This article will outline how to:

1. Download the Registrant CSV file from the Backoffice
2. Identify potentially relevant data for badge printing from the export

How to Download Registrant CSV Files

1. Log in to the Backoffice and select the desired event.
2. Navigate to the Listed Registrants tab and click on the upload / download data button:
3. On the subsequent page, click "Download for Spreadsheets":

List of Potentially Relevant Data to Provide to Badge Printing Services

Open the downloaded CSV file from the previous section and confirm that all expected registrant data are present. We recommended sharing the below columns of the CSV file with the third-party badge printing service:

1. Badge Name (or First Name Last Name):
   1. If this value is blank, you can combine the First Name and Last Name columns into the Badge Name column by selecting the 2O cell (Badge Name cell for the first registrant value) and typing: =B2&" "C2 then Enter/Return. Double-click the bottom-right corner of the cell to combine the remaining names down the column.
2. Badge Type:
   1. Field for entering badge-holder role, e.g., Attendee, Speaker, or Exhibitor.
3. Custom Badge Label 1 and 2 (Optional):
   1. Custom field reserved for custom badge-holder values such as: Company, job title, and contact information.
4. Badge QR Barcode Content:
   1. URL for the roster QR codes.
5. The following address-related values in cases where badges have to be shipped to the attendee's address before an event:
   1. Address Line 1
   2. Address Line 2
   3. City
   4. Region (State, if in the US)
   5. PostalCode
   6. Country

For examples of badge styles to use for your event, please see the article: Badge Styles.