---
schema_version: "1"
id: 3977dc57d38ac6722a9a76d02f309b4cb0dbdce02b605bc242dcb66d67d9d44b
title: Upload Data from the Template
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sfdo/264-0-0/npsp_upload_data.md
canonical_url: https://help.salesforce.com/s/articleView?id=sfdo.npsp_upload_data.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b0b245885a7625b45aea74b28a90ee4773e659db9839e620cf1e669d13bb4f2d
description: Learn how to upload data from a spreadsheet to the NPSP Data Importer.
products:
  - Nonprofit
release: "264"
---
# Upload Data from the Template

Learn how to upload data from a spreadsheet to the NPSP Data Importer.

Now, let's use the Data Import Wizard to upload the template into the NPSP Data Import custom object.

![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 If you don't see the NPSP Data Imports tab see [Configure NPSP Data Importer](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5 "Prepare your organization for importing data from spreadsheets by following these NPSP Data Importer set up instructions.").

1. Click 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. In the All Items section, click **NPSP Data Imports**.
3. Click **Import**.
    
    ![Import button on the NPSP Data Imports page](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/nonprofit_success_pack/images/npsp_data_imports_import.png)
4. In the "What kind of data are you importing?" section, make sure the Custom objects tab is selected, and then click **NPSP Data Imports**.
5. In the "What do you want to do?" section, select **Add new records**.
    - If you're importing your data for the first time, or know that you will be matching to existing data based only on Name, Email or Phone, then leave all the options in this section set to \--None-- (unless you are mapping one of the ID fields). Be sure to leave **Match by** as \--None-- regardless.
        
        ![Import data](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/nonprofit_success_pack/images/upload_wizard_1.png)
    - If your spreadsheet has Salesforce IDs for GAU Allocations or you'd like the NPSP Data Importer to match against existing Contact, Account, Donation or Payment records later in the process, select the appropriate value from the What do you want to do? section in the Import Wizard. Be sure to leave **Match by** set to \--None--. Note that you'll need to populate the corresponding Imported field (e.g. Contact1 Imported, Contact2 Imported, Account1 Imported, Account2 Imported, Household Account Imported) with the 15- or 18-character Salesforce ID in the template file you're importing. For example, we populated the Contact1 Imported field (in the template) with Contact1's Salesforce ID. So, under **Which Contact field in your file do you want to match against to set the Contact1 Imported Lookup field?**, we select Salesforce.com ID.
        
        ![Import Wizard match ID](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sfdo-nonprofit_success_pack-264-0-0-production-enus/bd2879e2-2bdc-4012-aa32-dc0c697c4538/nonprofit_success_pack/images/import_match_id.png)
6. In the Where is your data located? section, either drag your completed template file to the drop zone or browse for the file to upload it.
7. Click **Next**.
8. Verify that the field mappings are correct and make any changes if necessary. Because you're using the template, the column headers should exactly match the field names or field labels in the NPSP Data Import object you're uploading to. If one of your fields is unexpectedly unmapped or isn't available for mapping, look for these common issues:
    - If you're matching by ID and the Imported field is unmapped, you likely selected the wrong field or value in the What do you want to do? section of the Data Import Wizard.
    - The Salesforce Data Import Wizard automatically maps your columns to fields when the column name matches the field name. If your column header doesn't match and the field is unmapped, you can manually map template fields to object fields right here in the wizard.
    - You must have Advanced Mapping enabled to map to some fields in NPSP. For more information, see [Configure NPSP Data Importer](https://help.salesforce.com/s/articleView?id=sfdo.npsp_data_importer.htm&release=264.0.0&type=5 "Prepare your organization for importing data from spreadsheets by following these NPSP Data Importer set up instructions.").
9. Click **Next**.
10. Review the import summary.
11. Click **Start Import**. Your import starts and displays a confirmation message that lets you click through to the Bulk Data Load Jobs page, where you can monitor the status of the data upload.

The first part of the import process is done! You're ready to [Verify Data Upload](https://help.salesforce.com/s/articleView?id=sfdo.npsp_verify_upload.htm&release=264.0.0&type=5 "Make sure the data from your template uploaded successfully to the NPSP Data Import custom object.").