--- schema_version: "1" id: 2d736fd042317dcfaef98805ffd722571edf50bd6abe38ca96394a42ce61862d title: Configure NPSP Data Importer collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/sfdo/264-0-0/npsp_data_importer.md canonical_url: https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 5401c58839b0d9e1bfdd4405c73b4fb7d6cd84216a054ff6b060193115b78de7 description: Prepare your organization for importing data from spreadsheets by following these NPSP Data Importer set up instructions. products: - Nonprofit release: "264" --- # Configure NPSP Data Importer Prepare your organization for importing data from spreadsheets by following these NPSP Data Importer set up instructions. - **[About NPSP Data Importer](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5)** The NPSP Data Importer simplifies the import process into a single spreadsheet. What would have been several CSV files becomes one row of data combining constituent and donation data. The NPSP Data Importer, along with Advanced Mapping, then writes that data to the appropriate objects in Salesforce. - **[Set Tab Visibility](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5)** Make the NPSP Data Imports tab available in the App Launcher. - **[Set Object and Field-Level Security](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5)** Grant access to the NPSP Data Import object and fields. - **[Enable and Convert to Advanced Mapping](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5)** Find out more about enabling and converting advanced mapping. ## About NPSP Data Importer The NPSP Data Importer simplifies the import process into a single spreadsheet. What would have been several CSV files becomes one row of data combining constituent and donation data. The NPSP Data Importer, along with Advanced Mapping, then writes that data to the appropriate objects in Salesforce. NPSP Data Importer uses the NPSP Data Import object. The information from your CSV is first imported into fields on the NPSP Data Import object, and when you process the import, that information is passed from the fields on the NPSP Data Import object to the corresponding field on the target objects. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/images/icon_note.png) Note We recommend that only System Admins use the NPSP Data Importer tool. Learn how the importer tool works in [How the Import Process Works](https://help.salesforce.com/s/articleView?id=sfdo.npsp_how_process_works.htm&release=264.0.0&type=5 "Find out more about the import process."). ## Set Tab Visibility Make the NPSP Data Imports tab available in the App Launcher. 1. Click ![Setup](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/resources-product/images/setup.png), then click **Setup**. 2. From Setup, enter Profiles in the Quick Find box, then select **Profiles**. 3. For each profile that you want to give access to, click the name of the profile. 4. Click **Object Settings**. 5. In the list of objects, find and click **NPSP Data Imports**. 6. Click **Edit**. 7. In Tab Settings, select **Default On**. 8. Save the profile settings. Next, grant other appropriate profiles access to the NPSP Data Imports tab. Repeat the above process for each of those profiles. ## Set Object and Field-Level Security Grant access to the NPSP Data Import object and fields. 1. From Setup, enter Profiles in the Quick Find box, then select **Profiles**. 2. For each profile that you want to give access to, click the name of the profile. (For example, click System Administrator.) 3. Click **Object Settings**. 4. In the list of objects, find and click **NPSP Data Imports**. 5. Select **Read**, **Create**, **Edit**, and **Delete** under Object Permissions. 6. In Field Permissions, select **Read Access** and **Edit Access** for all fields. 7. Save the profile settings. Next, grant other appropriate profiles access to the NPSP Data Import object and fields. Repeat the above process for each of those profiles. ## Enable and Convert to Advanced Mapping Find out more about enabling and converting advanced mapping. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/images/icon_note.png) Note Watch the Nonprofit Salesforce How-To Series video: [Enable Advanced Mapping.](https://www.youtube.com/watch?v=0Wh6D9nLOM8) - **[Overview](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5)** Advanced Mapping is the logic that powers the NPSP Data Importer tool. Advanced Mapping gets your data to the right place when you import data from a spreadsheet. - **[Enable My Domain](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5)** In order to use Advanced Mapping, My Domain must be enabled and deployed (if it isn't already). My Domain is a Salesforce identity feature that adds a subdomain to your Salesforce org. It's required for features like Advanced Mapping that are built using Lightning components in Lightning component tabs. - **[Set Advanced Mapping Apex Permissions](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5)** You need to enable access to an Apex class to access Advanced Mapping. Advanced Mapping is an important component in the NPSP Data Importer. - **[Enable Advanced Mapping](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5)** Follow these steps to enable advanced mapping. - **[Help Text Mappings that Didn't Convert](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5)** If some of your existing Help Text mappings were invalid, you'll receive a message at the bottom of the Data Import Advanced Mapping screen with a list of Help Text mappings that didn't convert. ### Overview Advanced Mapping is the logic that powers the NPSP Data Importer tool. Advanced Mapping gets your data to the right place when you import data from a spreadsheet. Advanced Mapping is already set up to handle typical import scenarios involving constituent and donation data. For most organizations, very little or no customization of Advanced Mapping is needed. Learn more about Advanced Mapping in [Advanced Mapping Overview](https://help.salesforce.com/s/articleView?id=sfdo.npsp_adv_mapping_overview.htm&release=264.0.0&type=5 "Advanced Mapping gives you the flexibility to send data to most Salesforce objects related to Contacts, Accounts, and Opportunities."). ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/images/icon_note.png) Note Previous versions of NPSP used Help Text Mapping to accomplish what Advanced Mapping does today. When you enable Advanced Mapping, NPSP automatically converts your Help Text mappings into Advanced Mappings. You can disable Advanced Mapping and go back to Help Text mapping at any time, but any changes you made with Advanced Mapping will be lost and won't be synced back to Help Text. ### Enable My Domain In order to use Advanced Mapping, My Domain must be enabled and deployed (if it isn't already). My Domain is a Salesforce identity feature that adds a subdomain to your Salesforce org. It's required for features like Advanced Mapping that are built using Lightning components in Lightning component tabs. To find out if My Domain is enabled in your org, go to Setup and search for My Domain. For information on setting up My Domain, see [My Domain](https://help.salesforce.com/articleview?id=domain_name_overview.htm). ### Set Advanced Mapping Apex Permissions You need to enable access to an Apex class to access Advanced Mapping. Advanced Mapping is an important component in the NPSP Data Importer. To enable this Apex class access: 1. From Setup, type Profiles in the Quick Find box, then click Profiles. 2. Select the profile you'd like to edit. 3. Select Apex Class Access. 4. Click **Edit**. 5. Add the npsp.BDI\_ManageAdvancedMappingCtrl class into the Enabled Apex Classes box. 6. Click **Save**. ### Enable Advanced Mapping Follow these steps to enable advanced mapping. 1. Click the **NPSP Settings** tab. If you don't see the tab, find it in the App Launcher (![App Launcher icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/resources-product/images/app_launcher_icon.png)). 2. Click **System Tools** | **Advanced Mapping for Data Import & Gift Entry**. 3. Click the button to switch to **Enabled**. 4. It may take a few moments for NPSP to convert all of your existing Help Text mappings. When your help text has been converted to Advanced Mapping, you'll see a **Configure Advanced Mapping** button on this page. ![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/images/icon_important.png) Important If your org includes invalid Help Text mappings, you’ll see another section below the **Configure Advanced Mapping** button. Read more about [Help Text Mappings that Didn't Convert](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5 "If some of your existing Help Text mappings were invalid, you'll receive a message at the bottom of the Data Import Advanced Mapping screen with a list of Help Text mappings that didn't convert."). When you click **Configure Advanced Mapping**, you see a list of the out-of-box Object Groups that converted from Help Text mapping. You're ready to [Customize Advanced Mapping](https://help.salesforce.com/s/articleView?id=sfdo.npsp_use_advanced_mapping.htm&release=264.0.0&type=5 "Customize Advanced Mapping for data import if you want to map data into an object or field that hasn't yet been mapped."). ### Help Text Mappings that Didn't Convert If some of your existing Help Text mappings were invalid, you'll receive a message at the bottom of the Data Import Advanced Mapping screen with a list of Help Text mappings that didn't convert. ![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/images/icon_important.png) Important The list of invalid Help Text mappings will not be displayed again unless you disable and re-enable Advanced Mapping; take a screenshot of this page or copy the information in the table so you know which mappings to correct. For more information about why these are invalid, see [Troubleshoot Invalid NPSP Data Import Help Text Mappings (Legacy)](https://help.salesforce.com/s/articleView?id=sfdo.npsp_troubleshoot_ht_mappings.htm&release=264.0.0&type=5 "The legacy NPSP method to connect NPSP Data Import fields to the target fields is through the NPSP Data Import field's Help Text."). To correct these mappings, choose one of these options: - **Recommended:** Turn off Advanced Mapping and correct the invalid Help Text mappings in the NPSP Data Import object. When you re-enable Advance Mapping, the Help Text mappings are converted to Advanced Mapping. - **This option is only appropriate if you will keep Advanced Mapping enabled indefinitely.** You can keep Advanced Mapping enabled, and click the **Configure Advanced Mapping** button to create these mappings correctly using the new interface. Correcting the invalid Help Text mappings using Advanced Mapping will not correct the help text issues on the fields. If you disable and later re-enable Advanced Mapping, the mappings you corrected directly in the Advanced Mapping interface will be lost.