--- title: Bulk Import to NGP VAN description: Learn more about to bulk NGP VAN data with ActBlue Field Tools. --- [Skip to content](https://help.actblue.com/hc/en-us/bulk-import-to-ngp-van#main-content) English - United States Show submenu for translations ![ActBlue](https://help.actblue.com/hubfs/1-B-AB-HorizontalLockupLogo-FullColor-RGB.svg) Open main navigation Close main navigation - English - United States Show submenu for translations - [Contact us](https://help.actblue.com/hc/en-us/requests/new) [Contact us](https://help.actblue.com/hc/en-us/requests/new) How can we help you? - There are no suggestions because the search field is empty. 1. [ActBlue Support Documentation](https://help.actblue.com/hc/en-us) 2. [ActBlue Field Tools (formerly Impactive by ActBlue)](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue) 3. [Data and Integrations](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#data-and-integrations) # Bulk Import to NGP VAN **In this article: ** - [Exporting Outreach Data from Field Tools](https://help.actblue.com/hc/en-us/bulk-import-to-ngp-van#exporting-data)  - [Preparing the CSV for Import](https://help.actblue.com/hc/en-us/bulk-import-to-ngp-van#preparing-import) - [Importing Canvass Results, Activist Codes, and Survey Questions](https://help.actblue.com/hc/en-us/bulk-import-to-ngp-van#importing-canvass) - [Best Practices](https://help.actblue.com/hc/en-us/bulk-import-to-ngp-van#best-practices) ActBlue Field Tools (formerly Impactive) provides automated API integrations for syncing data to NGP VAN. The only thing you’ll need to get started is an active API key from NGP VAN. If an NGP VAN API key is not currently within your budget or otherwise unavailable,, this article will walk you through how to manually export your outreach data and import it into NGP VAN.  --- ### Exporting Outreach Data from Field Tools To capture your volunteer activity, you must first generate the appropriate activity export from your administrator dashboard. 1. **Navigate to Exports:** Log in to your Field Tools dashboard, click the **Data** tab in the sidebar, and select **Exports**. 2. **Create New Export:** Select the **+ New Export** button to begin the process. 3. **Select Export Type:** 1. **NGP VAN Exports** 1. **Messages:** Use this for syncing peer-to-peer or broadcast texting activity to NGP VAN contact history by applying canvasser results with result codes. 2. **Calls:** Use this for syncing phone banking call outcomes to NGP VAN contact history by applying canvasser results with result codes. 3. **Reports:** Use this for volunteer reports that need to be synced to NGP VAN survey questions or activist codes. 4. **Define Parameters:** Set the specific date range, activity types, contact lists, and individual activities you wish to sync to NGP VAN. 5. **Generate and Email:** Once the export is requested, the system will process the request and email you a secure link to download the results as a CSV. --- ### Preparing the CSV for Import Before uploading to NGP VAN, ensure your data is clean and formatted correctly to prevent import errors. - **File Format:** Ensure the file remains in **.csv** format and that no data is lost when making changes. - **Identify Records:** If your list was originally pulled from NGP VAN, ensure every row has a **VANID**. If no VANID is present, ensure the **phone, first\_name, last\_name, state\_or\_province, city, and zip\_or\_postal\_code** columns are clear for record matching. - **Select Contact Type:** Select the appropriate **contact\_type** from the dropdown provided. - **Select Result Code:** Select the appropriate **result\_code** from the dropdown provided. For calling, each call outcome will have to be mapped to the appropriate result code. - **Select Survey Question ID:** For report exports, select Survey Question. Next, look up the **survey\_question\_id** you’d like to sync in NGP VAN and input it into the field provided. - **Select Activist Code ID**: For report exports, select Activist Code. Next, look up the **activist\_code\_id** for each Tag you’d like to sync in NGP VAN and input it into the field provided. --- ### Importing Canvass Results, Activist Codes, and Survey Questions Once you have your CSV, follow these steps within NGP VAN to record your results. 1\. **Access Bulk Import:** In NGP VAN, navigate to **Contacts** and select **Bulk Import** from the menu. 2\. **Upload File:** Select **Upload a File** and choose your prepared CSV from Field Tools. 3\. **Map Field Tools Data:** Match the columns from your export to the corresponding CRM fields. You can refer to the tables below as a helpful reference. **Contact History** | **Property** | **Type** | | --- | --- | | \*van\_id | Int | | \*result\_code\_id | Int | | input\_type\_id | Int | | contact\_type\_id | Int | | phone\_id | Int | | date\_canvassed (defaults to current timestamp) | Datetime | **Activist Codes** | **Property** | **Type** | | --- | --- | | \*van\_id | Int | | \*activist\_code\_id | Int | | \*action | String - one of ‘Apply’ or ‘Remove’ | | input\_type\_id | Int | | contact\_type\_id | Int | | date\_canvassed (defaults to current timestamp) | Datetime | **Survey Questions** | **Property** | **Type** | | --- | --- | | \*van\_id | Int | | \*survey\_question\_id | Int | | \*survey\_response\_id | Int | | input\_type\_id | Int | | contact\_type\_id | Int | | date\_canvassed (defaults to current timestamp) | datetime | 4\. **Configure Settings:** - - **Database Mode:** Choose **MyVoterfile** for voter contact or **MyCampaign** for volunteer/donor management. Note that all NGP (fundraising) exports must use MyCampaign. 5\. **Review and Finish:** Review the import summary for any errors or mismatched records before clicking **Finish** to process the data. --- ### Best Practices Always run a small sample import of 5-10 rows before processing a full database sync to ensure your mapping for Survey Questions and Activist Codes is accurate. - [Donors & Grassroots Fundraisers](https://help.actblue.com/hc/en-us/donors-grassroots-fundraisers#main-content) - [Contributions](https://help.actblue.com/hc/en-us/donors-grassroots-fundraisers#contributions) - [ActBlue Express Accounts](https://help.actblue.com/hc/en-us/donors-grassroots-fundraisers#actblue-express-accounts) - [Raising Money for Campaigns and Organizations](https://help.actblue.com/hc/en-us/donors-grassroots-fundraisers#raising-money-for-campaigns-and-organizations) - [About ActBlue](https://help.actblue.com/hc/en-us/donors-grassroots-fundraisers#about-actblue) - [Other](https://help.actblue.com/hc/en-us/donors-grassroots-fundraisers#other) - [Core ActBlue](https://help.actblue.com/hc/en-us/core-actblue#main-content) - [Getting Started with Your Core Dashboard](https://help.actblue.com/hc/en-us/core-actblue#getting-started-with-your-core-dashboard) - [Managing & Granting Access to Your Core Dashboard](https://help.actblue.com/hc/en-us/core-actblue#managing-granting-access-to-your-core-dashboard) - [Creating & Managing Core Contribution Forms](https://help.actblue.com/hc/en-us/core-actblue#creating-managing-core-contribution-forms) - [Managing Grassroots Fundraising for Core Donors](https://help.actblue.com/hc/en-us/core-actblue#managing-grassroots-fundraising-for-core-donors) - [Working with Core Contribution Forms](https://help.actblue.com/hc/en-us/core-actblue#working-with-core-contribution-forms) - [Core Contribution Form Features](https://help.actblue.com/hc/en-us/core-actblue#core-contribution-form-features) - [Selling Tickets & Merchandise with Core](https://help.actblue.com/hc/en-us/core-actblue#selling-tickets-merchandise-with-core) - [Refunding & Managing Core Contributions](https://help.actblue.com/hc/en-us/core-actblue#refunding-managing-core-contributions) - [Reporting & Accessing Your Core Fundraising Data](https://help.actblue.com/hc/en-us/core-actblue#reporting-accessing-your-core-fundraising-data) - [Signing In & Using 2FA in Core](https://help.actblue.com/hc/en-us/core-actblue#signing-in-using-2fa-in-core) - [Managing Your Merchant Account in Core](https://help.actblue.com/hc/en-us/core-actblue#managing-your-merchant-account-in-core) - [Activating & Managing Express Lane in Core](https://help.actblue.com/hc/en-us/core-actblue#activating-managing-express-lane-in-core) - [Fundraising Strategy in Core](https://help.actblue.com/hc/en-us/core-actblue#fundraising-strategy-in-core) - [Integrations & Analytics in Core](https://help.actblue.com/hc/en-us/core-actblue#integrations-analytics-in-core) - [Other Core FAQ](https://help.actblue.com/hc/en-us/core-actblue#other-core-faq) - [Using Call Time in Core](https://help.actblue.com/hc/en-us/core-actblue#using-call-time-in-core) - [Raise by ActBlue](https://help.actblue.com/hc/en-us/raise-by-actblue#main-content) - [Getting Started with Your Raise Dashboard](https://help.actblue.com/hc/en-us/raise-by-actblue#getting-started-with-your-raise-dashboard) - [Raise FAQs](https://help.actblue.com/hc/en-us/raise-by-actblue#raise-faqs) - [Managing & Granting Access to Your Raise Dashboard](https://help.actblue.com/hc/en-us/raise-by-actblue#managing-granting-access-to-your-raise-dashboard) - [Managing Your Merchant Account in Raise](https://help.actblue.com/hc/en-us/raise-by-actblue#managing-your-merchant-account-in-raise) - [Creating & Managing Raise Fundraising Pages](https://help.actblue.com/hc/en-us/raise-by-actblue#creating-managing-raise-fundraising-pages) - [Managing Your Conduit Account In Raise](https://help.actblue.com/hc/en-us/raise-by-actblue#managing-your-conduit-account-in-raise) - [Reporting & Accessing Your Raise Fundraising Data](https://help.actblue.com/hc/en-us/raise-by-actblue#reporting-accessing-your-raise-fundraising-data) - [ActBlue Field Tools (formerly Impactive by ActBlue)](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#main-content) - [Getting Started](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#getting-started) - [Contacts](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#contacts) - [Users](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#users) - [Data and Integrations](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#data-and-integrations) - [Training Volunteers](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#training-volunteers) - [Texting (Peer-to-Peer, Broadcast, and Automated)](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#texting-peer-to-peer-broadcast-and-automated) - [Phone Banking](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#phone-banking) - [Friends and Family Messaging (Relational)](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#friends-and-family-messaging-relational) - [Canvassing](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#canvassing) - [Voter Registration](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#voter-registration) - [Forms](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#forms) - [Other Actions (Social Sharing, Open Webpage)](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#other-actions-social-sharing-open-webpage) - [Best Practices & Ideas](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#best-practices-ideas) - [Billing & Account Management FAQs](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#billing-account-management-faqs) - [Frequently Asked Questions](https://help.actblue.com/hc/en-us/actblue-field-tools-formerly-impactive-by-actblue#frequently-asked-questions) - [ActBlue Website Builder (formerly Hey Victor)](https://help.actblue.com/hc/en-us/actblue-website-builder-formerly-hey-victor) - [Other FAQs](https://help.actblue.com/hc/en-us/other-faqs#main-content) - [Applying for a New Account FAQs](https://help.actblue.com/hc/en-us/other-faqs#applying-for-a-new-account-faqs) - [Sign In & 2FA FAQs](https://help.actblue.com/hc/en-us/other-faqs#sign-in-2fa-faqs) - [Post-Election FAQs](https://help.actblue.com/hc/en-us/other-faqs#post-election-faqs) - [ActBlue FAQs](https://help.actblue.com/hc/en-us/other-faqs#actblue-faqs) [![1-AB-TaglineLockup-Horizontal-Brand-5.20.25-02](https://help.actblue.com/hs-fs/hubfs/ActBlue%20Logos/1-AB-TaglineLockup-Horizontal-Brand-5.20.25-02.png?width=410&height=40&name=1-AB-TaglineLockup-Horizontal-Brand-5.20.25-02.png "1-AB-TaglineLockup-Horizontal-Brand-5.20.25-02")](https://secure.actblue.com/) Copyright © 2025, ActBlue