Importing Data - FAQ

How to format your file, take care of duplicates and how to add people to groups, campaigns and more by importing a spreadsheet.

Updated over a week ago

Why can't I seem to import data into Donor Management?

Only "Supervisor"-level or "Staff"-level admins in Donor Management have access to import data into the platform - so you may want to check your "admin" role (or have someone with "supervisor"-level access check for you!

You can check your admin role by clicking on your name in the bottom-left corner of Donor Management, and selecting "Profile."

Once the page re-loads, your role will appear under your name on your profile. If it says "Viewer," "Recorder," "Accountant," or "Staff-Limited," you won't be able to import files, and you'll need to work with one of your "Supervisor" or "Staff" colleagues to import that information into Donor Management (or upgrade your permissions).

Unfortunately, our Support team is unable to change roles for an admin, as we don't have a way to verify what level of access you may need. You'll need to ask someone at your organization with Supervisor-level access to edit your access level to the system, if any changes need to be made.

Do you have a template we can utilize to make sure our donations and donor data are formatted correctly?

We do! You can find a downloadable version of that template here.

What if my file contains contact types other than individuals such as businesses?

If you have any contacts that aren't individual people (such as a business), our Data Imports team will take care of importing those contacts in on your behalf.

You can learn more about this process here.

What happens if my data is not imported as expected? Can I delete them later?

Yes - in the worst-case scenario, our Support team can assist with deleting multiple (or all) data records at once.

Please note that if a contact record has prior activity, such as a previous donation history made through our platform, it may not be possible to delete that record.

Do I have to split full names and addresses into separate column, such as "First Name" and "Last Name"?

No, that's not necessary! Our importing tool will automatically split information in the "Full Name" and "Full Address" fields into the corresponding components of those fields into separate columns. (In other words, a full name would be split into "First Name" and "Last Name" fields - while still retaining the "Full Name" field.)

Are any fields required for import?

Each contact record needs to have a first name (or, if no first name is available, an email address needs to be listed in the “first name” field.)

While it isn’t required, we also recommend having an email or physical address for each contact record as well, to make sure that you have a way to communicate with this individual later on.

Each donation record needs to have some way to be associated with a contact record – in most cases, this is by the donor’s email address, but some organizations instead use a field like internal ID to make that association.

Donation records also need to include the exact date of the donation (MM/DD/YYYY), the amount, and the payment method used to make the transaction. If you don’t know the date of a donation, you can always enter it as January 1st of the current year.

What happens if my file contains duplicate contact records?

Our importing tool will automatically merge contact records when certain information matches (such as email addresses, or both full name and full address).

Donor Management will also flag certain similar contacts as "potential duplicates," which you can review and confirm if they are true duplicates - or two separate records.

You can learn more about merging duplicates here.

How do I put people into a household?

We have a helpful guide on adding and managing households that you can review here!

Can I import custom fields?

Yes! We have a guide on this process here.

Can I import contacts into groups?

You can! You'll want to create the group in Donor Management, under the "Contacts" tab, if the group doesn't already exist.

Once the group exists, you can create a column in your data file that has a header that matches the group's name. You can then put an "X" in the fields in that column to indicate which contact records should be added to that group, and then import the data as planned.

Please watch the short video below to see this process in action, or check out our related guide here.

Are addresses automatically abbreviated when imported into my system?

Yes, street names are automatically abbreviated once they've been uploaded to Donor Management - even if they are fully spelled out in your data file.

This small change helps ensure that all mailing address addresses are accurate and match up to USPS records - which can help reduce duplicates and help increase deliverability of your mail communications.

Did this answer your question?