Published 26 March 2020

How to Import Data to Salesforce Nonprofit Success Pack (NPSP)

decor decor


Importing data into Salesforce Nonprofit Success Pack is complicated, time-consuming and sure to frustrate. So much so that Salesforce acknowledges this with the aptly titled Why is it so complicated? section located at the beginning of their Data Import Documentation.

This article will outline core steps to import data into Salesforce using the NPSP Data Import Tool, and provide recommendation as to a different way to achieve a better end state without the human resources burden and lengthy delays between data imports which are endemic to the NPSP Data Import Tool.

Overview of using the NPSP Data Import Tool

To fully understand how the NPSP Data Import Tool works and to obtain a step-by-step guide as to how to use it, visit

Core steps to import data into Salesforce NPSP are as follows:

  1. Export, clean and format your existing data (view steps involved)
  2. Transfer existing data into the NPSP Data Import Template (view steps involved and download Data Import Template)
  3. Upload your NPSP Data Import Template into the NPSP Data Import Object (view steps involved)
  4. Verify the uploaded data in Salesforce using a Dry Run (view steps involved)
  5. Process your import (view steps involved)

In addition to understanding the core steps, we also recommend reading the following article which outlines best practice processes around NPSP data import: Written by Salesforce and based on thousands of technical support cases, it recommends breaking your import into smaller files so the reduced number of columns make your spreadsheet readable and thus it becomes easier to see and fix bad data before it is imported into Salesforce.

Limitations of using the NPSP Data Import Tool

If your organisation masters using the NPSP Data Import Tool you will be ahead of most, but will still face the following key issues.

First, there is a human resourcing (and upskilling) cost associated with cleaning and formatting your data before using the NPSP Data Import Tool. Processing time can be reduced by creating Excel Macros to transform data into required structures and alert where mandatory information is not present – but these are complicated, technical files which not only need to be built but also maintained when the source data or your Salesforce instance changes. This is further complicated if data needs to be imported from different third party systems which format source data uniquely, and is complicated again if you have large volumes of data to import.

And outside of the time required to do this and opportunity cost of what you might otherwise be doing, there is the ever-present issue of human error. If you are importing thousands, hundreds or even tens of records – you are probably going to get errors in your data and these are difficult to identify and undo once imported into Salesforce.

Second, there is a time delay associated with manually importing data. If you are importing weekly then there is up to seven days of delay before that data can be actioned. If you are importing monthly then data will be out by up to thirty-one days. This means your organisation will not be able to run marketing automation effectively, and that the email or SMS which eventually gets sent to a fundraiser loses context. That sales call to your major donor is made a couple of weeks after the donation happens. Your reporting dashboards are weeks out of date and your organisation won’t be able to identify important issues or opportunities as they arise. To gain these capabilities, you need to automatically be importing data into Salesforce in real time.

Use MoveData to automate real time data into Salesforce NPSP

Yes we are plugging our own product but the answer is MoveData. We have already written real time API integrations with a wide range of industry platforms and all of these can be turned on for your Salesforce instance. Using MoveData, the moment an event occurs it is imported into your Salesforce instance and correctly maps against your existing Salesforce structures. You save time while reducing opportunity cost, and gain new capabilities to run real time sales, marketing, business intelligence and other important initiatives.

MoveData works out of the box with Salesforce NPSP and is priced competitively starting from just $249 per month for a single API integration or $399 for unlimited API integrations. If you are interested in using MoveData or learning more then contact us so we can have a friendly chat and arrange a demonstration.

Continue reading

View all posts

What people are saying about MoveData

Keeping Salesforce up to date used to be a real challenge. With MoveData everything is automated and it’s been one of the best technical decisions we’ve made!

Henry Wong Senior Salesforce Analyst Developer, UNICEF Australia

War Child UK saves 67.5 hours per month by using MoveData

Yvonne Small Database Coordinator, War Child UK

I can’t even tell you how many hours this has saved us. To have all our data integrated into Salesforce is extraordinary!

Lauren Stewart Senior Manager Systems and Data, The Alfred Foundation

Having implemented MoveData everything is so much more efficient – all that wasted time is gone!

Kate Griffiths Income Generation & Engagement Manager and Data Protection Officer, The Fire Fighter’s Charity

MoveData has made our life so much easier!

Maria Papaly CRM Development Manager, Oxfam Australia

MoveData delivers thousands of data points into Salesforce every day - this allows us to successfully run World's Greatest Shave and our other major campaigns

Glen Shields Head of Data & Analytics, Leukaemia Foundation

MoveData has helped us be much more effective in our fundraising - it cut out so much of the admin that swamped us last year!

Larissa Wiese Marketing and Communications Manager Breast Cancer Care WA

The MoveData team are amazing! I would recommend their integrations to any non-profit that is looking to better manage and automate their incoming data flows.

Conor Nolan Digital Executive, Cure Cancer Australia

The efficiency, accuracy and time savings have been a game changer for our foundation. I cannot recommend MoveData highly enough!

Carolyn Campbell Operations, Shake It Up Australia Foundation

MoveData are excellent to work with - I would recommend their services to anyone seeking to integrate fundraising and donation data into Salesforce

Emma Karst Digital Marketing Specialist, Caritas Australia

MoveData integrations are flexible, accurate and easy to use - and have already saved us loads of admin time. Thank you so much!

Jo Price IT Integration and Transformation Manager, Sydney Children's Hospital Foundation

A really positive experience - the MoveData team are knowledgeable, responsive and great at problem solving

Katrina Locandro Marketing & Communications Manager, Liptember Foundation

Proudly used by


Powerful Salesforce Integration
for Smart Nonprofits