Need to import a list of attendees into your ClickBid event? The Mass Import Bidders feature is a quick way to upload your guest list in bulk — saving time and reducing manual entry. Just be sure to follow the format carefully to avoid any hiccups!
⚠️ Before You Start: Avoid Duplicate Bidders
Do not use mass import if you're allowing guests to register themselves online — this can cause duplicate bidder records.
⚙️ Download the Import Template
To get started, download the correct spreadsheet format directly from your ClickBid admin.
-
Go to the Bidders tab.
-
Click Manage Bidders.
-
Scroll to the bottom past the Batch Update section and Custom Questions area. Locate the Mass Import Bidders section and click Download!
-
This download is a specially formatted Excel file that the system can read.
-
Do not delete, hide, or add any columns.
-
Save the file as a CSV UTF-8 before uploading.
Only the First Name and Last Name columns are required on the template, but we recommend including Phone and Email for better communication.
Phone and Email are required for your bidders to sign in to the event as well.
👥 Filling Out the Spreadsheet
Here are the key things to know when filling in your bidder data:
-
If you don't have a name, use a placeholder like “Guest of [Name]”.
-
Leave the Bidder Number column blank to let the system assign numbers automatically (starting at 100).
-
You can edit bidder details at any time after the upload.
Include phone numbers and emails to allow guests to receive outbid notifications and event messages.
➕ Adding Couples or Shared Bidder Numbers
If two guests are planning on sharing one bidder number, list them on the same row of the spreadsheet.
Example 1: Shared last name
-
First Name: Joe & Jane
-
Last Name: Smith
-
Phone:
1234567890,0987654321 -
Email:
joe@smith.com,jane@smith.com
Example 2: Different last names
-
First Name: Jane Jones and Joe
-
Last Name: Smith
Separate multiple phone numbers and emails with commas to ensure both parties receive notifications.
✅ Uploading Your File
Once your spreadsheet is complete:
-
Go to Bidders > Manage Bidders.
-
Drag and drop your CSV UTF-8 file into the upload area labeled Drop Files to Upload.
-
If you see an error, re-save your file as a CSV UTF-8 and try again.
-
You can upload multiple files, but always start with a new blank template to avoid duplicates.
Reusing or editing a previously uploaded template can result in duplicate bidder entries.