---
schema_version: "1"
id: cdf58627457ad7973dc78ec2b1916caffa0b7ddfbbe3be38517b5add4ea5379f
title: Prepare Your Data for Import
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/import_prepare.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.import_prepare.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1c3628a3655200b2f69588c97853eb1fe32085a03111c85669fd751ec82bb478
description: After exporting your data from Salesforce or your existing application, prepare your data before importing it.
products:
  - Salesforce Platform
  - Cross Cloud
release: "264"
---
# Prepare Your Data for Import

After exporting your data from Salesforce or your existing application, prepare your data before importing it.

### 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 If your data has information in fields that do not match any standard fields, your admin can create custom fields for that data before import.

## Preparing Contacts

Use Excel® to label the columns in your import file as specified in [Field Mapping for Other Data Sources and Organization Import](https://help.salesforce.com/s/articleView?id=xcloud.field_mapping_for_other_data_sources_and_organization_import.htm&release=264.0.0&type=5 "If you are importing accounts and contacts for an organization, or importing individual data from sources other than Outlook or ACT!, the Import Wizards map the fields as correctly as possible.").

## Preparing Person Accounts

When importing person accounts, use the field labels in Salesforce as the column labels in your import file.

## Preparing Org Business Accounts and Contacts

When importing business accounts and contacts for your org, you must use Excel® to label the columns in your import file as specified in [Field Mapping for Other Data Sources and Organization Import](https://help.salesforce.com/s/articleView?id=xcloud.field_mapping_for_other_data_sources_and_organization_import.htm&release=264.0.0&type=5 "If you are importing accounts and contacts for an organization, or importing individual data from sources other than Outlook or ACT!, the Import Wizards map the fields as correctly as possible.").

## Preparing Org Leads

When importing general leads or leads for campaigns, use the import file labels specified in [Field Mapping for Importing Leads](https://help.salesforce.com/s/articleView?id=xcloud.field_mapping_for_importing_leads.htm&release=264.0.0&type=5 "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").

## Preparing Custom Objects

When importing a custom object, use the field labels shown on the custom object detail page in Salesforce as the column labels in your import file.

## Preparing Campaign Members

When importing campaign members, use the field labels in Salesforce as the column labels in your import file.

## Preparing Solutions

When importing solutions, use the field labels in Salesforce as the column labels in your import file.

You can enter HTML into the solutions you plan to import into Salesforce. However, unless your org has enabled HTML solutions, HTML tags will display in the solutions after they are imported.

For security purposes, Salesforce automatically filters all HTML solutions for potentially malicious HTML. If potentially malicious HTML is detected in an HTML solution, the potentially malicious HTML is either removed or transformed into text for users who view the HTML solution. Users can’t notice when potentially malicious HTML is removed from an HTML solution.

You can import solutions written in HTML format into Salesforce. However, for security purposes, only the HTML tags listed below are allowed. The content of any HTML tags not listed below is removed when saved in HTML solutions. Furthermore, the content of all `<script>` and `<iframe>` tags, as well as all JavaScript, is removed when saved in HTML solutions. Cascading Style Sheets (CSS) are not supported in HTML solutions.

The following HTML tags are allowed in HTML solutions imported into Salesforce:

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><colgroup><col style="width:33.33333333333333%"> <col style="width:33.33333333333333%"> <col style="width:33.33333333333333%"></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;a&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;dt&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;q&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;abbr&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;em&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;samp&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;acronym&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;font&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;small&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;address&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;h1&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;span&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;b&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;h2&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;strike&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;bdo&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;h3&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;strong&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;big&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;h4&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;sub&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;blockquote&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;h5&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;sup&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;br&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;h6&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;table&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;caption&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;hr&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;tbody&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;cite&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;i&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;td&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;code&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;img&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;tfoot&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;col&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;ins&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;th&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;colgroup&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;kbd&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;thead&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;dd&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;li&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;tr&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;del&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;ol&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;tt&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;dfn&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;p&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;ul&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;div&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;pre&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;var&gt;</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>&lt;dl&gt;</code></td><td class="slds-cell-wrap" style="vertical-align:top;">&nbsp;</td><td class="slds-cell-wrap" style="vertical-align:top;">&nbsp;</td></tr></tbody></table>

Within the above tags, you can include the following attributes:

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><colgroup><col style="width:33.33333333333333%"> <col style="width:33.33333333333333%"> <col style="width:33.33333333333333%"></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>alt</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>face</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>size</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>background</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>height</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>src</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>border</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>href</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>style</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>class</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>name</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>target</code></td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;"><code>colspan</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>rowspan</code></td><td class="slds-cell-wrap" style="vertical-align:top;"><code>width</code></td></tr></tbody></table>

The above attributes, which can include a URL, are limited to URLs that begin with the following:

- http:
- https:
- file:
- ftp:
- mailto:
- #
- / for relative links

#### See Also

- [Default Field Mapping for ACT!](https://help.salesforce.com/s/articleView?id=xcloud.default_field_mapping_for_act.htm&release=264.0.0&type=5 "ACT! fields map to Salesforce account and contact import fields during an individual data import.")
- [Default Field Mapping for Outlook](https://help.salesforce.com/s/articleView?id=xcloud.default_field_mapping_for_outlook.htm&release=264.0.0&type=5 "Outlook fields map to Salesforce account and contact import fields during an individual data import.")
- [Create Export Files for Import Wizards](https://help.salesforce.com/s/articleView?id=xcloud.import_export.htm&release=264.0.0&type=5 "Before you can import data into Salesforce, use your existing software to create a data export file.")