Import Data

Import your LinkedIn connections as Contacts

You can easily transfer your all Contacts into your SalesforceIQ Contact Gallery.

Note: Currently, SalesforceIQ supports importing Contacts in the VCard (.vcf) format only. See the sections below for information on downloading a VCard file for Gmail or LinkedIn Contacts. For other systems, look for the VCard or .vcf format in your export options.

  1. Click at the top of the screen, and then select Contacts.
  2. Click Import Contacts.
  3. Do one of the following:
    • Drag and drop the VCard file for the Contact you want to import.
    • Click Choose Files and search for the VCard file (.vcf) file.

After your VCard file import is complete, SalesforceIQ sends you an email confirmation. Also, after you import a Contact, you can edit or update the Contact and the changes are shared across your Organization as usual.

Note: If you import a Contact that is similar to an existing Contact, in most cases SalesforceIQ creates a separate Contact entry but displays a merge suggestion for the two Contacts. In some cases, when the system has a high certainty that the two Contacts are identical, it merges the imported Contact into the existing Contact record automatically.

Download a VCard Format File for Gmail Contacts

  1. Go to your Gmail Inbox.
  2. Click Mail in the upper-left corner, and then click Contacts.
  3. In the Contacts section, click More, and then select Export.
  4. Select which Contacts you want to export.
  5. Select the option vCard format (for importing into Apple Address Book or another application).
  6. Click Export.

Download a VCard Format File for LinkedIn Contacts

  1. Go to your LinkedIn home page.
  2. Click at the top of the page.
  3. In the left sidebar, click Your connections.
  4. Click Manage synced and imported contacts in the upper-right.
  5. In the right sidebar, under Advanced actions, click Export contacts. You might be prompted to sign into your account.
  6. Click Request Archive.
  7. An email is sent to the email address you have listed under Primary Email address in LinkedIn. Open the email and click the link to download your list of connections as a CSV file.
  8. You can then use an online tool to convert the CSV to a VCard for uploading to the Contact Gallery, or import the CSV file into a SalesforceIQ Contact List.

Note: If you're using Internet Explorer and you see a yellow pop-up blocker across the top or bottom of the page, click the yellow bar, select Save As, and save the file to your desired location.

How to import your data: Accounts and Contacts

Note: The procedure below applies if you are importing data to a new Account-based List. You can also import data in the following ways. Be sure to follow the correct procedure for the import path you want.

If you are an admin for your Organization, you can use the SalesforceIQ import tool to import data from an external system to a new List you create in SalesforceIQ. Our tool walks you through formatting your file correctly to import Contacts, Accounts, and List-specific items such as opportunities or leads.

Before You Begin

Note the following:

  • Imports are only accessible in a Chrome browser.
  • The new List name cannot be Owner or Owners.
  • To help ensure a smooth data import, format your data following the guidelines in Formatting data for import into SalesforceIQ.
  • Be sure to include an email address for any Contacts you import. This ensures that communication activity for that Contact appears in the Stream.
  • As part of the import process, you can map your existing data fields to Contact properties and Account properties in SalesforceIQ. Learn more about Contact properties here. Learn more about Account properties for all users here, and about Account property information specific to admin users here.

    Note: We recommend that you import Account properties only if they truly represent Account-level data. You can always build out Account properties after the import.

Video: Import Data (~21 min)

Learn:
How to format and import data to create a new list in SalesforceIQ (3:07)
How to successfully import your spreadsheet, step by step, to create a new list in SalesforceIQ (5:31)
How to complete your list setup by customizing your Statuses and Fields (15:19)

Import Data to a New List Associated with Accounts

  1. Export your data to a CSV file.
  2. In SalesforceIQ, click at the top of the screen, and then select Settings.
  3. On the screen that appears, click Lists, and then click Import List in the upper-right corner.
  4. Do the following to import your CSV file:
    • Drag the file into the Select a CSV file to Upload field, or click Choose File and browse to the file on your computer.
    • Enter the plural and singular forms of the items you want to track on the new List (leads, opportunities, etc.). The plural form becomes the new List name.
    • Select Accounts as the List type and click Next.

      Note: The CSV import screen contains information on the correct format for your CSV file. To see a template of the recommended CSV file format, click View an Example CSV.
  5. A series of informational screens appears explaining the three steps of the import process: Importing Account properties, importing Contact properties, and importing List fields. Please review the information before clicking Next.
  6. On the Import Account Properties screen, as well the import screens that follow, the field headers from your CSV file appear as a list on the left. Drag a header into a blank field on the right to enter that value in the field. The right section of each import screen shows a preview of how your entries will appear in SalesforceIQ. When you are finished entering values, click Next. Note: For an Accounts List, importing Account properties is required. At a minimum, you must enter a name for the Account by dragging an item into the Name field.
  7. On the Import Contact Properties screen, drag a header on the left into a blank field on the right to enter that value in the field. When you are finished entering values, click Next. For an Account list, this step is optional and you can Skip it.Note: If you choose to import Contact properties, you must populate the Name field to change the Skip button to Next.
  8. On the Import Fields to a New List screen, drag a header on the left into a blank field on the right to enter that value in the field. Each field you import becomes a field in your List. When you are finished entering values, click Next. Note: Importing fields to a new List is required. At a minimum, you must import a value such as an individual, company, or deal name to the first field displayed on the right—the field that indicates what type of object (lead, opportunity, etc.) you are tracking on this List.
  9. If your CSV file contains any duplicate entries, a screen appears asking whether you want to merge them. If you don't merge the entries, the import process creates a new List object for each entry in the CSV file. If you choose to merge the entries, the import process first merges them into a single entry in the CSV file, and then creates a single List object from the merged entry. Merging the entries impacts the CSV file only—it doesn't merge the entries with any existing object on the List.Note: If you are importing to an Account that already exists in your Account gallery, the Account property data in this import will overwrite existing Account properties. For example, say you have the Avocado, Inc. Account in your Account gallery. The Industry Account property is Tech. Now assume your data to be imported also contains an Avocado, Inc. Account, but this time the Industry Account property is Storage. After the import, the Avocado, Inc. Account will have the Industry Account property set as Storage.
  10. Review your information on the Review and Complete Your Import screen. If you want to change any entries, click to the right of the appropriate section.
  11. When you are happy with your import settings, click Complete Import.

