1. Click Browse to load your file.
2. Select the character encoding of your file. Most users will not need to change the default character encoding setting.
3. Choose whether to match your organization’s contacts by Salesforce ID, name, or email. Similarly, choose whether to match your organization’s accounts by Salesforce ID or by name and site. Note that matching by Salesforce ID is inclusive of both contacts and accounts.
   • These Matching Type fields set the criteria for avoiding duplicates. For example, if you are matching by email and a record in your source file has the same email as a record in Salesforce, then that record will be updated in Salesforce. If you are not matching by email and there is a record in Salesforce with the same email, then a new record will be created. Note that contacts are matched only within the same account.  If contacts related to different accounts have the same name or email, they treated as separate contacts.
4. Organizations that use the Translation Workbench can specify the language of the import data.
5. Select the checkbox to trigger workflow rules for new and updated records that match workflow rule criteria.
6. Click Next to continue.

Browse for and find the .CSV import file you have stored on your computer.

What file formats can the import wizards handle?

You can import contacts and business accounts directly from an ACT! or Outlook file, or from any CSV (comma-separated values) file, such as a GoldMine or Excel file. You can import leads, solutions, custom objects, or person accounts from any CSV file.

Are there size restrictions on my import data?

Yes. Your import file cannot exceed 100MB in size, and each record in the file cannot be bigger than 400KB. In addition, each imported note and each imported description cannot exceed 32KB. Descriptions longer than 32KB are truncated.

In addition to the import file limits, your import is also subject to the overall storage limits for your organization. Note that the size of your import file does not directly correlate to the storage space needed for those records. For example, an import file of 50MB in size may not create 50MB of data in Advologix

Check the matching type information - if needed...

...The Contact and Account matching type determines the field to match by to prevent duplicates.  This is only needed when importing subsequent Accounts or contacts - after one has already been imported.

Avoiding Duplicate Business Accounts

The import wizards attempt to avoid duplicate business accounts based on:

• If Salesforce ID is the Account Matching Type:

Business accounts are matched according to their account ID. That is, if there is a record in your import file that has the same ID as a record in Salesforce, then that record will be updated in Salesforce.

1. If Name and Site is the Account Matching Type:
   • If two accounts have the same Account Name and Account Site, the wizards add your import data to the existing data in Salesforce.
   • If more than one record in your import file has the same Account Name and Account Site, the wizards merge those records and create only one account in Salesforce.
   • If two accounts have “similar” Account Name and Account Site values, the wizards add your import data to the existing data in Salesforce
   • If the Account Site field is empty in your import file, the wizards match just on the Account Name field, ignoring any site values that may exist in Salesforce.
   • Local name fields are imported but not checked for duplicates.
2. The wizards do not overwrite any existing business account fields unless you check the Overwrite existing account values box in the wizard.

With this box checked, you can insert or update existing business account fields with new data. However, you cannot use this checkbox to update existing field data with blank values. With this box unchecked, the wizard updates any empty business account fields, but does not touch any fields with existing data.

Avoiding Duplicate Contacts

The import wizards attempt to avoid duplicate contacts based on:

• If Salesforce ID is the Contact Matching Type:

Contacts are matched according to their contact ID. That is, if there is a record in your import file that has the same ID as a record in Salesforce, then that record will be updated in Salesforce.

• If Name is the Contact Matching Type:
  • For contacts with the same Account Name, Account Site, First Name, and Last Name (or the same Account Name, Account Site, and Full Name), the wizards merge your import data with existing data in Salesforce. The contact name by itself is not sufficient information for matching; you must also include the contact’s business account.
  • If two contacts have “similar” names in the Account Name, Account Site, and First Name and Last Name (or Full Name) fields, the wizards merge the contacts into one record in Salesforce. However, if two contacts have the same First Name (Local) or Last Name (Local), the wizard will not merge those records.
• If Email is the Contact Matching Type:

Contacts are matched according to their email within the scope of a given business account. That is, within a specified business account, if a contact in your import file has the same email as a contact in Salesforce, then that contact will be updated in Salesforce. If you are not matching by email and there is an existing contact in Salesforce with the same email, then a new contact will be created for that business account.

• In the absence of any record matching between your import file and Salesforce, the wizards merge duplicate records in your import file to create only one new contact in Salesforce.

For business account and contact notes in Professional, Enterprise, Unlimited, and Developer Edition organizations, the wizards de-duplicate the notes in your import file if an existing business account or contact note has the exact same text. 

In the list Above, select the fields in your import file that should be imported into each salesforce.com field.

Once you have finished, click Next:

In the list Above, select the fields in your import file that should be imported into each salesforce.com field.

Once you have finished, click Next:

In the list above, select the field in your import file that should be imported into each salesforce.com field.

Make sure to select the 'Overwrite existing account values' checkbox below if you want existing account data in salesforce.com to be updated with data in your import file.

Once you have finished, click Next

In the list Above, select the fields in your import file that should be imported into each salesforce.com field.

Once you have finished, click Next:

In the list Above, select the fields in your import file that should be imported into each Salesforce.com field.

If all fields have been mapped - click Next

If you are not the intended record owner, exit the import wizard - modify the import file and begin again.

Click Import Now