---
schema_version: "1"
id: 66d3798b4c7e941adc2a7d2b184902fd448ee841eaaff2b2cfe619f401d4d424
title: Upload Quotas 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_quotas.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_bulk_upload_quotas.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 6623ca76d606d688b9823c00a4bb6c2ec042f48b6bbac8b3d50ea058b386ef76
description: Manage large updates to your quotas in Salesforce Spiff by bulk-uploading quota records.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Upload Quotas in Salesforce Spiff

Manage large updates to your quotas in Salesforce Spiff by bulk-uploading quota 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="d97945e77">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d97945e77 ">To upload quotas:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d97945e77 ">
              <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>Quotas: Edit</li>

                <li>Data Sources: Edit</li>

              </ul>
            </td>

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

Teams must be created before uploading team assignments. The quotas template contains five fields. One field is required for import, and the other fields depend on how many months, quarters, or years you want to include with your quotas.

  
| Field | Required? | Description |
| --- | --- | --- |
| user\_external\_id | Required | The external ID of the user being assigned a quota. This value can be found in the Users table in the User External Id column. |
| Remaining fields | Optional | Each month, quarter, or year that you want the quota input for each user. The format of the dates is required to be YYYY-MM-DD. |

1. In the Admin menu, select **Users** (1).
2. Select **Quotas**in the left panel (2).
    
    ![Mass Data Management: quotas](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_quotas.png)
3. Download the example template.
    1. Click the upload button near the top-right corner of the screen (3).
    2. Then click **Download** the example file on the modal.
4. Add new quota records to the file.
    
    - To edit the file manually, open the example .csv file in a text editor, and add the new quota records to the file.
    - If you use a spreadsheet program like Microsoft Excel to add your quota 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 required field is specified for each record. Delete the example records or you’ll get an error when uploading as those user IDs don’t exist in your system. Note that a 3-letter ISO code is needed to designate the value as a specific currency. The quota value defaults to a number if you don’t use an ISO code in your upload. You can also use the designations PCT and NUM to designate data as a percent or number respectively. For example, using PCT 20 will cause Salesforce Spiff to interpret that number as 20%.
5. (Optional) Edit existing quota records.
    1. Click on the quota name of the quota table you want to edit (6). This ensures that the update applies only to the selected quota.
    2. Download the Quota table. Click the download icon in the top right of the table (3) to export a .csv file of all existing quota records.
    3. For any record that needs changing, edit the specific quotas. Remember to use the ISO format for currencies.
    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 provides details about each upload, including 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.