Import data: Existing Account List

Note: The procedure below applies if you are importing data to an existing Account-based List. You can also import data in the following ways. Be sure to follow the correct procedure for the import path you want.

If you are an admin for an Organization, you can use the SalesforceIQ import tool to import data from an external system to an existing List. Our tool walks you through formatting your file correctly to import Contacts, Accounts, and List-specific items such as opportunities or leads.

Before You Begin

Note the following:

  • Imports are only accessible in a Chrome browser.
  • If a List reaches 50,000 objects, you can no longer import data into the List. You can, however, continue to add items to the List manually.
  • To help ensure a smooth data import, format your data following the guidelines in Formatting data for import into SalesforceIQ.
  • Any fields you want to import into an existing List must already exist in the List. Learn how to add fields to a List.
  • Be sure to include an email address for any Contacts you import. This ensures that communication activity for that Contact appears in the Stream.
  • As part of the import process, you can map your existing data fields to Contact properties and Account properties in SalesforceIQ. Learn more about Contact properties here. Learn more about Account properties for all users here, and about Account property information specific to admin users here.

    Note: We recommend that you import Account properties only if they truly represent Account-level data. You can always build out Account properties after the import.

Import Data to an Existing List Associated with Accounts

  1. Export your data to a CSV file.
  2. In SalesforceIQ, open the Accounts List into which you want to import the data.
  3. Click the List name at the top of the screen, and then select Import.
  4. To import your CSV file, drag the file into the Select a CSV file to Upload field, or click Choose File and browse to the file on your computer, and then click Next.

    Note: The CSV import screen contains information on the correct format for your CSV file. To see a template of the recommended CSV file format, click View an Example CSV.
  5. A series of informational screens appears explaining the three steps of the import process: Importing Account properties, importing Contact properties, and importing List fields. Please review the information before clicking Next.
  6. On the Import Account Properties screen, as well the import screens that follow, the field headers from your CSV file appear as a list on the left. Drag a header into a blank field on the right to enter that value in the field. The right section of each import screen shows a preview of how your entries will appear in SalesforceIQ. When you are finished entering values, click Next. Note: For an Accounts List, importing Account properties is required. At a minimum, you must enter a name for the Account by dragging an item into the Name field.
  7. On the Import Contact Properties screen, drag a header on the left into a blank field on the right to enter that value in the field. When you are finished entering values, click Next. For an Account list, this step is optional and you can Skip it. Note: If you choose to import Contact properties, you must populate the Name field to change the Skip button to Next.
  8. On the Import Fields to an Existing List screen, drag a header on the left into a blank field on the right to enter that value in the field. Each field you import becomes a field in your List. When you are finished entering values, click Next. Note the following:
    • Importing fields to a List is required. At a minimum, you must import a value such as an individual, company, or deal name to the first field displayed on the right—the field that indicates what type of object (lead, opportunity, etc.) you are tracking on this List.

      Note: If you import a List object that already exists in the List, SalesforceIQ creates a second List entry with the same List object name to avoid overwriting any data.
    • The fields available for import are the ones from your existing List.
  9. If your CSV file contains any duplicate entries, a screen appears asking whether you want to merge them. If you don't merge the entries, the import process creates a new List object for each entry in the CSV file. If you choose to merge the entries, the import process first merges them into a single entry in the CSV file, and then creates a single List object from the merged entry. Merging the entries impacts the CSV file only—it doesn't merge the entries with any existing object on the List. Note: If you are importing to an Account that already exists in your Account gallery, the Account property data in this import will overwrite existing Account properties. For example, say you have the Avocado, Inc. Account in your Account gallery. The Industry Account property is Tech. Now assume your data to be imported also contains an Avocado, Inc. Account, but this time the Industry Account property is Storage. After the import, the Avocado, Inc. Account will have the Industry Account property set as Storage.
  10. Review your information on the Review and Complete Your Import screen. If you want to change any entries, click to the right of the appropriate section.
  11. When you are happy with your import settings, click Complete Import.

