CSV Template

Donations,ready for the NPSP Data Importer.

Collect gifts and their donors in the column headers of Salesforce NPSP's Data Importer, with donor keywords, amounts, dates, record types and campaigns checked before the CSV goes into Salesforce.

NPSP Data Importer headersDonor, amount and date checkedTry it free

Salesforce NPSP Donations

Try the template with up to 3 rows

What You'll Collect

Donor name & email

String
*Required

Contact1 First Name, Last Name and Personal Email, which the importer uses to match a donor to an existing contact.

Donation Donor

Enum
*Required

Contact1 for a person or household, Account1 for an organization: a keyword, not a name.

Organization gifts

String
*Required

Account1 Name for companies, foundations and churches.

Amount & date

Number
*Required

An amount without symbols or commas, and a date in your Salesforce locale order.

Record type & stage

Enum
*Required

Donation, Grant, In-Kind Gift, Major Gift, Matching Gift or Membership; stage left blank for Closed Won.

Campaign & payment

String
*Required

The campaign name, payment method and check number, and a tribute type and honoree name.

Need more than three rows?

Collect gifts from every event and office.

The free template is limited to three rows so you can try the workflow. Create your own form to send to each fundraiser or event lead, and get one clean file back instead of a different spreadsheet from every campaign.

Create your own form

NPSP's column headers

The labels of the Data Importer's staging fields, so the columns map without renaming.

Checked as they type

Donor keywords, amounts with symbols, dates in the wrong format, emails and record type names are flagged.

Your own fields

Add an appeal code or batch name to your own form.

Up to 1,000 rows

Room for a whole campaign's gifts in one file.

How it works

From the gift to Salesforce in three steps.

01

Collect

Import a spreadsheet of gifts, or send the form to each event lead.

02

Complete

One gift per row. Missing donors, amounts with symbols and dates in the wrong order are highlighted.

03

Download and import

Download the CSV and import it with the NPSP Data Importer, starting with a dry run on a few records.

Why use a form?

A gift on the wrong donor is hard to undo.

The Data Importer matches each row to a contact or organization by name and email, and the Donation Donor column says which one gets the gift. A donor spelled two ways becomes two contacts, and a donor name typed in that column matches nobody.

A form checks each row as it's entered, so gifts land on the right donor the first time.

Donor spelled two ways

Mary Smith and Mary Smyth become two contacts. Repeat the same donor details on every row for the same person.

A name in Donation Donor

This column takes only the keyword Contact1 or Account1, never a donor's name.

Dates in the wrong order

Dates follow your Salesforce locale. A day and month the wrong way round can silently become a different date.

Salesforce NPSP donations import template

How the NPSP Data Importer reads a donations file

The Nonprofit Success Pack (NPSP) is Salesforce's fundraising layer for nonprofits. Its Data Importer reads a CSV of contacts, organizations and donations in one pass, matching each row to existing records and creating the rest.

The column headers are the labels of the importer's staging fields, such as Contact1 First Name, Home Zip/Postal Code, Donation Amount and Donation Date. Each row is one gift. A donor with several gifts repeats the same contact details on several rows. Donation Donor is the keyword Contact1 for a person or household, or Account1 for an organization.

Contacts are matched on first name, last name, email or a legacy ID, so a donor written differently on two rows can become two contacts. Dates follow your Salesforce locale, the stage defaults to Closed Won when left blank, and the record type is one of Donation, Grant, In-Kind Gift, Major Gift, Matching Gift or Membership.

This template uses those headers and checks each column as it's filled in. It covers the common donor, gift and tribute fields, and leaves out the payment gateway and membership fields. Compare the headers with the NPSP template for your org, and run the importer's dry run on a few records first.

Need a CSV form of your own?

Create a custom Import Builder form with your own fields, validation and row limits.

Get started
Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by Salesforce. Salesforce is a trademark of Salesforce, Inc. Columns as described in Salesforce's NPSP Data Importer documentation, November 2026.