Find and remove data inconsistencies

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 capitalization errors, typos and inconsistent spellings in the column. Eg: Laptop, laptop, Lap top

    5. You can choose to replace two or more iterations of the same word or entry into one, by keying in one single format to be applied across the word cluster.

    Zoho DataPrep Personalized Demo

    If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

    Zoho CRM Training

      Create, share, and deliver

      beautiful slides from anywhere.

      Get Started Now

              Zoho CRM Training Programs

              Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

              Zoho CRM Training

                  Zoho SalesIQ Resources

                      Zoho TeamInbox Resources

                                Zoho DataPrep Resources

                                  Zoho DataPrep Demo

                                  Get a personalized demo or POC

                                  REGISTER NOW

                                    Design. Discuss. Deliver.

                                    Create visually engaging stories with Zoho Show.

                                    Get Started Now

                                                          • Related Articles

                                                          • Find and replace data

                                                            1. Click on the Search bar on the right top corner. 2. Click on the drop down menu in the search bar, and from there choose More options. 3. Once this done, a Find and replace dialogue box will appear. 4. In the dialogue box, key in the word you are ...
                                                          • 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 ...
                                                          • Format data in cells

                                                            To apply or edit formats: Tap on the cell(s) containing the desired data to be formatted. You can use the Smart Tool Bar at the bottom for quick formats such as Bold, Fill/Text Color, Alignment, and Number Formats. This Smart Tool Bar will show ...
                                                          • Create pivot tables to analyse your data

                                                            Create a pivot table in sheet To create a pivot table: Click Data > Pivot Table. Choose the range of cells from which the table is to be constructed and where the table must be created Drag and drop the fields into the desired positions in the Pivot ...
                                                          • Get AI recommended charts and pivots for your data

                                                            What is Zia? Zia, Zoho Sheet's Artificial Intelligence recommends personalized charts and pivots for your data. You can even ask queries in natural language about the data to Zia. Look for Zia's suggestions Click on the Zia icon on the bottom right ...



                                                          Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                          Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                          Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                          CRM Tips

                                                          Make the most of Zoho CRM with these useful tips.

                                                            Zoho Show Resources