Source: https://vaultcrmhelp.veeva.com/doc/Content/CRM_topics/CampaignManager/TargetList/ImportTargetList.htm

## Importing Target Lists Using the Data Grid Loader

Marketing users can define their target list by importing up to 10,000 targets at once from an external spreadsheet using the Data Grid Loader.

**Who can use this feature?**

* Marketing Users - Browser
* [Importing a Target List](#Importing)
* Users require a Campaign Manager license

### Configuring Importing Target Lists for

[![Closed](../../../../Skins/Default/Stylesheets/Images/transparent.gif)Marketing Users](#)

To configure this feature, ensure [Configuring Campaign Manager](../Config/ConfigCM.htm) is complete.

### Importing a Target List as

[![Closed](../../../../Skins/Default/Stylesheets/Images/transparent.gif)Marketing Users](#)

To use the Data Grid Loader to import a target list:

1. Navigate to the appropriate campaign or journey.

   ![](../../../Resources/Images/CampaignManager/CreateCampaigns2.png)
2. Select **Import** in the Target List section. The Data Grid Loader displays.
3. Copy and paste the Account IDs from the list of account\_\_v records into the Data Grid Loader from an external spreadsheet. The following methods are available to paste the data:

   * Selecting the Paste Data button in the Data Grid Loader
   * Using a keyboard shortcut (Ctrl + V)

   If any rows are missing or duplicate an Account ID, an error message displays and the rows highlight. Rows with errors are ignored when uploading. Users can select Clear Data to clear the Data Grid Loader and paste again with corrected data.
4. Select the **Data Includes Header Row** checkbox if the first row of the pasted data contains column headers. This ignores the first row when uploading.
5. Select the **Import** button.

   If all rows have errors, the Import button disables.

After uploading, a Status column displays the result for the account and an ID column of the target record ID. Successfully uploaded rows display with a populated ID column, enabling the user to identify the record.

Rows with errors highlight in red and the error message in the Status column. Select the Only Show Errors checkbox to only display rows with errors.

Users can select the Copy Data button to copy the upload results and paste them into an external spreadsheet to export the results.

To repeat the import process, select the Clear Data button to clear the data grid loader in preparation for another import.

#### Importing into Existing Target Lists

If the target list is already defined, marketing users can still use the data grid loader to add or remove individual targets from the list:

1. Navigate to the Target List tab of the appropriate campaign or journey.
2. [Export the existing target list](CopyTargetList.htm#Exportin) into either an .xlsx or .csv file.
3. Edit the State column of the spreadsheet to Removed for all targets to remove from the list.

   If the label of the removed\_\_v picklist value has been edited or translated, use the updated label instead. Alternatively, the API name of the picklist value may be used.
4. Add the appropriate Account IDs for targets to add to the list. For new targets, ensure the State column is either Active or left blank.

   Existing targets not being removed from the list are ignored in the data load and do not need to be deleted from the spreadsheet.
5. Navigate back to the Target List tab.
6. Select the **Excel** button.

   ![](../../../Resources/Images/CampaignManager/CopyTargetListA.png)
7. Select **Import with Data Grid Loader**.
8. Copy and paste the Account and State columns from the exported spreadsheet into the data grid loader.
9. Select **Review and Import**. The Remove and Import confirmation modal displays the number of targets that will be added or removed from the list by the imported data.
10. Select **Import**.

### Related Topics

[Managing Target Lists](ManageTargetList.htm)

[Using the Target List Builder](TargetListBuilder.htm)

[Using Campaign Manager to Send Emails](../Details/SendEmails.htm)