Our import tool helps you add transactions to Givebutter. Upload a comma-separated value file (CSV), copy and paste contacts from a spreadsheet like Microsoft Excel or Google Sheets, or type info directly into the import table.
👉 Note: Importing transactions will automatically create new contacts for you if our system can't match the data to an existing contact. These contacts will be automatically subscribed to email and SMS messaging if an email and phone number are provided.
Step 1: Prepare your data for import
Your data needs to be formatted properly so you can successfully upload your transactions.
Data formatting can be a time-consuming step, and to help you prepare that data, we recommend using the template below.
Your file must contain the following columns:
Campaign Code - the six digit ID code of an existing Givebutter campaign. (You can find this at the top of your campaign's edit page, above the Title.)
Or Campaign Title - the name of the campaign from your previous platform – the import will create a "shell" campaign in Givebutter with this name
First Name + Last Name - two separate columns, both required
Or Contact ID - existing Givebutter contact ID, which can be found by running a contact export report
Amount - amount donated, not including transaction or platform fees
Payment Method - choose from ACH, Card, Cash, Check, Digital Wallet, Paypal, Venmo, DAF
Transaction date
Optional fields:
Fund Code - existing Givebutter campaigns/funds only
Platform Fee
Processing Fee
Fee Covered - cannot be more than Platform Fee + Processing Fee
External Label (name of the previous platform)
External ID (unique identifier/customer ID from your previous platform)
Acknowledged Date
Check Number
Check Deposit Date
Email
Phone
Address Line 1
Address Line 2
City
State
Postal Code
Country
👉 Note: If one address field has a value, then all address fields must have a value. For example, if Country Code and ZIP Code have a value, then Address 1, City, and State must also contain a value. Incomplete addresses will be deleted.
Once you have completed formatting your data, save the file to your computer or download it as a CSV.
Step 2: Upload the import file and map to Givebutter
Go to Transactions in your Givebutter dashboard, click Actions in the upper right corner, then select New Import.
On the next screen, choose whether to Upload data from file or manually enter data/copy and paste. Supported file types are .csv, .tsv, .xls, .xlsx, .xml, and .txtfile.
To upload data from file:
Click on Upload data from file.
Select the correct file from your computer.
Choose whether the selected row contains a header column.
Confirm matching for your data.
If Givebutter assigned your column to a label that isn't a match, click the dropdown arrow to assign your column to a different Givebutter field/attribute.
If the columns match, click Confirm mapping.
If you have a column that you don't want imported, click Ignore this column.
Once you are happy with your mapping, scroll all the way down and click the blue Review button in the bottom-right corner.
Double-check your data, then click Continue in the bottom-right corner once you're ready to finish the import.
Confirm that you're ready to submit.
You'll be notified by email when your import is complete.
To view your Imports:
In your dashboard, go to Account then click Imports. You'll see a list of your Import history.
If there are failed rows, click the dropdown arrow on the left side of the Import to see why they failed. Reasons will be listed in reference to the specific line item that failed.
If you'd like to download your entire Import file, or just the failed records (for the purpose of correcting them and re-uploading), click the three dots (...) to the right side of the Import Status.
Related Content: