How to import

Seamlessly importing custom data into NationBuilder doesn't have to be hard. We've put together a list of our import fields and helpful tips, and you'll also want to check out these additional tutorials if they apply:

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.

Note: CSV imports are limited to 50mb 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 person to be imported into the nation.

Field Name Constrictions
email 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 e.g. William instead of Bill
employer  
occupation  
sex Must be M/F/O
party 1 character Party abbreviation - 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 include the area code
work_phone_number include the area code
mobile_number include the area code
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 include the area code 
website Must be valid URL
language Primary spoken language - Two character abbreviation
created_at Date joined or imported to nation - must be in the form MM/DD/YYYY
support_level 1 =very strong support to 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  
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_name_or_email Must be valid person in your nation
recruiter_id NationBuilder ID of the recruiter for this person
recruiter_name_or_email Recruiter's name or email address - Must be valid person in your 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 person in your nation
id (Under 'Signup') NationBuilder ID for this person - Must be blank for imports. Must be numerical for updates
signup_type 0 = person, 1 = organization
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  2 letter code from ISO 3166
address_country  
address_state  
address_city  
address_county  
address_zip  
address_address1  
address_address2  
address_address3  
address_fips  
work_country_code   2 letter code from ISO 3166
work_country  
work_state  
work_city  
work_county  
work_zip  
work_address1  
work_address2  
work_address3  
work_fips  
mailing_country_code   2 letter code from ISO 3166
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 Membership information can only be imported from Settings > Defaults > Membership types > Import memberships

Related how to guides

Do you like this page?

Showing 23 reactions

Wrap code snippets in <code></code> tags.
Please check your e-mail for a link to activate your account.

Not finding what you're looking for? Browse the People FAQs →