Tip #8: Merge Duplicate Records

Tip #8: Merge Duplicate Records

Hello everyone,
We hope that you are finding our CRM Tips and Tricks useful. Let us know if you are looking for tips on specific topics by commenting below.

This week, we are back again with another tip on the clean CRM series.

Tip #8: Merge Duplicate Records
Going by our earlier tips, you are now aware of the proactive ways in which you can avoid duplicate records in Zoho CRM. In spite of following them, some of you might still doubt that your system carries some duplicate records. If you are wondering how to find and fix duplicates, you can use De-duplication tools to clear them up. Let's see when and how to use these De-duplication tools in Zoho CRM.

Find and Merge Duplicate Records
Sometimes, you might be aware that specific records carry duplicate entries in your Zoho CRM account. In such cases, when you know which records have duplicates, you can simply go to the Detail page of this record, and use Find and Merge Duplicate to fetch its duplicates.

For example, you know that a lead called "Brian Dolan" has been duplicated and you want to find and merge them all into one record. In this case simply go to the Leads module and click Brian Dolan. In the Detail page of Brian Dolan, click the More icon and select Find and Merge Duplicates.

Follow the required steps and merge the multiple records into one Master Record.


De-duplicate Records (Auto-merge Duplicates)
This tool comes handy when you simply doubt that your CRM account carries duplicates, however you don't know which ones. You can let Zoho CRM run an overall check on each module using the De-duplicate tool. Let's look at an example.

Simply go to the Leads module, click on the More icon and select De-duplicate. Select fields based on which you wish to run a duplication check. For example, you can select Company Name and Email address. Zoho CRM will search for all the records in the Leads module in which the Email and Company fields' values are same. CRM will automatically find and merge the exact matches. In case of conflicts in field values, you must manually resolve the conflicts and merge records.

For example, as you can see in the image, the email thomas.clark@gmail.com has three exact matches. The system will auto-merge these three records.

However, there are two records for david.wilson@gmail.com with two different phone numbers. In such cases, you will have to resolve the conflict by choosing which phone number should be retained. Once you resolve the conflict, the two records will be merged as one.

Voila! Your system is now free of duplicates.

