---
schema_version: "1"
id: 5bf7df0240cda3452b4a26901bf50fc29ca9378ad0b706820b2c2766faa95550
title: Recommended Data Mapping Prerequisite for Salesforce Spiff
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_data_mapping.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_data_mapping.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 78c222cd067d6461e6ad865a63f8d6a5a30d5e94e911ab1c468111449c1e160d
description: Before you import data from Salesforce or a third-party data source into Salesforce Spiff, create a data mapping spreadsheet that lists all objects and fields that you plan to sync. Make sure that you collaborate with all required stakeholders and receive approval for your design before you set up the connectors and sync data.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Recommended Data Mapping Prerequisite for Salesforce Spiff

Before you import data from Salesforce or a third-party data source into Salesforce Spiff, create a data mapping spreadsheet that lists all objects and fields that you plan to sync. Make sure that you collaborate with all required stakeholders and receive approval for your design before you set up the connectors and sync data.

### 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>

Download the [template data mapping spreadsheet](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/spiff_data_mapping_template.xlsx), or create a Microsoft Excel spreadsheet in .xlsx format from scratch.

The spreadsheet must have a tab named Data Mapping, with these required columns. Depending on your company’s needs, you can add other columns.

 
| Column | Value |
| --- | --- |
| Plan | The name of a Spiff commission plan to sync data for. |
| Rule | The name of a Spiff payout rule to sync data for. If you don’t know what rule to use, you can leave the Rule value blank. |
| Object/Table Name | The name of the object or data table from your source system to sync. The terms object and table are used interchangeably. |
| Field Name | The user-friendly label for the field that contains the data to sync. |
| API Name | The programmatic name for the field that contains the data to sync. |
| Data Type | The format for the data that’s synced into Spiff, which can be different from the format for the data in your source system. For example, Boolean values in Spiff must be `true` or `false`, but some source systems use `0` and `1` for Boolean values. |
| Source System | The name of your source system. |
| Notes | Comments to add for historical tracking. |

#### See Also

- [Data Types in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_data_types.htm&release=264.0.0&type=5 "Data that you import, connect, or create in Salesforce Spiff must match a supported data type.")