---
schema_version: "1"
id: 5bca6613780ae382044e58b942a4e9d55d471159ef30ead203d6dd772a068886
title: Upload Plan Assignments in Salesforce Spiff
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_bulk_upload_plan_assignments.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_bulk_upload_plan_assignments.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: aa9e4cfa92567cdf5b0b516baaeee7985d334f84a4519c4e6740a6f91769d095
description: Manage large plan updates in Salesforce Spiff by bulk-uploading plan assignment records.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Upload Plan Assignments in Salesforce Spiff

Manage large plan updates in Salesforce Spiff by bulk-uploading plan assignment records.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d31274e78">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d31274e78 ">To upload plan assignments:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d31274e78 ">
              <p>A Spiff <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_users_roles_and_permissions.htm&amp;release=264.0.0&amp;type=5" title="Give users the appropriate level of access so they can be successful in Salesforce Spiff, and enforce the principle of least privilege. Assign a default role to each user, or create custom roles with access to specific Spiff functionality.">user role</a> with these permissions turned on.</p>
              <ul>
                <li>Users: Edit</li>

                <li>Plan Assignments: Edit</li>

                <li>Data Sources: Edit</li>

              </ul>
            </td>

          </tr>
        </tbody>
      </table>

Plans must be created before uploading plan assignments. The plan assignment template contains five fields. Two fields are required for import.

 
| Field | Description |
| --- | --- |
| user\_id | The external ID of the user being assigned to a plan. This value can be found in the Users table in the User External Id column. |
| effective\_as\_of | Determines the start date of the plan assignment. Dates must be in the YYYY-MM-DD format. This value can be updated in the UI after upload. |
| effective\_until | Determines the end date of the plan assignment. Dates must be in the YYYY-MM-DD format. This value can be updated in the UI after upload. |
| external\_id | The unique identifier for each plan assignment, since a user can be assigned multiple plans. Duplicate entries overwrite the existing plan assignment. The same ID must be used when updating plan assignments or creating a new record. This value can be updated in the UI after upload. If you don’t use the external\_id, remove this field from the column header. |
| plan\_name | The plan to which the rep is assigned. The plan must already exist in the system or the record will error. |

1. In the Admin menu, select **Users** (1).
2. Click **Plan Assignments** in the left panel (2).
    
    ![Mass Data Management: plan assignment](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_mass_data_manage_plan_assign.png)
3. Download the example template.
    1. Click the upload button near the top-right corner of the screen (3).
    2. Click **Download the example file** on the modal.
4. Add new plan assignment records to the file.
    
    - To edit the file manually, open the example .csv file in a text editor, and add the new plan assignment records to the file.
    - If you use a spreadsheet program like Microsoft Excel to add your plan assignment information, apply the correct date formatting. Because date formats change when the .csv file is opened in Excel, revert the format to the correct YYYY-MM-DD format by placing a ' mark at the front of the date. For example, the 1/1/2025 date can be updated to the correct format by entering '2025-01-01 in the cell.
    
    When you edit the file, don't edit the field headers on the template. Make sure that the two required fields are specified for each record. Delete the example records or they’ll be uploaded to the system. Although the field isn’t required, we highly recommend creating a unique external\_id for each plan assignment record. This ensures a smooth process if you anticipate updating records by bulk upload. Use the same external\_id for records you attempt to update through upload. If you don’t use the external\_id, remove this field from the column header.
5. (Optional) Edit existing plan assignment records.
    1. Apply a Plan Assignment External Id to any lines that don't already have one entered.
    2. Download the Plan Assignment table by clicking the download icon in the top right of the table (3) to export a .csv file of all existing user records in the system.
    3. For any record that needs changing, edit the Effective As Of, Effective Until, or any custom field entries.
    4. Copy the updated records from this table and paste them into the example file.
6. Upload the file.
    1. Click the upload button near the top-right corner of the screen (3).
    2. Click **Browse your computer** or drag and drop the file.
        
        A notification appears indicating the upload is in progress.
    3. Click the link to navigate to the File Import Status page.
        
        You can access this page by clicking the **"i"** indicator on the table settings (5).

The File Import Status table shows information about each upload. It includes important information like Status (Complete or Imported with Errors), Validation Alerts that link to the error message, and timestamps of the imports. If a file contains errors, only the records with errors are rejected.

#### See Also

- [Plan Assignment External IDs in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_plans_external_ids.htm&release=264.0.0&type=5 "In Salesforce Spiff, the external ID field on a plan assignment supports bulk uploading and updating of plan assignments with Mass Data Management.")