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 firstname.lastname@example.org. 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.
|must contain valid email address (can be repeated up to four times per profile)|
|name||the full name of someone, leave blank if you provide first/last/middle name separately.|
|legal_name||i.e. William instead of Bill|
|sex||Must be M/F/O|
|party||1 character Party abbreivation - full list of political parties|
|marital_status||C/D/M/P/S/W -(civil union, divorced, married, domestic partner, single, widowed)|
|DOB||Birthdate - must be in the form MM/DD/YYYY|
|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|
|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|
|household_size||Must be numerical|
|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|
|twitter_id||At most one Twitter account per record. At most one record per Twitter account.|
|DONOR ADDON (*indicates has bank account with the NYC option checked)|
|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-10-23 12:25:46 -0700We do plan to support importing relationships, however we don’t have a specific timeline for the feature.
Hunter Holliman tagged this with Helpful 2013-10-22 09:40:18 -0700
Josh Stuart commented 2013-10-20 09:30:07 -0700Is it going to be possible to to import relationship data (spouse of, employee of etc) at any point?
Josh Stuart tagged this with Helpful 2013-10-20 09:23:21 -0700
Ian Patrick Hines commented 2013-10-08 08:46:29 -0700David — “address_address” is the home address. The other addresses are essentially what they’re called (i.e., mailing_address is the mailing address).
You can learn more about the addresses available on imports, here: http://nationbuilder.com/what_addresses_are_available_in_each_import
David Sloane commented 2013-10-07 18:07:20 -0700If you could describe the differences between “address address” and “mailing address”, that would be helpful.
Rob Green tagged this with Not helpful 2013-09-15 14:36:03 -0700
Sandy Biar commented 2013-08-12 06:15:33 -0700Why not allow data to be imported straight into the ‘inferred party’, ‘inferred support level’ and voting district fields? That would save a lot of time tagging, creating a list and then batch updating.
Manu Kabahizi tagged this with Important 2013-06-14 11:36:57 -0700
Ian Patrick Hines commented 2013-06-06 15:37:20 -0700Hey Benjamin — That’s a great question. It’s actually not possible to map LinkedIn URL during an import, though if you map an email address NationBuilder Match will often match them to their LinkedIn profiles.
Benjamin Lowe commented 2013-06-06 13:06:01 -0700How do I import LinkedIn URLs? That’s a standard field in the database but I can’t see how to bring those records in through a CSV.
Benjamin Lowe tagged this with Important 2013-05-20 12:53:14 -0700
Adriel Hampton commented 2013-04-17 20:06:55 -0700Aaron, ethnicity is a free text field because there are a huge number of ethnic groups around the world – http://en.wikipedia.org/wiki/List_of_ethnic_groups – and hard-coding that would reduce the value of the field for our diverse base of customers.
Aaron Selverston commented 2013-04-17 15:19:08 -0700It would be good to add standard Ethnicity codes.
Paula Guthat tagged this with Important 2013-03-11 12:00:27 -0700
Jay Matthew tagged this with Important 2013-03-05 14:39:59 -0800
Adriel Hampton tagged this with Important 2013-03-01 09:49:12 -0800