How can I associate contacts with their respective accounts while importing them through a single import file?

How can I associate contacts with their respective accounts while importing them through a single import file?

While importing the accounts and contacts using a single file, you can associate your contacts with their respective accounts. Your import file may contain both the contact and account details. Follow these steps to do so:

  1. Copy the Account information in another new file - In your import file, there may be accounts that have more than one contact associated to them. To avoid the creation of duplicate accounts, you need to separate the account information in another file. 
  2. Import data in your Accounts tab - Import the file that you created in the previous step, which has only the account information and no duplicate entries.
  3. Import data in your Contacts tab - Import the original file where you have both the accounts and contacts' information. During the import, map both the Contact related information and the Account related information.
Important Note: While importing records using the Migrate Data from other CRM feature, you need to use the ID provided by the other CRM vendor to associate contacts to the accounts.

    • Related Articles

    • Importing Data to Zoho CRM

      Data can be gathered through various sources such as, purchasing a record database, collecting from trade shows and campaigns, and so on. Importing records from such external sources to Zoho CRM is one of the most important lead creation activities ...

    • Creating Accounts

      In Zoho CRM, you can create accounts by: Entering data in the account details form: You can manually fill in the Account details gathered from various external sources. Importing Leads from external source: You can gather data through various sources ...

    • While importing contacts into Zoho CRM, is there a way to import notes available with the correspon

      While importing contacts, you need to map the Notes column in the import file with the Description field of Zoho CRM. This will help you to import the notes along with the contacts.

    • Can I move deals to a particular pipeline and assign a stage during data migration or import?

      Migrating from another CRM: When you migrate from another CRM, the Pipeline field will be available during field mapping. The deals will be assigned to the layout's pipeline based on this field. If the deals that are to be migrated do not have a ...

    • Importing Contacts from G Suite

      The Import Contacts feature helps you import contacts from G Suite to Zoho CRM. It gives you the advantage of accessing your Google contacts from Zoho CRM, without having to sign in to your Google account, every time you want to import. The imported ...