Click here to know more about the De-duplication tools in Zoho CRM. Try them for yourself and let us know what you think by commenting below.

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • Sticky Posts

          • How to reach the official Zoho Support channels and avoid fake ones.

            Dear Customers, Thanks a lot for choosing Zoho! Our applications are built to help achieve your day-to-day business goals. We are committed to engaging with you, to understand and develop solutions that enhance your productivity.  We are happy and ready to help you use our services effectively. Understanding and avoiding fake support Just like using popular bank names and financial applications for phishing purposes, using Zoho and claiming to be providing Zoho Support or services with false numbers
          • Function #35: Close all tasks associated with a lead and create a new task.

            Welcome back everyone! Last week, we learnt how to close all tasks of a deal depending upon the deal stage. This week, let's look at a custom function that lets you close all of the tasks associated with a lead while simultaneously creating a new task, like when you need to halt all progress towards a lead while the lead is not available at the moment but create a reminder task. Business scenario: The success of a company, in one way or another, is determined by the leads it gets. Each lead is just
          • Zoho CRM Webinar - Redesigning Daily User Experiences with Canvas

            <br> Your users across roles use the CRM for day-to-day tasks that are necessary. Whether they perform their tasks on time, the right way, or at all depends on a lot of factors, including User Experience. Many businesses struggle with rigid layouts,
          • Join us at the Canada ZUG Meetup: What’s New in Zoho CRM

            Hello Zoho Community! Start your year with fresh insights into Zoho CRM’s latest updates and tools. Whether you're a CRM beginner or a experienced user, this meetup is crafted to help you optimise your processes and leverage new features. Explore practical
          • CRM Hack #2: Automate sending of birthday greetings to your customers.

              Hello everyone! What sets you apart as a sales person is your ability to add that personal touch to your business relationship with your customers. Sending a gift on a special day, or leaving a note wishing them on their birthdays, are small, yet significant actions that show your customers that you care. And these are actions done without any expectations :) You must be engaging with a lot of customers and it is highly unlikely that they all are your friends on Facebook or some social channel,

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ



                                ご検討中の方

                                  • Recent Topics

                                  • Looking back at Zoho Calendar in 2025

                                    Hello Zoho Calendar Community, As we step into a brand-new year, we’d like to take a moment to thank you for being an active and valued part of the Zoho Calendar community. Your trust, feedback, and continued engagement motivate us to keep evolving and
                                  • There was an error while connecting to GSTN

                                    I am trying to file GSTR1. Everything flows smoothly until I reach the final step of filing the return. After I enter the PAN and OTP for filing it raises the error "There was an error while connecting to GSTN"
                                  • Zoho Books Extension: What Happens If Custom Fields Already Exist?

                                    When developing Zoho Books extensions, what happens if the target Zoho Books organization already has a custom field with the same API name as one defined in the extension? I’m asking because we originally created an on-Books version of this functionality,
                                  • Internal Server Error (500) When Attempting to View Banking Transactions

                                    I am experiencing an Internal Server Error (500) when attempting to view transactions across all of my banking accounts. Despite multiple attempts to resolve this, I have received little more than runaround from support, and the issue remains unresolved.
                                  • How do I add a blank line to the Organisation Address Format?

                                    I'd like to have my VAT number, for example, shown prominently by having a clear gap between it and the address block above, but any blank lines in the address format get ignored in PDF outputs.
                                  • Automatic Invoice Number generation for createRecord

                                    Hello, while testing some custom Buttons in my Zoho Books application, I noticed that I get an error that previously did not occur. After some further digging I found that the automatic transaction numbering of invoices no longer work in my organization.
                                  • Adding number of days to an estimate.

                                    I need both QTY of item and "number of days hire" in my estimates at the line item level. Any clues as to how this is done would be greatly appreciated. It needs to calculate. Thanks J
                                  • Books Api: listing expenses created after certain dates

                                    Is there any parameter I can add to the List Expenses endpoint that will let me look up expenses by when they were created?
                                  • Why can't we change the Account type from an Expense to an Asset?

                                    Like the question. Why in QuickBooks for example if I mistakenly created an account as an expenses and I already captured information in those accounts, I can just change the account type from expense to asset
                                  • Nueva edición de "Ask The Expert" en Español Zoho Community

                                    ¡Hola Comunidad! ¿Te gustaría obtener respuestas en directo sobre Zoho CRM, Zoho Desk u otra solución dentro de nuestro paquete de CX (Experiencia del Cliente? Uno de nuestros expertos estará disponible para responder a todas tus preguntas durante nuestra
                                  • Is it possible to do validation for the Actions added to Reports?

                                    We have an all-around On Validate function that checks all the possibilities before the Created/Edited form submissions. We want to have a button in the report view, so we can change records without entering. We are able to add this button, and it does
                                  • Ability to Edit Ticket Subject when Splitting a Ticket

                                    Often someone will make an additional or new request within an existing ticket that requires we split the ticket. The annoying part is that the new ticket maintains the subject of the original ticket after the split so when the new ticket email notification
                                  • [Free Webinar] Environments in Zoho Creator - Creator Tech Connect

                                    Hello Everyone, We’re delighted to kick off the 2026 edition of the Zoho Creator Tech Connect Series and are excited to continue this learning journey with you. The Creator Tech Connect series is a free monthly webinar featuring deep-dive technical sessions
                                  • Zoho Voice API SMS

                                    I made a post request in Zapier to try to send an SMS. Authentication appears to be configured correctly. I followed the documentation and I'm getting a 400 Error "Internal Server Error". Not helpful at all. Anyways, I could not find any information on
                                  • How do I change (error) display messages

                                    Hi! I would like to edit display messages like "invalid entries" and "enter a value for Nome" and so on into Italian language messages. How can I do that? Already tried on Validate on form submit. Where I am failing? Thanks in advance.
                                  • Record Overseas Transactions Along with CC charges

                                    Hi All, We receive payments via stripe in multiple currencies and stripe takes around 2.5% fees. The amount is settled in INR into our local bank. What should be the currency of the income account used for Stripe payments? Here is a sample flow that we
                                  • Easier onboarding for new users with stage descriptions

                                    Greetings, I hope all of you are doing well. We're happy to announce a recent enhancement we've made to Bigin. You can now add descriptions to the stages in your pipeline. Previously, when creating a pipeline, you could only add stages. With this update,
                                  • Pieds de page personnalisé - Document Zoho Writer

                                    Bonjour à tous, Je rencontre un souci avec l’ajout d’un pied de page personnalisé dans un document Zoho Writer. Je souhaite insérer les informations de mon entreprise (notamment un logo + adresse) dans le pied de page. Le problème, c’est que lorsque j’ajoute
                                  • Permissions on Views

                                    Having the option of any agent creating custom views is firing back and got a situation where there are a hundred different views across the team and tickets are not being dealt in the most efficient of ways. Tickets seems to be missed by some agents,
                                  • Credit card transactions are backwards after importing statements

                                    I am new to Zoho Books so I'm importing my firm's bank and credit card statements in. My credit card statements have a single column with negative numbers so that is the option I chose. But when I went to categorize the credit card transactions, I can
                                  • import data from Apollo.ai into zoho crm via zoho flow

                                    I might be asking this question in the wrong forum. We use Apollo.ai to find potential new leads for our business, there are around 10000 leads that we have initially found. We have an Apollo.ai account but just to do searches, we dont use it as a crm.
                                  • Knowledgebase SEO

                                    We have a custom-domain mapped help center that is not restricted via login. I have some questions: a) will a robots.txt file still allow us to control indexing? b) do we have the ability to edit the sitemap? c) do category URLs get indexed by search
                                  • VIsual maindmaps in Zoho notebook Ai

                                    Can I create and export VIsual maindmaps in Zoho notebook Ai
                                  • 1stDibs Integration to Zoho Inventory

                                    Hello is it possible to integrate my Zoho inventory and 1stDibs?
                                  • Community Question: Renewal vs Invoicing

                                    This is a question for the community. Does anyone else consider there to be a difference between a subscription renewal event and sending out a recurring invoice for a subscription? For example, let's say customer XYZ purchases a 1-year subscription to
                                  • Scheduled Reports - Do not send empty report

                                    Hello, We are intensively using reports in the CRM, especially for sales managers. When data is empty, they still receive an email. Can you add an option to avoid sending the report when data is empty?
                                  • Is Zoho One Desktop more secure than Zoho One Web SaaS?

                                    Is Zoho One Desktop more secure than using Zoho One in browser? Inherently, it seems desktop would be unless you don't do things like share your pw or leave pc on. I am concerned about data being on the cloud or someone else's server and database.
                                  • Reminder Settings - Time Tracker

                                    On the time tracker in Reminder Settings I created a reminder according to the Zoho manual. But a manager asked me to change the message that goes in the email. Is it possible to change the message? I didn't find that in the Zoho manual. Another question: I configured to receive the reminder everyone who logged in less than 40 hours. Does Zoho consider less than 40 hours of the current week or the whole month? Another situation, I put it so that I and another specific user would receive the notification,
                                  • Create Item group from a composite Item

                                    I have applied my mind for hours but cannot figure this out. Can you have a composite item in an item group?. E.g. We bundle different color and size SKU's together as composite items. Also Using composite items as Bill of Materials. We want to create
                                  • Main difference of Zoho Recruit Corporte version and Staffing HR vesion

                                    Hi Zoho, I need help to fully understand what is the main key point differences of Recruit Corporate version versus the Staffing HR version? We are currently using Corporate HR version and we are looking on having an insightful automated reporting, does
                                  • Out of Stock items showing in Commerce

                                    I have over 6000 items and most are not in stock, but all items are showing up in Commerce whether they are inventory or not. What option or feature can you use to hide items in Commerce at zero or negative quantities? I currently am using Commerce for
                                  • Is it possible to transfer data from one related list to another within the same module ?

                                    In the Leads module, there is an existing default Product related list that already contains data. Recently, I added a custom multi-lookup field, which created a new related list in the same Leads module. Now, I need to move the existing data from the
                                  • How to implement new online payment gateway?

                                    Hello, Can you tell me how to proceed to implement my local payment gateway? DIBS has an open avaiable API that should be easy to implement into ZOHO BOOKS. http://tech.dibspayment.com/dibs_payment_window
                                  • How to use MAIL without Dashboard?

                                    Whenever I open Mail, it opens Dashboard. This makes Mail area very small and also I cannot manage Folders (like delete/rename) etc. I want to know if there is any way to open only Mail apps and not the Dashboard.
                                  • Formula working in MS Excel , is not working in Zoho Sheets, Filter fuction which is working in MS sheets per the attached workbook / Daily update.

                                    Filter function , which is working in MS Excel is not working in Zoho sheets. Please help on function of filter of particular class sheets and extract students name who has more than 3.5 hours of study hours on particular day depending on date in D7 cell.
                                  • New in Smart Prompt: Record Assistant for contextual assistance, and support for new AI models

                                    Smart Prompt helps teams stay informed and move faster by providing relevant suggestions where work happens in CRM. With this update, Smart Prompt becomes more adaptable to your organization’s AI preferences. You can now choose which Large Language Model
                                  • Improved Integration Failure Information (And Notification Options)

                                    Hi, When an attachment service for example fails, you just get "Field x - Error", I can check the field it is failing on and find nothing wrong, same file size, type, dimensions, etc. so more information as to the actual issue would be helpful. And an
                                  • Create static subforms in Zoho CRM: streamline data entry with pre-defined values

                                    Last modified on (9 July, 2025): This feature was available in early access and is currently being rolled out to customers in phases. Currently available for users in the the AU, CA, and SA DCs. It will be enabled for the remaining DCs in the next couple
                                  • Change User Role in a Form

                                    Hi, When in a form, it would be good (And consistent) to be able to change the user role/permission like you can with Shared Reports, All Entries or the actual User itself, rather than having to delete the users permission and then add it back again with
                                  • Reassign Partially Saved Entries

                                    Hi, I would like to be able to go to Partially Saved Entries and like the option to delete them I would like the option to multi-select and be able to reassign them to another user to complete (Such as when a user has left the company). Thanks Dan
                                  • Next Page