How to Import a Guest List

If you are selling tickets outside of Handbid this article will show you how to add your guests to Handbid. If you are selling tickets through Handbid you will not need to import your guest list as guest will populate as you sell tickets.

Once you've complied a list of all your attending guests, and you're ready to import your guest list, then this is the article for you! However, before you start digging deep in this article, we urge you (we would require it if we could) to read through this article on how to prepare your data for upload. This article also shows you where to find the sample guest list template.  There is no sense in uploading bad data and then having to start all over again.

Step 1:

Get your Sheet into the Right Format

This sort of a trick question. If you used our template it IS in the right format. It needs to be a CSV file. CSV stands for "comma separated value" and represents a basic text file with all of your data in it with the fields (first name, last name, etc.) separated by commas.  If you made a decision at some point to save it as an XLS file (why?),  then you need to save it back to a CSV. 

Also, if you added or removed columns, then you will need to remove those or add those back.  If you can't remember what you added and removed, then grab a new sample file and copy your data back to it.

 

Step 2:

Import the Spreadsheet 

To import your guest list into Handbid from the Auction Manager, go to:

  • People tab and select guests under the guests select guests import.
  • You will see the sample file, and the choose a file button.
  • You will use the sample file to enter all your guest list data first, and then upload it into Handbid. You can drag and drop the file to upload or you can upload by clicking the select a file button.
                                 

 

Once the spreadsheet loads, you will see a sample of it just below the Headers.  The header boxes represent the fields in the Handbid database that need to be matched to your spreadsheet.

If you use our template (and did not modify it), then there is a shortcut you can use that will match the headers for you called "auto-match". Auto-match is a link in the sentence just below "MATCH HEADERS".  Clicking that will map the Handbid fields to the columns in your spreadsheet, saving you a ton of work. 

If some of them didn't match (or if you did not use our template), you will need to drag and drop the boxes down on to your columns in the sheet below to match them.  The red (pink) boxes are required. 

                       

 

Once the headers are matched, click the "Validate" button to have Handbid check your work.

                       

 

Once you have validated your spreadsheet you will be presented with the total, Errors, Warnings, and Skipped sections.

  • Errors and Warnings will display a description of the issue. Click on the Errors / Warnings buttons on the right to see where Handbid found issues. 
  • Warnings can be ignored (but should be reviewed).
  • Errors either must be fixed or Skipped.  You can skip them by checking the skip box on the right-hand side. 

 

Guest List Upload Options

When your spreadsheet is ready to upload (no more errors!), click on the Import button to start the process.  Once you do this, Handbid will present you with a confirmation dialog window where you have two options you must decide upon. 

  1. Do you want to undelete any previously deleted guests?  If Handbid finds a deleted guest with the same email address as another account, it will "undelete" that guest instead of adding them into the system again. 
  2. Do you want to assign paddles on import?  This is where you can "pre-assign" paddles upon import.  This isn't the recommended option, but for those that want to assign upon uploading, this is where you will allow your guests to have a paddle number reserved for them.  Once these paddles are assigned, they can't be "unassigned". However, you can swap paddles around if you need to.

Once you make your selections on the upload options, you are ready to import. Hit the import button and the system will start the process!