---
schema_version: "1"
id: 8a8a97973a02f54cc787185d081ea645577fa0672268d0841f15892d4c239fd8
title: Field Mapping for Importing Leads
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/field_mapping_for_importing_leads.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.field_mapping_for_importing_leads.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 84953f6522482634651e6a5a309d7a6ffebe65b6240e3f85883b087b0fc95211
description: To improve the accuracy of your import, label the columns in your import file to match the Salesforce Lead fields. When you import the leads, the Data Import Wizard maps the fields in your import file
products:
  - Salesforce Platform
  - Cross Cloud
release: "264"
---
# Field Mapping for Importing Leads

To improve the accuracy of your import, label the columns in your import file to match the Salesforce Lead fields. When you import the leads, the Data Import Wizard maps the fields in your import file

### 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: Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Essentials, Group, Professional, Enterprise, Performance, Unlimited, and Developer Editions</td></tr></tbody></table>

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-setup-264-0-0-production-enus/6f21df35-9ea0-4f53-ac94-45c3b5dfd5bc/images/icon_note.png)

Note The following default mappings aren’t always 100% accurate in mapping your data. Check the import and fine-tune the mapping in the Data Import Wizard as necessary.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col>
        <col>
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" id="d38123e60">Import File Label</th>
          <th scope="col" class="slds-cell-wrap" style="text-align:center;vertical-align:top;" id="d38123e63">Salesforce Lead
            Field</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Annual Revenue</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Annual Revenue</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">City</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">City</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Company
          </td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Company</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Country</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Country</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">
            <p>Currency ISO Code</p>
            <p style="margin-bottom:0;">Note: Use this field only for orgs that use multiple currencies; see <a href="https://help.salesforce.com/s/articleView?id=xcloud.import_currency.htm&amp;release=264.0.0&amp;type=5" title="If your organization has set up the ability to use multiple currencies, you can import amounts in different currencies.">Rules for Importing Multiple Currencies</a>.</p>
          </td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Lead Currency</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Description</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Description</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">
            <p>Email</p>
            <p style="margin-bottom:0;">The Data Import Wizard verifies email addresses in the form of jsmith@acme.com.</p>
          </td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Email</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">
            <p>Email Opt Out</p>
            <p style="margin-bottom:0;">Use “1” to indicate that the user opts out. Use “0” to
              indicate that the user wants emails.</p>
          </td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Email Opt Out</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">No. of Employees</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">No. of Employees</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Fax</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Fax</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">
            <p>Full Name or First Name &amp; Last
              Name</p>
            <p style="margin-bottom:0;">(Note: When importing lead names, use either Full Name or
              First Name and Last Name, but not both.)</p>
          </td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">First Name and Last Name</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Industry</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Industry</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">
            <p>Lead Division</p>
            <p style="margin-bottom:0;">Note: Do not specify this field if you assign the division using the dropdown list in Step
              1 of the Data Import Wizard. If you do not map this field or use the division dropdown list,
              the division is set to the record owner’s default division for each record. </p>
          </td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Lead Division</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">
            <p>Lead ID</p>
            <p style="margin-bottom:0;">Note: Record IDs are case-sensitive and must not be changed.</p>
          </td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Lead ID</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">
            <p>Lead Source</p>
            <p style="margin-bottom:0;">Note: Do not specify this field if you assign the same lead source to all leads on the
              first page of the Data Import Wizard. The Lead Source dropdown lists all active lead source
              picklist values.</p>
          </td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Lead Source</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Lead Status</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Lead Status</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Mobile Phone</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Mobile</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Phone</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Phone</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Postal Code</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Postal Code</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Rating</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Rating</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">
            <p>Record Owner</p>
            <p style="margin-bottom:0;">Note: You do not need this field if you assign ownership using a lead assignment rule.
              When you import records by Salesforce record ID, this field is ignored.</p>
          </td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Lead Owner
          </td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Salutation</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Added to beginning of First Name</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">State</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">State</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">
            <p style="margin-bottom:0;">Status</p>
          </td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">
            <p>Status</p>
            <p style="margin-bottom:0;">(in the Campaign History related list of a lead)</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Street 1</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Address</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Street 2</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Address</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Street 3</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Address</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Title</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Title</td>

        </tr>
        <tr class="">
          <td data-label="Import File Label" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e60 ">Website</td>

          <td data-label="Salesforce Lead Field" class="slds-cell-wrap" style="vertical-align:top;" headers="d38123e63 ">Website</td>

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

If you include record types in this list, the Data Import Wizard uses the record owner’s default record type when creating new records. For existing records, the Data Import Wizard does not update the record type field.

If you use assignment rules, the Data Import Wizard uses the new owner’s default record type when creating new records. When the assignment rules assign the record to a queue, the queue owner’s default record type is used.

#### See Also

- [Prepare Your Data for Import](https://help.salesforce.com/s/articleView?id=xcloud.import_prepare.htm&release=264.0.0&type=5 "After exporting your data from Salesforce or your existing application, prepare your data before importing it.")