Import data: New Contact List

Note: The procedure below applies if you are importing data to a new Contact-based List. You can also import data in the following ways. Be sure to follow the correct procedure for the import path you want.

If you are an admin for your Organization, you can use the SalesforceIQ import tool to import data from an external system to a new List you create in SalesforceIQ. Our tool walks you through formatting your file correctly to import Contacts, Accounts, and List-specific items such as opportunities or leads.

Before You Begin

Note the following:

  • Imports are only accessible in a Chrome browser.
  • The new List name cannot be Owner or Owners.
  • To help ensure a smooth data import, format your data following the guidelines in Formatting data for import into SalesforceIQ.
  • Be sure to include an email address for any Contacts you import. This ensures that communication activity for that Contact appears in the Stream.
  • As part of the import process, you can map your existing data fields to Contact properties and Account properties in SalesforceIQ. Learn more about Contact properties here. Learn more about Account properties for all users here, and about Account property information specific to admin users here.

    Note: We recommend that you import Account properties only if they truly represent Account-level data. You can always build out Account properties after the import.

Import Data to a New List Associated with Contacts

  1. Export your data to a CSV file.
  2. In SalesforceIQ, click at the top of the screen, and then select Settings.
  3. On the screen that appears, click Lists, and then click Import List in the upper-right corner.
  4. Do the following to import your CSV file:
    • Drag the file into the Select a CSV file to Upload field, or click Choose File and browse to the file on your computer.
    • Enter the plural and singular forms of the type of Contact you want to track on the new List. The plural form becomes the new List name.
    • Select Contacts as the List type and click Next.

      Note: The CSV import screen contains information on the correct format for your CSV file. To see a template of the recommended CSV file format, click View an Example CSV.
  5. A series of informational screens appears explaining the three steps of the import process: Importing Contact properties, importing Account properties, and importing List fields. Please review the information before clicking Next.
  6. On the Import Contact Properties screen, as well the import screens that follow, the field headers from your CSV file appear as a list on the left. Drag a header into a blank field on the right to enter that value in the field. The right section of each import screen shows a preview of how your entries will appear in SalesforceIQ. When you are finished entering values, click Next.Note: For a Contacts List, importing Contact properties is required. At a minimum, you must populate the Name field.
  7. On the Import Account Properties screen, drag a header on the left into a blank field on the right to enter that value in the field. When you are finished entering values, click Next.Note: For a Contacts List, importing Account properties is optional. If you choose to import Account properties, you must populate the Name field to change the Skip button to Next.
  8. On the Import Fields to a New List screen, drag a header on the left into a blank field on the right to enter that value in the field. Each field you import becomes a field in your List. When you are finished entering values, click Next. Note: The contact you entered on the Import Contact Properties screen is automatically entered as the List object name.
  9. If your CSV file contains any duplicate entries, a screen appears asking whether you want to merge them. If you don't merge the entries, the import process creates a new List object for each entry in the CSV file. If you choose to merge the entries, the import process first merges them into a single entry in the CSV file, and then creates a single List object from the merged entry. Merging the entries impacts the CSV file only—it doesn't merge the entries with any existing object on the List. Note: If you are importing to an Account that already exists in your Account gallery, the Account property data in this import will overwrite existing Account properties. For example, say you have the Avocado, Inc. Account in your Account gallery. The Industry Account property is Tech. Now assume your data to be imported also contains an Avocado, Inc. Account, but this time the Industry Account property is Storage. After the import, the Avocado, Inc. Account will have the Industry Account property set as Storage.
  10. Review your information on the Review and Complete Your Import screen. If you want to change any entries, click to the right of the appropriate section.
  11. When you are happy with your import settings, click Complete Import.

Import data: Existing Contact List

Note: The procedure below applies if you are importing data to an existing Contact-based List. You can also import data in the following ways. Be sure to follow the correct procedure for the import path you want.

If you are an admin for an Organization, you can use the SalesforceIQ import tool to import data from an external system to an existing List. Our tool walks you through formatting your file correctly to import Contacts, Accounts, and List-specific items such as opportunities or leads.

Before You Begin

Note the following:

  • Imports are only accessible in a Chrome browser.
  • If a List reaches 50,000 objects, you can no longer import data into the List. You can, however, continue to add items to the List manually.
  • To help ensure a smooth data import, format your data following the guidelines in Formatting data for import into SalesforceIQ.
  • Any fields you want to import into an existing List must already exist in the List. Learn how to add fields to a List.
  • Be sure to include an email address for any Contacts you import. This ensures that communication activity for that Contact appears in the Stream.
  • As part of the import process, you can map your existing data fields to Contact properties and Account properties in SalesforceIQ. Learn more about Contact properties here. Learn more about Account properties for all users here, and about Account property information specific to admin users here.

    Note: We recommend that you import Account properties only if they truly represent Account-level data. You can always build out Account properties after the import.

