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.

Pro Tips:

  • 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

  • City

  • State

  • ZIP Code

  • 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.


Did this answer your question?