---
schema_version: "1"
id: bfd092637813d195d155f95de1c0a248c9a6a1d7fe64131f4766a53c59882dbc
title: Create Export Files for Import Wizards
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/import_export.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.import_export.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: af4f3a4d1eaa2a24acd328a821466c9eae3317748509da3783c251e93f62ced2
description: Before you can import data into Salesforce, use your existing software to create a data export file.
products:
  - Salesforce Platform
  - Cross Cloud
release: "264"
---
# Create Export Files for Import Wizards

Before you can import data into Salesforce, use your existing software to create a data export 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>

An export file contains all the information you want to import.

Your export file can contain a mixture of new records and updates to existing records. You’ll choose how records are matched to avoid duplication. For example, you can choose to match accounts and contacts by name or by email address. If you choose to match by email address, then the contact already in Salesforce will be updated if a record in your imported data has the same email address. However, if records have the same name but different email addresses, the records will remain separate.

1. Use your existing software to create a data export file.
    
    - [Export Contact Data from ACT!](https://help.salesforce.com/s/articleView?id=xcloud.import_export.htm&release=264.0.0&type=5 "ACT! allows you to export contact data in a text-delimited format which can then be imported.")
    - [Exporting from LinkedIn®](https://help.salesforce.com/s/articleView?id=xcloud.import_export.htm&release=264.0.0&type=5 "You can export contact data from LinkedIn in a text-delimited format, which you can then import.")
    - [Export from Outlook](https://help.salesforce.com/s/articleView?id=xcloud.import_export.htm&release=264.0.0&type=5 "Export data directly from Microsoft® Outlook® in a CSV (comma-separated values) format. Then import that data into Salesforce.")
    - [Export from Other Data Sources](https://help.salesforce.com/s/articleView?id=xcloud.import_export.htm&release=264.0.0&type=5 "You can import data into the system from any other application that can create a CSV (comma-separated values) file.")
    - [Export from Salesforce](https://help.salesforce.com/s/articleView?id=xcloud.import_export.htm&release=264.0.0&type=5 "You can export account, campaign member, contact, custom object, lead, or solution reports from Salesforce to create an import file.")
2. Review data you will import to ensure that it is more up-to-date than what is already in Salesforce. Your Salesforce data will be replaced with data from your import file, even if it is out of date.
3. Compare your data fields with the Salesforce fields you can import into, and verify that your data will be mapped into the appropriate Salesforce fields. See [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.").
4. If you are the administrator and are importing for multiple users, combine export data from multiple sources into a single comma delimited text file (.csv) using Excel.
    
    When importing records from multiple users, your export file must include a Record Owner field for all new records which must contain the full usernames or first and last names of existing, active users. Existing record owners will not be changed; new records will be assigned to the user listed in the Record Owner field. For example, records that should be owned by Joe Smith in your organization must have that user’s username (”jsmith@acme.com”) or first and last names (for example, “Joe Smith”, or “Smith Joe” for Asian locales). For lead imports, you can also specify the name of a lead queue.
    
    When importing leads, you can alternatively use a lead assignment rule to specify the owners of the imported data, instead of using a Record Owner field.

#### 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.")
- [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.")
- [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.")

## Export Contact Data from ACT!

ACT! allows you to export contact data in a text-delimited format which can then be imported.

### 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 and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>All</strong> Editions except <strong>Database.com</strong></td></tr></tbody></table>

To export contact data from ACT! (versions 4.0 or 2000):

1. Launch ACT! and open your database.
2. Select **File** | **Data Exchange** | **Export...**.
3. Select the file type **Text-Delimited**.
4. Choose a file name and location for the exported data and click **Next**.
5. Select **Contact records only**.
6. Click the **Options...** button.
7. Select **Comma** for the field separator character. If commas aren’t appropriate for your locale, use a tab or other delimiter. Specify your delimiter in Data Loader Settings (**Settings** | **Settings**).
8. Select **Yes, export field names** and click **OK**.
9. Click **Next**.
10. Select **All Records** and then click **Next**.
11. Leave the export field order list alone, and click **Finish**.

## Exporting from LinkedIn®

You can export contact data from LinkedIn in a text-delimited format, which you can then import.

### 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</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>All</strong> Editions except <strong>Database.com</strong></td></tr></tbody></table>

Open [www.linkedin.com/addressBookExport](http://www.linkedin.com/addressBookExport?fromEmail=1) and follow the steps on the page using the **Microsoft Outlook (.CSV file)** option.

## Export from Outlook

Export data directly from Microsoft® Outlook® in a CSV (comma-separated values) format. Then import that data into Salesforce.

1. In Outlook, navigate to the export feature.
2. Choose **Comma Separated Values (Windows)** and click **Next**. If commas aren’t appropriate for your locale, use a tab or other delimiter. Specify your delimiter in Data Loader Settings (**Settings** | **Settings**).
3. Select the folder containing the contacts you want to export, and click **Next**.
4. Choose a file name for the exported data and click **Next**.
5. Click **Finish**.

## Export from Other Data Sources

You can import data into the system from any other application that can create a CSV (comma-separated values) file.

1. Save your data source as a CSV file. If commas aren’t appropriate for your locale, use a tab or other delimiter. Specify your delimiter in Data Loader Settings (**Settings** | **Settings**).
2. Ensure your file includes only one name per field. The system cannot accept more than one name per field.
3. Ensure your file separates names and titles into two fields. The system cannot accept fields containing both names and titles.
4. Ensure your file includes only one phone number per field.

#### See Also

- [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.")
- [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.")

## Export from Salesforce

You can export account, campaign member, contact, custom object, lead, or solution reports from Salesforce to create an 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: both Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

Include the Account ID, Campaign Member ID, Contact ID, Custom Object ID, Lead ID, or Solution ID value for each respective record in your report. These ID fields are unique Salesforce identifiers and are used to accurately match your data with existing Salesforce records.

![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 Remember that Salesforce record IDs are case-sensitive. Don’t manually change Salesforce IDs in your import file.

To create an import file with these ID fields, first export the data from Salesforce.

1. Run an account, campaign member, contact, custom object, lead, or solution report in Salesforce. Include the respective ID field and any other fields that are required for the import.
2. Export the report to Excel.

#### See Also

- [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.")
- [Videos: Data Import How-To Series](https://salesforce.vidyard.com/watch/ARIjWm2qrDkJVJxEhReFug)