Import Data to an Existing List Associated with Contacts

  1. Export your data to a CSV file.
  2. In SalesforceIQ, open the List into which you want to import the data.
  3. Click the List name at the top of the screen, and then select Import.
  4. To import your CSV file, drag the file into the Select a CSV file to Upload field, or click Choose File and browse to the file on your computer, and then click Next.

    Note: The CSV import screen contains information on the correct format for your CSV file. To see a template of the recommended CSV file format, click View an Example CSV.
  5. A series of informational screens appears explaining the three steps of the import process: Importing Account properties, importing Contact properties, and importing List fields. Please review the information before clicking Next.
  6. On Import Contact Properties screen, as well the import screens that follow, the field headers from your CSV file appear as a list on the left. Drag a header into a blank field on the right to enter that value in the field. The right section of each import screen shows a preview of how your entries will appear in SalesforceIQ. When you are finished entering values, click Next. Note: For a Contacts List, importing Contact properties is required. At a minimum, you must enter a name dragging an item into the Name field.
  7. On the Import Account Properties screen, drag a header on the left into a blank field on the right to enter that value in the field. When you are finished entering values, click Next. Note: For a Contacts List, importing Account properties is optional. If you choose to import Account properties, you must populate the Name field to change the Skip button to Next.
  8. On the Import Fields to an Existing List screen, drag a header on the left into a blank field on the right to enter that value in the field. Each field you import becomes a field in your List. When you are finished entering values, click Next. Note the following:
    • Importing fields to a List is required. At a minimum, you must import a value such as an individual, company, or deal name to the first field displayed on the right—the field that indicates what type of object (lead, opportunity, etc.) you are tracking on this List.

      Note: If you import a List object that already exists in the List, SalesforceIQ creates a second List entry with the same object name to avoid overwriting any data.
    • The fields available for import are the ones from your existing List.
  9. If your CSV file contains any duplicate entries, a screen appears asking whether you want to merge them. If you don't merge the entries, the import process creates a new List object for each entry in the CSV file. If you choose to merge the entries, the import process first merges them into a single entry in the CSV file, and then creates a single List object from the merged entry. Merging the entries impacts the CSV file only—it doesn't merge the entries with any existing object on the List. Note: If you are importing to an Account that already exists in your Account gallery, the Account property data in this import will overwrite existing Account properties. For example, say you have the Avocado, Inc. Account in your Account gallery. The Industry Account property is Tech. Now assume your data to be imported also contains an Avocado, Inc. Account, but this time the Industry Account property is Storage. After the import, the Avocado, Inc. Account will have the Industry Account property set as Storage.
  10. Review your information on the Review and Complete Your Import screen. If you want to change any entries, click to the right of the appropriate section.
  11. When you are happy with your import settings, click Complete Import.

Format data for import

Here are some best practices to consider when formatting your data for import to a new List or an existing List in SalesforceIQ.

Note: The import tool includes a downloadable sample CSV template to help you format your data correctly.

Data Required for Import

When preparing your data for import, keep in mind that certain fields are required, as follows:

  • For an Account-based List, you must have at least one data field that you can import as the Account Name field.
  • For a Contact-based List, you must have at least one data field that you can import as the Contact Name field.
  • Be sure to include an email address for any Contacts you import.

File Size and Format

Currently, you can import CSV files containing up to 50,000 rows.

Data you want to import must be in CSV format. Sometimes, when downloading to CSV you may run into some issues. For example, if any cells in your data file start with the = symbol, you may get a #NAME? in those cells. To fix this, remove the = symbol from the cells displaying this error.

Also note the following:

  • Make sure your CSV files contains no empty column headers.
  • Make sure the first row in your CSV contains your field names.

Multiple Contacts in an Account List

You can import multiple Contacts per Account List object (lead, opportunity, etc., shown here as Lead in the first column), but you must format them in a specific way. The name of the company must be duplicated for each List object, and the objects must appear one after the other, as shown here:


In this example, certain columns (Primary Contact, Primary Contact Email, Phone) contain Contact-specific data, while others (Lead, Company Location) contain Account-specific data. The import tool uses the first row of the CSV file to create the company Account.

The import tool accepts the following Contact-specific data only:

  • Name
  • Email
  • Phone(s)
  • Title
  • Company
  • Twitter
  • Address

Skype or Facebook accounts associated with individual Contacts aren't imported. If you can't lose that data, we recommend that you create a Contact list.

If your spreadsheet contains multiple contacts, but they are listed in columns as primary contact, secondary contact, etc., as shown here:


then you must move each contact to its own row. In this example, you must move Darius below Richard to a separate row. If your spreadsheet contains a large number of Contacts in this format, you can reformat them quickly by doing the following:

  1. Copy and paste the first column next to the column for the secondary Contact.
  2. Copy and paste all of the secondary Contact information, including the new first column, below the primary Contact row. Make sure to move the pasted data back to initial column.
  3. Select all cells, and then click Data > Filter.
  4. Sort by the name of the List object. This leaves the primary Contact on top and the secondary, tertiary, etc. Contacts below.

