Import Users from a Guest List

Users can be imported to a campaign through a user template available within your campaign or found here in this article. A user template upload should be done approximately 24-48 hours prior to the event. Edits to user accounts can always be made post upload directing on the campaign from User Details.

Note: If ticket sales are run through GiveSmart, guest lists should not be imported. User data will be added as supporters purchase tickets from your home page.

Watch a Video


Access User Templates

  1. From the Users Container within the Dashboard, click the More button ("···").
  2. Select Manage Users.
  3. From Users Details, click the More button.
  4. Choose import Users.
  5. Select the Template to download.
  6. Open the downloaded template, and save as an Excel.
  7. Add guest details.
Note: Do not rename the column names set in Row 1. Field1 and Field2 pair with the two Custom Fields per user to assign values such as table numbers, starting golf holes, or organization IDs which can be set from Dashboard > User Container > More button ("...") > Settings.

Template Options

Each template includes a header row of what information can be imported to the campaign. The column titles found in the header row cannot be changed. Row 1 must remain as seen in order for the information to import correctly.

  • User Template – USA Only
  • User Template – Canada Only
  • User Template – USA & Canada


User Template Fields

  1. First Name: (Required) User's first name.
  2. Last Name: (Required) User's last name.
    • For unassigned guests within a party that needs to be uploaded.
      • Guest of (First name) Party Name (Last Name).
    • For multiple unassigned guests within a party that needs to be uploaded.
      • Guest 1 of (First name) Party Name (Last Name), Guest 2 of (First name) Party Name (Last Name), etc.
  3. Phone: Cell phone number.
    • The cell phone number is the unique identifier for each user and can only be used on 1 user account. Couples CANNOT share a cell phone number.
    • Leave this field blank if you are not confident it is a cell phone number.
  4. Bidder #: Enter pre-assign bidder number or leave it blank if assigning at registration.
  5. Field1 & Field2: Custom fields assign values such as table numbers, starting golf holes, organization ID’s, etc. Visit User Settings to learn more.
    • No special characters can be used in this field. No: /, &, #, \, etc. can be within the text of this field.
  6. Email: User's personal email address.
    • An email address can be shared by more than 1 user.
    • With the email added to a user account, when payment is received, an email receipt will be automatically sent to this email.
  7. Street/City/State/Zip: Users residential street address, city, state and zip code.
  8. Province/Code/Country Only for Canadian addresses. User's residential Province, Canadian code, and residential country.

Upload User Template

Tip: If the content is in Field1 or Field2 and Custom Fields are not set, the platform will prompt you to do so before continuing.
  1. From the Users Container within the Dashboard, click the More button ("···").
  2. Select Manage Users.
  3. From Users Details, click the More button.
  4. Choose import Users.
  5. Click Choose File under Upload CSV File and add saved User Template.
  6. Click Begin Import.
  7. Once users are successfully added, a User Upload Summary will appear.
  8. If there are any errors within any of the user fields, a notification is sent.
  9. Click on View Errors to see which users have missing or invalid details. Users with errors have not been uploaded to the campaign.                                                                        
  10. Make the corrections and modify the spreadsheet to include only guests with errors to re-upload the users that were not successfully added.

Upload Additional Users

Note: User Templates should only be uploaded 1 time. If adjustments are needed, make them from their user account.

Create a new user template that includes these additional guests. DO NOT include any prior uploaded users or users already registered on the campaign.


Edit Imported User Accounts

  • To edit Bidder Numbers, or Custom Fields, go to Dashboard > Users container > More ("...") > Manage Users. From Users Details, click the More button and select Bulk Edit Users.
  • To make adjustments to email or address, go to Dashboard > Users container > More ("...") > Manage Users . From Users Details, search for the user, click on the user profile on the left to open up the user details on the right. From the details, click within the field to edit and click out of the field to save.

Visit Manage User Details for more information.


Duplicate User Accounts

Visit Merge Duplicate User Accounts for more information.