How can I Import Past Donation History

You can import your historical donation and contact records into BetterUnite by uploading a CSV file. CSV (comma-separated values) is a plain-text format with no special formatting, making it one of the most widely used formats for data import and export. You can create a CSV file by saving any Excel or spreadsheet file in CSV format.

To import your past donations, prepare a spreadsheet that includes fields such as payment type, date, amount, first name, last name, and email address. We strongly recommend downloading and using our provided starter template before building your own file — it ensures your data is structured correctly and makes the import process faster and more accurate.

We recommend uploading your contacts into the system first, rather than importing donation history all at once. Refer to article How to upload contacts for further details. After the contacts are imported, you only need to have the email address on the donation import file for the system to match it against a unique contact in the system. If your original system has the concept of account numbers, you can also use this as the unique identifier, as long as you also import this in the contact import.

To get started, click Giving in the top navigation area, and select Transactions to see the current donations list.

On the page, locate the Action button and select the "Upload from a file" option.

This will take you to the Upload Donations page, where you will see a link to our starter template file, as well as the action button to start your import process if you already have your import file ready.

Follow the instructions and guidelines on this page in preparing your import file. When your file is ready click on the Browse button and select your prepared file. Below is an example of a prepared file.

When you're ready, click the Import button to upload your file for analysis. The first step in the upload process (selecting your file by clicking the Import button), is the mapping step. Basically BetterUnite takes your file, uploads it to the server, and analyzes it to show the columns we see in the file, as well as some of the first few rows of the data itself just for reference/validation purposes. In the mapping step, you will be able to associate each column in your import file with an attribute of a BetterUnite donation and contact record. For instance, in your import file, you may have named your First Name column as "F.Name", and BetterUnite would now know to associate this with the First Name field of the contact records, so the mapping is where you would tell us this association. Note that when this page first loads, we will try to match fields and their common name variations automatically to give you a head-start on the mapping activity.

On the mapping page you can also specify whether the first row includes header information/column names or not. Based on this, the import may include or ignore the first row so that your columns name row is not inserted as a new contact record.

When you complete the mapping activity, click the appropriate button to start the import process. The import process is an asynchronous process, where the file is submitted, and queued, and the system processes the queue in a few seconds. The total processing time may vary based on the size of your uploaded file. When the import is complete, you will be taken to a summary page where we will display the rows that were attempted to be imported. You will see various colors on each row, based on if that row was imported, updated, or had a warning or an error.

Green: The record is imported successfully

Red: Warning or Error

In the example below the second row has given an error as the campaign name was not entered correctly on this record.

BetterUnite matches records using email address and other unique identifiers (as described on the import pages). If you need to fix errors, you have two options:

• Re-import the full file after making corrections — the system will update any previously imported records based on the matching criteria.
• Recommended: Copy only the rows with errors into a new spreadsheet, correct them, and import that smaller file. This reduces the risk of creating duplicate records.

If you have questions about importing donations, contact our support team or visit the BetterUnite Knowledge Base for more resources. Let's go do some good.