Multiple Phone Numbers or Emails Per Contact

If you have multiple phone numbers or emails for a Contact, they must be in the same row as the Contact—either in a different column or in the same column, but comma-separated. The following images show acceptable formats:



Date Formatting

The dates in your data may be in a format other than 12/24/2010. To change this:

  1. Select all cells.
  2. Right-click and select Format Cells.
  3. On the Number tab, click Date.
  4. Under Locale, make sure English (U.S.) is selected, and then select the date format as shown above.

Sometimes the date format includes the time as well: 12/24/2010 13:45:26. You can import this format into SalesforceIQ; however, only the date appears, without the time. If you want the time to appear in SalesforceIQ also, you must insert a space between the date and the time to create separate columns. You can then format each column by right-clicking it and selecting Format Cells.

If the date cells contain other information such as words, symbols, etc., this information doesn't appear in SalesforceIQ.

Phone Numbers in Scientific Notation

Phone numbers sometimes show up in scientific notation. If you want every digit displayed, do the following:

  1. Select all cells.
  2. Right-click and select Format Cells.
  3. On the Number tab, click Custom.
  4. Under Type, select 000.

This changes the number format to show every digit.

Multiple List Items

If you want to populate a field with multiple options, enter each option separated by a comma in a cell under the field name column. In this example, Office Location is the field name and APAC, EMEA, and US are the options.


During the import process, if you import the field as a multi select field, each option appears as a list option.

Deals and Accounts

If you would like to set the List object as a deal name and the Account as something different, simply set them up as two separate columns. During the import process, on the Import Account Properties screen, drag the Account column here:

Then, on the Import Fields to a New/Existing List screen, drag the Deal column into the object name field as shown here:

Address for Contact or Account Properties

If you would like to associate an address with a Contact or company, you must ensure that the entire address is in a single cell. Excel offers two formulas for combining cells. Using the following address as an example:


To combine it all, you can enter the following formula in cell G2:

=B2&" "&C2&" "&D2&" "&E2&" "&F2

or

=CONCATENATE(B2," “,C2," “,D2," “,E2," “,F2).

Note: If the address contains extra spaces before, in the middle, or after, you can use the following formula:

=TRIM(G2).

Contacts and Accounts in Separate Lists

If you have Contacts and Accounts in a separate List, you have to use a vlookup to add the contents to the same List. If you have an Account ID in both Lists, use that as the identifier. If not, you need to use the name of the List object.

The vlookup formula is as follows:

