The Import feature in Bloomerang allows you to upload a spreadsheet of data into your database in a few easy steps. Before you run your import, please take a moment to read through the FAQs and tips below.
What kind of data can I import?
You may import:
- Constituents: Import any data on the Profile page. Use it to create or update constituent records.
- Donations: Create new donation records. You may also include constituent profile data.
- Interactions: Create new interactions. You may also include constituent profile data.
- Notes: Create new notes. You may also include constituent profile data.
Warning: You cannot currently create or update pledges, pledge payments, recurring donations, and tasks using an import. These must be entered manually. Households cannot be created via import, but you can use household account numbers to update the household name fields, or import to the head of household.
What type of file can I use for import?
Your data must be in a CSV (comma-separated values) file. If the data is in an Excel file, use Excel's "Save As" option and choose to save it as a CSV file.
How big of a file can I import?
Your import file can be up to 10,000 rows long and a maximum of 2MB in size.
What are the required fields?
The required fields depend on what you are importing.
- Individuals: First name, last name
- Organizations: Organization name
- Households: Account Number
- Donations: Constituent required fields, plus date, amount, and fund
- Interactions: Constituent required fields, plus date, subject, purpose, and channel
- Notes: Constituent required fields, plus date, and note
Tip: If you want to add data to existing constituents, also include information to match constituents. We recommend the Bloomerang account number. See Update Constituents via Import.
How do I match constituents?
Constituents or organizations match when the account numbers match, or when the name matches and one of the following matches:
- Email address
- Standardized street address
- Last seven digits of phone number
See Search for more details.
How should my import file be set up?
Set up your file like this:
- Separate individual and organization data into different spreadsheets. You need to import this data separately.
- Include a header row. Each column should have a heading that clearly labels what data it contains.
- When updating household name fields, include the household account number.
- Use column headings that closely relate to the field names in Bloomerang. This makes your import easier later. For example, name a heading "First Name" instead of "f_name."
- Split name and address data into their individual components. If the data is in its own field in Bloomerang, it needs its own column in your import file.
- Name data: For instance, title, first name, middle name, last name, and suffix should be separate. Don't import "John Doe" in a Name column.
- Address data: For instance, address, city, state, and ZIP code information should be separate.
- Create columns for each address, email, and phone type. For instance, your column headers might be Home Address, Work Address, Home Email, Work Email, Work Phone, Mobile Phone, and so on.
Note: If there are multiple columns of a type, the last column in the spreadsheet will be marked primary in the database.
- Change any phone number columns to be Text type, especially if you are importing international phone numbers. Double-check that Excel does not change the number when you save the file in CSV format.
- Remove all blank lines from your file.
- You can import data into custom fields. If you are importing into a pick-multiple custom field, enter all applicable values in the same cell, separated by a pipe: |.
Download these templates to get started.
Tip: Before importing your whole file, create a file with one or two rows of data. Use this file to test your import.