Below is a list of the fields supported for standard imports.
Click here for more info on donor history imports; and here for voter data import info (voter personal information and voting history are imported separately under the voter data import). And here's a look at the process for starting a standard import. If you are doing multiple imports of the same kind, you will want to reuse your field mappings.
We recommend not using fields as proxies for other data - doing so makes it difficult to manage your nation and for others to query data relevant for their workflow. Tags are a good place to store extra data points, and you can add multiple tags separated by commas. If you have questions, drop us a line at help@nationbuilder.com. You can also suggest new features related to imports.
.CSV imports are limited to 20mb per file - if your list is larger than that, you will need to divide it into multiple files.
Standard import fields
Items in italics are unique identifiers for NationBuilder. Unique identfiers can only be assigned to one signup record. An email address is a unique identifier and doesn't require a first or last name to be defined with the import. The other unique identifiers must have a first name and last name mapped during the import in order for the signup record to be imported into the nation.
| Field Name | Constrictions |
| must contain valid email address (can be repeated up to four times per profile) | |
| email_opt_in | Y/N |
| prefix | |
| first_name | |
| middle_name | |
| last_name | |
| suffix | |
| name | the full name of someone, leave blank if you provide first/last/middle name separately. |
| legal_name | i.e. William instead of Bill |
| employer | |
| occupation | |
| sex | Must be M/F/O |
| party | 1 character Party abbreivation - full list of political parties |
| religion | |
| church | |
| ethnicity | |
| marital_status | C/D/M/P/S/W -(civil union, divorced, married, domestic partner, single, widowed) |
| is_deceased | Y/N |
| DOB | Birthdate - must be in the form MM/DD/YYYY |
| phone_number | |
| work_phone_number | |
| mobile_number | |
| mobile_opt_in | Willing to receive text messages from nation - Y/N |
| is_mobile_bad | Indicates mobile number is bad and will not accept text messages - Y/N |
| federal_donotcall | On US Federal Do Not Call list - Y/N |
| do_not_call | Does not want to be called by nation - Y/N |
| do_not_contact | Does not want to be contacted by nation - Y/N |
| fax_number | |
| website | Must be valid URL |
| language | Primary spoken language - Two character abreviation |
| created_at | Date joined or imported to nation - must be in the form MM/DD/YYYY |
| support_level | 1 =very strong support and 5 = very strong oppose |
| inferred_support_level | 1(very strong inferred support) to 5 (very weak inferred support) |
| priority_level | value of 1 through 5, with 1 being low priorty and 5 being high priority |
| background | Background field which shows at top of the person's profile |
| availability | |
| household_size | Must be numerical |
| demo | Demographic information |
| tag_list | Tags separated by commas which will be added to person's profile. See Overwrite non-blank fields FAQ entry for more information. |
| assistant_id | NationBuilder ID for assistant |
| assistant_name_or_email | Must be valid member of nation |
| recruiter_id | NationBuilder ID of the recruiter for this person |
| recruiter_name_or_email | Recruiter's name or email address - Must be valid member of nation |
| parent_id | NationBuilder ID for point person for this profile |
| point_person_name_or_email | Point person's name or email address - Must be valid member of nation |
| nationbuilder_id | NationBuilder ID for this person - Must be blank for imports. Must be numerical for updates |
| facebook_uid | |
| twitter_login | |
| twitter_id | At most one Twitter account per record. At most one record per Twitter account. |
| meetup_id | |
| civicrm_id | |
| external_id | |
| address_country_code | |
| address_country | |
| address_state | |
| address_city | |
| address_county | |
| address_zip | |
| address_address1 | |
| address_address2 | |
| address_address3 | |
| address_fips | |
| work_country_code | |
| work_country | |
| work_state | |
| work_city | |
| work_county | |
| work_zip | |
| work_address1 | |
| work_address2 | |
| work_address3 | |
| work_fips | |
| mailing_country_code | |
| mailing_country | |
| mailing_state | |
| mailing_city | |
| mailing_county | |
| mailing_zip | |
| mailing_address1 | |
| mailing_address2 | |
| mailing_address3 | |
| mailing_fips | |
| VOLUNTEER ADDON | |
| is_volunteer | Y/N |
| DONOR ADDON (*indicates has bank account with the NYC option checked) | |
| is_fundraiser | Y/N |
| is_ignore_donation_limits | Y/N |
| donations_to_raise_amount | |
| *doing_business_with_nyc_agency | |
| *doing_business_with_nyc_business_category | |
| MEMBERS ADDON | Learn about setting up memberships |
| membership_level_name | Must exist in nation |
| membership_started_at | must be in the form MM/DD/YYYY |
| membership_expires_at | must be in the form MM/DD/YYYY |
Ian Patrick Hines commented
2013-06-06 15:37:20 -0700
· Flag
Benjamin Lowe commented
2013-06-06 13:06:01 -0700
· Flag
Adriel Hampton commented
2013-04-17 20:06:55 -0700
· Flag
Aaron Selverston commented
2013-04-17 15:19:08 -0700
· Flag