=VLOOKUP([{cell name}{contact ID or name you want to look up}], [range of data you're looking up, with the first column being the column containing the contact ID or name you're looking up and the last column being the data you're looking up],[number of columns until the column with data you're looking up],[the word “false"])

An example might look like this:

=VLOOKUP(B2,E$2:F$999,2,false)

If you're having any difficulties, many helpful videos are available on YouTube.

In any case, the strategy is to get the List objects that correspond to the contacts on the contacts spreadsheet (on the same row as each corresponding contact). Then you copy all the pertinent contact data with the List object data back into the Account sheet (below all the other data). Take care to move the List object data to the same column as the other List object data and then filter by List object to move the Contacts right under the row of data that corresponds to the right List object.

Special Characters

SalesforceIQ supports importing special characters that contain accents, such as é, ü, or ñ. The steps for importing special characters depend on whether you are exporting from Excel or Numbers.

Excel

The Excel CSV file type doesn’t support special characters. Follow these steps to import special characters from Excel.

  1. Make sure your Excel file is formatted correctly, and save it as a .txt file.
  2. Open the text file in TextEdit (Mac) or Notepad (Windows).
  3. The file is tab-delimited. You need to change it to comma-separated. To do this:
    • Do a find and replace for all the tabs in the document.
    • Select a space between and two values and copy it (Ctrl+C).
    • Open the find and replace window.
    • Paste the tab in the Find field. Enter a comma in the Replace field.
    • Click Replace All. Your text file should now look like a string of comma-separated values.
  4. From the File menu, select Save As.
  5. For the plain text encoding, select Unicode (UTF-8).
  6. Open the folder where you saved the file and manually change the extension from .txt to .csv.
  7. Import the newly created CSV file.

Numbers

  1. Open your spreadsheet in Numbers.
  2. Remove any extra columns or rows. There should be no empty columns or rows visible beyond your data, as shown here.
  3. Go to File > Export to > CSV.
  4. Click Advanced Options and select Unicode (UTF - 8) from the Text Encoding drop-down menu.
  5. Save your CSV file as usual and import.

Before Merging Lists

The new import tool does not check for duplicate List objects in a List merge. If you don't want to import a duplicate List object , you must do a vlookup to see which (if any) objects already exist in the original List.

Mixed Data in Columns

If you have a column that has mixed data and you are trying to find a way to separate them, a useful function combo is IF + ISNUMBER.

For example: If you have a column with emails and names (column A), you can paste the following formula in column B:

=IF(ISNUMBER(FIND("@",A2)),"true","false")

This gives you a “true" response if it finds the “@" symbol (which any email has), and a “false" response if it doesn't. You can then apply filters and sort by column B so that you have all the cells containing emails in consecutive order.

Migrate external data

SalesforceIQ offers a variety of options that make it easy for users to migrate data from an external system into SalesforceIQ. Here is an overview of those options and some considerations for using them.

  • Importing data to a List—SalesforceIQ offers an easy tool that allows admin users to import existing customer data into a List in SalesforceIQ. The tool walks you through formatting your file correctly to import Contacts, Accounts, and List-specific items such as opportunities or leads. An admin user can import data either to a new List the admin creates in SalesforceIQ or to any existing List in the Organization.
    Note: The import tool includes a downloadable sample CSV template to help you format your data correctly.
  • Migrating your data from Sales Cloud to SalesforceIQ—Depending on your Sales Cloud edition, you can use prebuilt or custom-built reports to migrate your data into SalesforceIQ.
  • Importing Contacts—Any user can import Contacts from an external system to their SalesforceIQ Contact Gallery.
  • Capturing communication activity that is in the other system before you create your SalesforceIQ Account—If your email and calendar events are hosted in Google Apps, our system syncs existing emails and calendar events up to six months old. If you're hosted on Exchange, we sync emails up to two years old. Learn more about our Sharing model and how to share communication.

Overview: Import SalesforceIQ activity after migrating to Sales Cloud

Here are the high-level steps for importing your SalesforceIQ activity after migrating to Sales Cloud. If you just want to migrate to Sales Cloud without importing activity, follow these steps instead.

* Note: This import process will work for Sales Cloud Professional Edition or Sales Cloud Enterprise Edition only.

  1. Have your team stop manually logging activity into your SalesforceIQ Organization.
  2. Migrate your data using the SalesforceIQ migration tool. This migrates Lists, Contacts, and Accounts.
  3. After your Salesforce migration has completed, use the Organization export functionality to retrieve all manually logged activities. Create a copy of the export file to retain for your records
  4. Ensure that all users that were in SalesforceIQ have a user record in Salesforce. This step is required if you want the author of Stream comments to be the author of the respective chatter comment.
  5. Marry the exported data files.
  6. Re-import the data into Salesforce using Data Loader. The steps depend on the data type:

-----------------------------------------------------------

In this video, Importing Comments into Sales Cloud [6 minutes], you'll learn:

  • How to import Comments into Sales Cloud using Data loader
  • Where to download the Comments import template
  • How to copy and paste your SalesforceIQ data into the import template
  • How to map your fields into Sales Cloud for import using Data Loader

Import comments into Salesforce using Data Loader

Before You Begin

This article is for customers who have already migrated their data from SalesforceIQ CRM into Sales Cloud, and are looking to import their SalesforceIQ comments into Sales Cloud.

    • Review these high-level steps for how to import SalesforceIQ data into Sales Cloud after you have completed the data transfer into Sales Cloud.

*Note: This example is focused on importing comments from the Opportunities List in SalesforceIQ to the Opportunities Object in Sales Cloud. The general process applies to importing into other Objects in Sales Cloud.


System Permissions Needed

  • You must be a System Administrator in both SalesforceIQ and Sales Cloud in order to complete data migrations or imports.
  • In Sales Cloud, make sure the System Administrator user has the “Insert System Field Values for Chatter Feeds” user permission enabled:
    • Navigate to Setup > Users
    • Find the user and select the user's profile
    • Search for the permission and check the box if it's unchecked

Download the Import Resources

  1. Export your Comments file from SalesforceIQ using the Organization Export. Your exported file will be titled, "Opportunities-XXXXXXXXXXXXXXXXX-comments.csv”
  2. Run an export of your Opportunity Object in Sales Cloud via Data Loader, include all fields in the export.
    • Learn more about using Data Loader to export data
  3. Run an export of your Users Object in Sales Cloud via Data Loader, include all fields in the export.

Prepare the Final Import File

  1. Download and open this template. Then follow the instructions below.
  2. Paste your data in columns A, B and C. Use the data from your Opportunity Object export from Sales Cloud.
  3. Paste your data in columns D and E. Use the data from your Users export from Sales Cloud.
  4. Copy the worksheet tab called "CommentsTemplate", and merge it with the workbook "Opportunities-XXXXXX-comments.csv". It should look like the screenshot below.

  5. Return to the tab called "CommentsTemplate", copy the table highlighted in blue and paste it as new columns in your tab called "Opportunities-XXXXXX-comments.csv". It should look like screenshots below.

*Note: These fields contain pre-written formulas or fixed values that will marry/merge the proper Sales Cloud values with your SalesforceIQ comments, allowing you to map your SalesforceIQ comments to the correct opportunity record in Sales Cloud. Do not edit or delete these formulas or fixed values as it will cause errors with your data template and data import

6. To activate the formula fields, double-click on Row 2 in the columns (the blue fields) and delete the special character, an apostrophe ('), located at the very beginning of the formula.

7. Then click into the formula field, on Row 2 in each column, and drag down the formula fields and fixed value fields to all applicable rows within your data set.

8. Once the formula has populated for the whole column, you then need to copy each of the formula ID columns and paste special as Value. Highlight all of the columns and right click to select copy, then right click again, and select the ‘Paste Special’ option, choose ‘Value’ and click OK.

9. Save this file as a .csv format, and name it “Opportunity-comments-for-import.csv”

    • A finished version of this, with proper formatting can be found HERE, for your reference.


Import Using Data Loader

  1. Open Data Loader and click Insert.
  2. Log into Salesforce as a System Administrator user.
  3. Check the 'Show all Salesforce objects' box and select 'Feed Item (FeedItem)'.
  4. Browse for your final import file, titled "Opportunity-comments-for-import.csv" and click 'Next'.
  5. Click 'Create or Edit Map', and then click 'Auto-Match Fields to Columns'.
  6. Once you 'Auto-Match Fields to Columns', you should see something like the following screenshot below.
  7. Click OK > Next > Finish.
  8. Success and Error logs will be generated after the import is complete (see screenshot below). If you see any errors, click on "View Errors", follow the error logs to correct them. If you need additional assistance on fixing the errors, please contact Salesforce Support.
  9. The import comment activities are located in the Chatter section of your Opportunity record.

Import calls into Salesforce using Data Loader

Before You Begin

This article is for customers who have already migrated their data from SalesforceIQ CRM into Sales Cloud and are looking to import their SalesforceIQ calls into Sales Cloud.

    • Review these high-level steps for how to import SalesforceIQ data into Sales Cloud after you have completed the data transfer into Sales Cloud.

*Note: This example is focused on importing calls from the Opportunities List in SalesforceIQ to the Opportunities Object in Sales Cloud. The general process applies when importing into other Objects in Sales Cloud.


System Permissions Needed

  • You must be a System Administrator in both SalesforceIQ and Sales Cloud in order to complete data migrations or imports
  • In Sales Cloud, make sure the System Administrator user has the “Insert System Field Values for Chatter Feeds” user permission enabled:
    • Navigate to Setup > Users
    • Find the user and select the user's profile
    • Search for the permission and check the box if it's unchecked


Download the Import Resources

  1. Export your Calls file from SalesforceIQ using the Organization Export. Your exported file will be titled, "Opportunities-XXXXXX-calls.csv”
  2. Run an export of your Opportunity Object in Sales Cloud via Data Loader, include all fields in the export.
    • Learn more about using Data Loader to export data
  3. Run an export of your Users Object in Sales Cloud via Data Loader, include all fields in the export.
  4. Run an export of your Contacts Object in Sales Cloud via Data Loader, include all fields in the export.

Prepare the Final Import File

  1. Download and open this template. Then follow the instructions below.
  2. Paste your data in columns A, B and C. Use the data from your Opportunity Object export from Sales Cloud
  3. Paste your data in columns D and E. Use the data from your Users export from Sales Cloud
  4. Paste your data in columns F and G. Use the data from your Contacts export from Sales Cloud
  5. Copy the worksheet tab called "CallsTemplate", and merge it with the workbook "Opportunities-XXXXXX-calls.csv". It should look like below:

  6. Return to the tab called "CallsTemplate", copy the table highlighted in blue and paste it as new columns in your tab called "Opportunities-XXXXXX-calls.csv". It should look like screenshots below.

    *Note:
    These fields contain pre-written formulas or fixed values that will marry/merge the proper Sales Cloud values with your SalesforceIQ calls, allowing you to map your SalesforceIQ calls to the correct opportunity record in Sales Cloud. Do not edit or delete these formulas or fixed values as it will cause errors with your data template and data import.

  7. Do Not complete this step if you are importing calls into Opportunities or other account based Objects in Sales Cloud
    • Follow the steps below if you are importing calls into the Leads or Contacts Objects
      • Delete the entire column of "WhoID"
      • Rename the column header "WhatID" as "WhoID"
  8. To activate these formula fields, double-click on Row 2 in the columns (the blue fields) and delete the special character, an apostrophe ('), located at the very beginning of the formula.
  9. Then click into the formula field, on Row 2 in each column, and drag down the formula fields and fixed value fields to all applicable rows within your data set.
  10. Rename the column header “Created Date” as "ActivityDate"
  11. Rename the column header “Body” as "Description"
  12. Once the formula has populated for the whole column, you then need to copy each of the formula ID columns and paste special as Value. Highlight all of the columns and right click to select copy, then right click again, and select the ‘Paste Special’ option, choose ‘Value’ and click OK.
  13. Save this file as a .csv format, and name it “Opportunity-calls-for-import.csv”
    • A finished version of this, with proper formatting can be found HERE, for your reference.


Import Using Data Loader

  1. Open Apex Data Loader and click Insert
  2. Log in to Salesforce as a System Administrator user
  3. Check the 'Show all Salesforce objects' and select 'Task (Task)'
  4. Browse for your final import file, titled “Opportunity-calls-for-import.csv” and click Next.
  5. Click 'Create or Edit Map', and then click 'Auto-Match Fields to Columns'.
  6. Once you 'Auto-Match Fields to Columns', you should see something like the following screenshot below.
  7. Click OK > Next > Finish.
  8. Success and Error logs will be generated after the import is complete (see screenshot below). If you see any errors, click on "View Errors", follow the error logs to correct them. If you need additional assistance on fixing the errors, please contact Salesforce Support.
  9. The imported call activities are located in Past Activity section of your Opportunity record.

Note: This import process will work for Sales Cloud Professional Edition or Sales Cloud Enterprise Edition only.

Import meetings into Salesforce using Data Loader

Before You Begin

This article is for customers who have already migrated their data from SalesforceIQ CRM into Sales Cloud and are looking to import their SalesforceIQ meetings into Sales Cloud.

    • Review these high-level steps for how to import SalesforceIQ data into Sales Cloud after you have completed the data transfer into Sales Cloud.

*Note: This example is focused on importing meetings from the Opportunities List in SalesforceIQ to the Opportunities Object in Sales Cloud. The general process applies when importing into other Objects in Sales Cloud.


System Permissions Needed

  • You must be a System Administrator in both SalesforceIQ and Sales Cloud in order to complete data migrations or imports
  • In Sales Cloud, make sure the System Administrator user has the “Insert System Field Values for Chatter Feeds” user permission enabled:
    • Navigate to Setup > Users
    • Find the user and select the user's profile
    • Search for the permission and check the box if it's unchecked


Download the Import Resources

  1. Export your Meetings file from SalesforceIQ using the Organization Export. Your exported file will be titled, "Opportunities-XXXXXX-meetings.csv”
  2. Run an export of your Opportunity Object in Sales Cloud via Data Loader, include all fields in the export.
    • Learn more about using Data Loader to export data
  3. Run an export of your Users Object in Sales Cloud via Data Loader, include all fields in the export.
  4. Run an export of your Contacts Object in Sales Cloud via Data Loader, include all fields in the export.

Prepare the Final Import File

  1. Download and open this template. Then follow the instructions below.
  2. Paste your data in columns A, B and C. Use the data from your Opportunity Object export from Sales Cloud
  3. Paste your data in columns D and E. Use the data from your Users export from Sales Cloud
  4. Paste your data in columns F and G. Use the data from your Contacts export from Sales Cloud
  5. Copy the worksheet tab called "MeetingsTemplate", and merge it with the workbook "Opportunities-XXXXXX-meetings.csv". It should look like below:

  6. Return to the tab called "MeetingsTemplate", copy the table highlighted in blue and paste it as new columns in your tab called "Opportunities-XXXXXX-meetings.csv". It should look like screenshots below.

    *Note:
    These fields contain pre-written formulas or fixed values that will marry/merge the proper Sales Cloud values with your SalesforceIQ meetings, allowing you to map your SalesforceIQ meetings to the correct opportunity record in Sales Cloud. Do not edit or delete these formulas or fixed values as it will cause errors with your data template and data import.

  7. Do Not complete this step if you are importing meetings into Opportunities or other account based Objects in Sales Cloud
    • Follow the steps below if you are importing meetings into the Leads or Contacts Objects
      • Delete the entire column of "WhoID"
      • Rename the column header "WhatID" as "WhoID"
  8. To activate these formula fields, double-click on Row 2 in the columns (the blue fields) and delete the special character, an apostrophe ('), located at the very beginning of the formula.
  9. Then click into the formula field, on Row 2 in each column, and drag down the formula fields and fixed value fields to all applicable rows within your data set.
  10. Rename the column header “Created Date” as "ActivityDate"
  11. Rename the column header “Body” as "Description"
  12. Once the formula has populated for the whole column, you then need to copy each of the formula ID columns and paste special as Value. Highlight all of the columns and right click to select copy, then right click again, and select the ‘Paste Special’ option, choose ‘Value’ and click OK.
  13. Save this file as a .csv format, and name it “Opportunity-meetings-for-import.csv”
    • A finished version of this, with proper formatting can be found HERE, for your reference.


Import Using Data Loader

  1. Open Apex Data Loader and click Insert
  2. Log in to Salesforce as a System Administrator user
  3. Check the 'Show all Salesforce objects' and select 'Event (Event)'
  4. Browse for your final import file, titled “Opportunity-meetings-for-import.csv” and click Next.
  5. Click 'Create or Edit Map', and then click 'Auto-Match Fields to Columns'.
  6. Once you 'Auto-Match Fields to Columns', you should see something like the following screenshot below.
  7. Click OK > Next > Finish.
  8. Success and Error logs will be generated after the import is complete (see screenshot below). If you see any errors, click on "View Errors", follow the error logs to correct them. If you need additional assistance on fixing the errors, please contact Salesforce Support.
  9. The imported meeting activities are located in Past Activity section of your Opportunity record.