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

    • Import Contacts from a file

      Zoho Campaigns allows you to import contacts from other sources into a mailing list. Before you begin importing contacts, make sure that you've created a mailing list to save the data. In this guide, you’ll learn the different ways to import contacts ...
    • How to import a CSV file with multiple contacts associated to a single Account/ Company Name?

      You can import a CSV file with multiple contacts associated to a single account or company name by adding a column for the Account Name and another column for related contacts in the CSV File. If you import contacts using only the account or company ...
    • Import leads from file

      Zoho Campaigns allows you to import leads from other sources into a mailing list. Before you begin importing leads, make sure that you've created a mailing list to save the data. In this guide, you’ll learn the different ways to import leads from ...
    • 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 ...
    • Import Data

      Importing records into your Recruit account can help you create new candidates from data gathered through various sources, such as a purchased record database or records from different business units. You can import records using two features: Import ...