Remove data duplicates

Remove data duplicates

    1. Select the range of cells from which you want to detect the duplicates 

    2. Click the Data menu.

    3. From the menu, select Data Cleaning .

    4. Click on Find Duplicates

    5. The Data cleaning tool will let you know the number of duplicate and unique values in the selected data.

    6.  Choose the desired options, before selecting the action to be performed, i.e. delete, highlight, move or copy the duplicates.

    • Related Articles

    • 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 ...

    • How do I remove sample data from Zoho CRM?

      To remove sample data from your CRM account, do the following: Go to Setup  > Data Administration > Remove Sample Data. Click Yes, Proceed. The sample data removal process will be scheduled. You will be notified once the sample data has been ...

    • 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 ...

    • Find and remove data inconsistencies

      1. Click on the Data menu. 2. From the Data Cleaning option, select Fix Data Inconsistencies from the drop down. 3. In the data cleaning panel, choose a column from which you want the tool to pick the inconsistencies from. 4. The tool will list down ...

    • I have a spreadsheet in which I suspect there are duplicate email IDs. Does Zoho CRM automatically prevent import of these duplicates?

      No. Zoho CRM does not prevent duplicates during import if they are within your import spreadsheet. However, Zoho CRM provides duplicate check during import on email addresses with records that already exist in the CRM database. When this feature is ...