When importing your supporter contact information, follow this process. 

In addition to our Supporters Import, we include three import options that can be used when bulk updating your existing supporter’s contact information:

• Supporter Addresses
• Supporter Email Addresses
• Supporter Phone Numbers

Here are some extra details to assist you when importing your supporter’s contact information. 

You can use our predefined templates or your own files. While our templates are recommended for simplified data matching, they are not mandatory.

Required Fields#

There are four fields required for supporter addresses:

• supporter_permalink
• address1
• city
• country

There are two fields required for supporter email addresses:

• supporter_permalink
• email_address

There are two fields required for supporter phone numbers:

• supporter_permalink
• phone_number

Note: The permalink of the supporter, found in the supporter’s record, is required to find existing supporters. The supporter’s primary email address can be used instead.

If you are using sponsorships in REACH, it’s crucial to follow this sequence for correct record linkage: begin with Sponsorship Images, then move on to Sponsorships, Supporters, and finally Donation History(optional).

Using our Supporter Import Template#

Navigate to to Data Setup > Data Import/Export > Imports tab andselect either the Address Import Template, the Phone Number Import Template or the Email Address Import Template from the System Import Templates dropdown menu to download the template. 

The template consists of two sheets: the first sheet lists column names and descriptions detailing the required supporter data for each column. The second sheet is where you will enter your data for the import.

Input your data into the second sheet, being sure to include the required fields that are indicated for each.

Delete any empty rows from your spreadsheet. Empty columns should not cause a problem. 

Importing your Supporter Contact Data#

Now, you can prepare to import your file. 

Remember, you can consult our Importing your Records article for detailed instructions. 

It’s highly advisable to first conduct a test import with a small number of supporter contact records. This allows you to observe how each data field maps and correct any errors before proceeding with the import of all your records.

Navigate to to Data Setup > Data Import/Export > Imports tab.

• Click + New Import
• For the Import Type, select Supporter Addresses, Supporter Email Addresses or Supporter Phone Numbers
• Review the required and optional fields and edit your data as needed. Click Show field definitions more details.
• Browse to choose the file to import
• Click Submit 
• Match your imported columns, click Import Data. 

If successfully matched, your import will begin processing and you will receive an email once complete. 

If any columns were not matched correctly, the necessary corrections will be specified in red. If needed, make corrections in your import file, and return to Step 2.

Once completed, you will see a status page that details the name of your import file, the import type, the status, uploaded date and a list with links to the records imported.