Preparing and Sending Data to the Import Team
Updated over a week ago

The process to send your historic data to our Imports team is a simple one - but it does require a little bit of preparation to make sure that your data is clean, complete, and ready for import. The time it takes for the Imports team to complete that importing process can be cut nearly in half - if the data has been cleaned and formatted in advance.

We'll go over some of our tips and recommendations below, as well as walk you through the process of actually sending those files to our Imports team for processing!

Deciding What Information Belongs in Donor Management

The first step - deciding what information you'd like to send over to be imported - sounds like a no-brainer, but there's a lot to consider!

We recommend reviewing any locations where you store data on your donors and their donations - such as:

  • Other donor management systems

  • Excel spreadsheets on your (or your colleagues') computers

  • Financial management systems, such as Quickbooks

  • Email clients, such as Mailchimp or Constant Contact

  • Event management software, such as Eventbrite

  • Personal contact records, such as those in Gmail or Outlook

If you're just getting started and don't have information in any of these locations - that's okay! You can get started by manually adding contacts into the system instead, such as your board members, volunteers, colleagues - even your own family!

The Network for Good Data Import Team strongly recommends that you export or download all data from your former donor management system, whether or not you ultimately decide to send your files to Network for Good for assistance in the importing process. This allows you to have a complete archive of your former system, in the event that a field is overlooked during the import process.

Downloading the Standard Importing Template

To make things easier for you, our Data Import Team has created a downloadable spreadsheet that you can use as a template for importing data into Donor Management.

You can download this spreadsheet by clicking on this link.

You can also find a downloadable version of this spreadsheet in Donor Management – you should see an option to download the template on the second step of the import process.

This spreadsheet is only meant to be a guide – but it’s a helpful guide to see exactly what information you might want to include in your records.

It’s also a helpful way to see how to format that information so it will import into Donor Management as smoothly as possible; the closer your data is to the template’s formatting, the faster your import process will go.

Cleaning your Data Files

Auditing and cleaning your historic data may seem like a challenge, but we recommend taking some time to do so before importing anything into Donor Management. Not only does it help speed up the process for whomever is processing the import, it also gives you control on where you’d like to see certain fields created and listed in the system later on.

Cleaning the data also helps make sure that the data you’re adding to your brand-new system is as accurate as possible. Uploading incomplete or incorrect data can result in higher email bounce rates, more mail returned to sender, and an overall loss of integrity of your contact’s data.

Trust us – it's a lot easier to clean up your records beforehand!

Here’s a couple of additional tips to getting that historic data clean:

Remove any unnecessary fields by deleting empty or irrelevant columns.

Like we discussed a moment ago, you can delete any columns from your data that you don’t plan on importing into Donor Management. In many cases, this is a column that’s tracking outdated or irrelevant information; it can also be a blank column that was included when you exported out your historic files.

Either way, deleting those fields will streamline your data and make it easier to continue cleaning and updating your information.

Review your data for any duplicate contacts or records.

While we’ve discussed the ways that Donor Management finds and addresses potential duplicates, we also recommend taking some time reviewing your data prior to import to try to find and minimize those potential duplicate records.

We recommend this for two major reasons: firstly, because you know your data best and will be able to quickly identify and resolve duplicates on your own – and secondly, because reviewing potential duplicates can’t be done in bulk through Donor Management, and you may be able to save yourself time if you review them beforehand. (This is especially important if you’re submitting multiple spreadsheets for import!)

One important thing to note – each donation made by a contact will have its own individual donation record. You should be extra careful when reviewing donation records for duplicates, as it’s possible that two separate donation records may appear to be duplicates when in actuality, they’re completely different.

If your historic data includes a unique ID number for each donor, you can also include that in the “External ID” field in your template. This can help minimize duplicates, and can help make sure historic donations correspond to the correct donor!

Separate organization contact records from individual contact records.

Organizational contacts are treated differently than individual contact records in our importing process. We recommend saving all organizational contacts in a separate Excel file (not tab!) to make it easier for our Import Team to process those correctly.

Remember, organization contact records must be imported in by our Import Team – they can’t be imported in bulk on your own. This means that either way you choose to import data to Donor Management, you’ll need to submit that organization contact file to the team for processing.

Save your import files in the correct file format.

In order to import a file into Donor Management, the file needs to be saved as either an Excel document (.xls or .xlsx), or a Comma Separated Value document (.csv). You may need to change the file format on your historic files to match one of those two formats before you can begin importing into Donor Management.

Make sure your data includes the required fields for each type of record.

Each type of record has a certain set of fields that are necessary to be successfully added to Donor Management. You’ll want to make sure that you’re including those required fields for each record, so that you don’t run into any errors during the import process.

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

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

Review the template to make sure that your existing columns correspond to the template’s fields.

You’ll want to make sure that each column in your existing data records corresponds to a column header in the downloadable template (such as “First Name,” “email address,” etc.)

If you find that you have a column in your existing records that doesn’t correspond with the template, you have two options.

If you’d like to keep that information stored in Donor Management, you can create what’s called a “custom field” to retain that data. (We’ll go over how to create a custom field in an upcoming module.)

Alternatively, if you find that that information might not be necessary to include in your import, you can delete the entire column from your data.

Sending your files to the Imports Team via Donor Management

Once your files have been cleaned and you're confident with their accuracy, you can send those files over to the Imports team for further processing.

To upload those files, click on the "Yes, I'd like to import" on the blue banner located at the top of your Donor Management Dashboard.

If you've already dismissed that blue banner, you can also go to the "Contacts" or "Giving" tab and click on the "Import" button towards the top-right corner of your screen.

On the next screen, click on the option to "Send us your files."

Then, drag and drop in the files that need to be imported from your computer, or use the "click here" option to browse and select the files you're looking to include.

Add any notes or comments you’d like our data import team to see, and then click "Next" in the upper right to complete this process.  

With that, you'll have successfully submitted those files to our team! We'll contact you via email with any questions - so be sure to keep an eye out - and the team let you know when your data import is uploaded into your system and ready for your final review.


Did this answer your question?