Self-Importing Donors + Video

Tip: If you are a returning user, you can migrate donor (with donation history) from your previous site(s).

These instructions cover how to self-import (upload) a spreadsheet of potential donors directly into the software. This will create User records with "Is Donor" flag so:

they display on the Donors datapage,
can be emailed invitations to donate and
their donor record selected when entering items into your catalog.

Donors can be easily filtered to distinguish donors that have donated to the current event and those who have not.

Note: the software defines "donors" as those who donate items or services to your auction or sponsor your event. Supporters who attend your event and/or make cash donations are considered Guests and/or Buyers and will not be automatically assigned the "donor" role/flag. If your supporters commonly donate items and attend your event as a guest - import them as "Donors" if you want them to display on both the Donors page and Users (potential Guests/Bidders) page.

Tips and Best Practices:

1. Clean data = good records:

Each row in your spreadsheet will create a User/Donor record.
Make sure all data within each column is consistent (ie all phone numbers, or first name only) and that all rows contain a Name (required).
The software does not validate or format the data being uploaded (eg. emails, phone numbers etc) - it is uploaded exactly as provided, so review carefully.

2. Business and Individuals Names must be in separate columns. Find more information on name formats here.

3. Once you have selected and uploaded a spreadsheet, you will be able to review it before completing the upload, but you will not be able to edit any data from the review screen.

4. If a record is missing required information, Will Skip (reason) will display in the left column. If a column is not mapped to a field, it will also be skipped, and displayed in red.

5. You can upload multiple spreadsheets, and/or migrate past records plus upload new records. Upload your best (usually most recent) data first. On subsequent uploads, review records flagged because of duplicate emails and/or names. Duplicates are skipped by default, but you can opt to upload them by checking the appropriate box(es). Duplicate records can be merged on the Users page, if necessary, but merges are limited to two records at a time.

To Upload:

Go to: Donors > click on the Self Import Donors button
Confirm Import Type and upload the file from your computer.
Map Columns to Fields then Approve to begin the import.
Confirm the data displays as expected, and "undo" if necessary.

1. Go to: Donors > Self Import Donors

2. Confirm Import Type and Upload File

3. Map Columns to Fields and Review:

Map your columns of data to the correct fields in the software by selecting from the dropdown.
If your spreadsheet contains a column of info that does not match the dropdown of standard fields - map it to "User Defined Field" to import the data in a custom field called udf - (column header name).
Once all columns have been mapped, review status column on far left. Any rows still missing required data will not be imported.
If you need to edit your spreadsheet, you must cancel the import, edit the spreadsheet, then upload it again.