Importing your existing giver data into the Giving module

Just as you can import contacts into the Address Book and Children module, you can similarly import giver data into the Giving module. So if you have a pre-existing system that you're transitioning from, we've made it really simple to get that existing data into your ChurchSuite account.

In this article

Make sure your data is the right format
Importing your Giver CSV file
Tag for Import process
Import specification for Givers

Make sure your data is the right format

To upload your Giver data into the Giving module, it needs to be in the form of a .CSV (Comma separated value) file. Make sure that the first row contains the correct header information, which ChurchSuite will use to match your data to the correct field in the Giving Module giver records. There is a full list of the types of data with the relevant header information on the "Import Givers" page in ChurchSuite. Note, you don't have to include every field in your CSV file, but ChurchSuite will import every column from your CSV file that has header information it recognises.

Importing your Giver CSV file

Note: When importing data on a multi-site account, the site you're currently browsing is the site the giver data will be imported into. Be sure to select the correct Site before proceeding.

Go to "Giving" > "Givers" and click "Import Givers". On the next "Import Givers" page, click "Choose File" and browse to the location of your CSV file. Then, click "Import CSV File".

ChurchSuite will this display a preview of your data so that you can check all incoming data is being matched to the correct field in ChurchSuite.

Once you are satisfied everything is correct, scroll down and click "Import All Givers" to complete the import. Alternatively, you can click "Cancel Import" if you discover you need to address problems with your CSV file. A typical problem might be a duplicate Giver Reference - simply cancel the import, fix the reference in your CSV file so that references are unique, then return and re-import your CSV file.

During the import process, ChurchSuite will attempt to link your imported givers to your Address Book contacts based on first name and last name. After you have completed the "import givers" process, we recommend you use the "Giving" > "Reports" > "Potential contacts" report to help identify and match any remaining unlinked givers to possible existing Address Book contacts.

Tag for Import process

A tag is automatically created for each contact or child that is imported.  The format of the tag is:
Import <date time> where <date time> is in your local format e.g. Import 01-01-2017 11:59am

This will be useful if you encounter a problem after import (e.g. you missed a field during the import). With a Tag you can easily delete just those imported Givers and re-run the import process again.

You may delete this tag when it is no longer relevant.

Import specification for Givers

Field Imported Into Sample Data
full_name broken into First Name and Last Name fields Joe Bloggs or Bloggs, Joe
first_name will be imported into the First Name field Joe
last_name will be imported into the Last Name field Bloggs
full_address breaks on commas into Address, Address 2, City, County and Postcode fields 1 Queens Drive, Beeston, Nottingham, Notts, NG1 1AB
address will be imported into the Address field
address2 will be imported into the Address 2 field
address3 will be imported into the Address 3 field
city will be imported into the City field
county will be imported into the County field
postcode will be imported into the Postcode field
country will be imported into the Country field
telephone will be imported into the Telephone field
mobile will be imported into the Mobile field
email will be imported into the Email field
tags will be imported into the Tags field Member, Leader
reference An internal reference you use to identify this giver for your records G-0001
bank_reference The reference that will be used to identify this giver when importing donations. If there are multiple bank references for this giver, separate them with a comma "JOEBLOGGS","JBLOGGS"
couple will be imported into the Is Couple? field 0 OR 1 (No OR Yes)
spouse_full_name broken into First Name and Last Name fields Jane Bloggs OR Bloggs, Jane
spouse_first_name will be imported into the First Name field Jane
spouse_last_name will be imported into the Last Name field Bloggs
ga_percentage_giver will be imported into the Gift Aid Split Giver % field 100
ga_percentage_spouse will be imported into the Gift Aid Split Spouse % field
declaration_start will be imported into the Declaration Start Date field 15-01-2016 (i.e. dd-mm-YYYY)
declaration_end will be imported into the Declaration End Date field 31-12-2016 (i.e. dd-mm-YYYY)
site will be imported into the Site field Site name (if applicable) - ONLY for non-members

Still need help? Contact ChurchSuite Contact ChurchSuite