Our import tool helps you add contacts to Givebutter. Upload a comma-separated value file (CSV), copy and paste contacts from a spreadsheet like Microsoft Excel or Google Sheets, or type info directly into the import table.
Import new Contacts
Step 1: Prepare your contact data for import.
Givebutter needs some basic information about your Contacts to create their profiles. The data needs to be formatted and uploaded to your Givebutter Dashboard. Data formatting of this nature is traditionally a time-consuming step, and to help you prepare that data, we've included a template below.
We recommend copying the template in Google Sheets or downloading it if you prefer working in Excel. Then match your data to the corresponding columns on the template.
We recommend importing no more than 5,000 records at a time. Going beyond that greatly increases the chance of upload failure. An alternative strategy would be to split file uploads.
The file *must* contain the following columns (in any order):
First Name: The donors first name
Last Name: The donors last name
The file may contain the following columns (in any order):
Primary Email: The primary email of the donor
Emails: A comma-separated list of additional email addresses associated with the contact. You do not need to include the primary email in this field.
Primary Phone Number
Phone Numbers: other phone numbers, values separated by commas.
Address Line: If one address field has a value, all address fields must have a value. For example, if Country Code and Zip Code have a value, then Address 1, City, and State must also contain a value. Incomplete addresses will be deleted.
Address Line 2: Optional
Country Code: Three symbol country code only: USA.
Tag: Apply tags to new contacts, to apply multiple tags, separate by a comma
Gender: The options here are Male, Female, or Other.
Date of Birth: Thecontact'ss Date of Birth is in MM/DD/YY or MM/DD/YYYY format.
Company: The Company associated with this contact
Title: Title associated with the contact
Twitter URL: Two formats are acceptable: the entire URL or /handle
Linkedin URL: Two formats are acceptable: the entire URL or /handle
Facebook URL: Two formats are acceptable: the entire URL or /handle
Finally, save the Excel file to your computer or download the Google Sheet as a .csv to your desktop.
Step 2: Upload the import file and map to Givebutter.
Navigate to the Track > Contacts tab of your Givebutter Dashboard, click the Import button, then click New Import.
Next, select to import or copy and paste the Contact data.
Click Upload data from file, review the data mapping in your import file to the fields in a preview window or manually enter your data into the window.
Whenyou'ree finished, toggle through some of the records to spot-check for completeness and click Continue.
After clicking Continue, you will receive an email confirmation from Givebutter. If that status is failed, follow the directions provided in our email to reconcile any errors.
To track the status of your Imports at any time, navigate to Accounts Settings > Imports.