Announcing Zoho DataPrep 2.0: An AI-Powered Data Management Platform

Announcing Zoho DataPrep 2.0: An AI-Powered Data Management Platform



Originally launched in 2021, Zoho DataPrep started as an efficient self-service data preparation solution. We are excited to launch our new version 2.0, with significant enhancements to our platform to help you manage your end-to-end data needs with the help of AI
With the increasing volumes of data, preparing and managing your business data is time-consuming, complex, and prone to human errors. That’s where Zoho DataPrep comes into play. 

Key highlights of our new launch:

Visual Pipeline Builder: Build Complex Pipelines with Ease


Understanding the flow of your business data can be confusing. With Zoho DataPrep's no-code pipeline builder one can easily create complex pipelines by visualizing the flow of data. The pipeline builder makes it effortless to build, test, and run complex pipelines within minutes. 



Ask Zia – Your AI Assistant for DataPrep

Even though our DataPrep Studio's text selection feature simplifies data cleaning and preparation, the integration with Ask Zia has makes the entire data preparation process a breeze. Simply explain your data preparation needs in natural language, and Ask Zia, our generative AI assistant, will generate the required data transforms instantly.

Example: "Remove duplicates from email column and delete rows with @gmail"—and just like that, it’s done! 



Save Time with Reusable Pipelines and Pre-built Pipeline Templates

If your business has redundant processes, it can get tiring to build multiple similar pipelines. Zoho DataPrep 2.0 introduces reusable pipeline templates where once you build a  pipeline, it can be saved as a template and reused for other similar processes.  Pipeline Templates gallery is also available, which enables you to kick start your data preparation journey with pre-built templates for common use cases. 



Real-Time Monitoring Dashboard: Keep Track of Everything

Monitoring and managing your data has become easy with our new Monitoring Dashboard. Review pipeline statuses instantly and monitor all your data jobs in real-time. The monitoring dashboard gives full visibility over your various active and historic pipeline jobs within the platform.



Orchestrate Data Workflows with Zoho Flow and Webhooks

Let your data pipelines run with more flexibility with the new orchestration capabilities. With Zoho Flow, create workflow triggers for job monitoring alerts and pipeline sequencing with the exhaustive lists of applications that Zoho Flow supports. Custom webhooks lets you set up triggers for your pipelines from any business applications to ensure seamless data pipeline automations. 



More Integrations for Seamless Data Transfer

Zoho DataPrep 2.0 data connectors list now includes Salesforce, Zoho Bigin, Zoho Forms, Zoho Creator, Sharepoint, and more to make data management easy by connecting to various business applications and storage solutions. 

Why Zoho DataPrep 2.0?

With these new and improved features, Zoho DataPrep 2.0 is designed to make your data preparation faster, smarter, and more efficient. Whether you’re looking to streamline complex data flows, leverage AI for faster data transformations, or gain full control over your data pipelines, DataPrep 2.0 has everything you need. 

Ready to experience the power of Zoho DataPrep 2.0, head to our What’s New page. 


    Access your files securely from anywhere








                            Zoho Developer Community



                                Bootcamp
                                Community
                                Pricing
                                Webinars
                                What's New
                                Integrations
                                Contact Support
                                Contact Sales
                                  Zoho Survey Resources
                                    Features
                                    Survey Templates
                                    Integrations
                                    Community
                                    iOS Mobile Surveys
                                    Pricing
                                    Android Mobile Surveys
                                    Insurvey Blogs
                                    Insight Blogs
                                    Tips & Tricks





                                                Latest Feature Updates

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts




                                                      Zoho SalesIQ Resources


                                                            Manage your brands on social media
                                                            Access Zoho Social

                                                              Zoho Pagesense Resources


                                                                  Zoho TeamInbox Resources

                                                                    Zoho DataPrep Resources


                                                                      Zoho CRM Plus Resources

                                                                        Zoho Books Resources


                                                                          Zoho Subscriptions Resources

                                                                            Zoho Projects Resources


                                                                              Zoho Sprints Resources


                                                                                Qntrl Resources


                                                                                  Zoho Creator Resources



                                                                                      Zoho CRM Resources

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner







                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources

                                                                                              Zoho Writer

                                                                                              Get Started. Write Away!

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

                                                                                                Zoho CRM コンテンツ



                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                              • Recent Topics

                                                                                                              • Bigin update: Link email messages to pipeline records.

                                                                                                                Hello everyone! In the latest version of the Bigin iOS(v1.11.9) and macOS(1.8.9) app, we have brought in support for an option to link email to pipeline records. This helps you to view emails specific to a deal, especially when a contact is associated

                                                                                                              • Bigin Android app update: Custom buttons and widgets

                                                                                                                Hello everyone! We are excited to introduce custom buttons and widgets on the Bigin Android app. Widgets: A widget is a customizable UI component in Bigin that improves efficiency and user experience. It lets businesses embed components, streamline interactions,

                                                                                                              • Zoho Sheet for Desktop

                                                                                                                Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?

                                                                                                              • Zoho Sheet - Desktop App or Offline

                                                                                                                Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.

                                                                                                              • Collective-booking event not added to all staff calendars

                                                                                                                We assign two staff to certain events. When the client books this event, it adds it to one staff calendar (the 'organiser') but not the other. How can I ensure all staff assigned to a collective booking get the event in their calendar? (A side note: it

                                                                                                              • Project Management Bulletin: October, 2025

                                                                                                                Every need leads to innovation. Project Management tools were developed out of sheer necessity to drive large projects. With wide usage, the specifications grew precise, and so did the refinement. Over years we’ve crafted one of the best project management

                                                                                                              • Zoho Sheets saying locked when not locked

                                                                                                                Zoho Sheets won't let me add more rows to sheet because it's saying the sheet is locked, but the sheet is not locked. I tried using a different browser but I still have the same issue.

                                                                                                              • Identifying and Merging Accounts with Similar (Non-Exact) Names

                                                                                                                Hello everyone, I’m aware of the built-in deduplication feature in Zoho CRM that allows merging records with exactly matching values for selected fields. However, I’m running into a situation where our migrated data contains multiple variations of the

                                                                                                              • Option for super admin to recover the deleted chats in Zoho Cliq

                                                                                                                Currently, in Zoho Cliq, if a user accidentally deletes their chats, there is no option for the Super Admin to recover or view those deleted messages. I believe it would be helpful if Super Admins had a recovery option, perhaps within a certain time frame,

                                                                                                              • Zoho CRM iOS app updates: the Homepage, Zoho Survey integration, and support for multiple file uploads in subform

                                                                                                                Hello everyone! The Zoho CRM mobile app continues to evolve to bring you a smoother and more powerful CRM-on-the-go experience. We're excited to share some important updates now available in the iOS app. Here's what's new: Homepage support Zoho Survey

                                                                                                              • I am trying to integrate my module in sandbox environment to add data via API

                                                                                                                I went through the documents and tried to setup the API for adding the module via the api but the problem is the token setup is done on "https://accounts.zoho.in/oauth/v2/token" domain and the bulk write is done on "https://content.zohoapis.com/crm/v8/upload"

                                                                                                              • Setting up primary mobile number.

                                                                                                                Hi Sir Earlier I joined IIFL team and got an organizational email of zoho services. Later i quit and now my account is deactivated with IIFL but i am unable to link my mobile number to my own email id with zoho.

                                                                                                              • Tables for Europe Datacenter customers?

                                                                                                                It's been over a year now for the launch of Zoho Tables - and still not available für EU DC customers. When will it be available?

                                                                                                              • Guided Conversations - Ticket Creation

                                                                                                                Hi there, Using Guided Conversations to Take Customer Data and apply it into a Support Ticket for internal use, Is there a way to take multiple Textual Variables Inputs (A series of questions), and have the answers all appear in the Description of the

                                                                                                              • How to send certain invoices for Approval based on condition?

                                                                                                                To streamline operations, I need the invoices to go for approval when certain conditions are met. For example, if my staff gives a discount of x amount, it must go for approval. If there is no discount, then the invoice will be approved automatically.

                                                                                                              • Unable to continue payment

                                                                                                                Hi, I want to make a payment for my email subscription, but I cannot proceed with the payment because my NITKU is invalid. In Indonesia, the NITKU consists of 22 digits, but Zoho only provides 20 digits, causing my NITKU to be invalid. Please help me

                                                                                                              • Is there a way to show contact emails in the Account?

                                                                                                                I know I can see the emails I have sent and received on a Contact detail view, but I want to be able to see all the emails that have been sent and received between all an Accounts Contacts on the Account Detail view. That way when I see the Account detail

                                                                                                              • Massive spam pretending to come from our address – is this a Zoho security issue?

                                                                                                                Hi, We’ve been receiving more and more suspicious emails lately — many of them clearly look like scams. But yesterday, we got an email that appeared to be sent from our own address, which was very concerning. We're starting to wonder if this might be

                                                                                                              • Cant recieve mails

                                                                                                                I’m having an issue with my external IMAP account not fetching any emails into Zoho Mail, even though the connection test says “Success”. I can send, if someone sends an email to me. my original directory (home.pl host) recieves it in their portal but

                                                                                                              • Zoho Sheet Autofit Data

                                                                                                                While using Autofit Data function in Zoho Sheets with Devnagri Maratji or Hindi Fonts, a word or a number, it keeps couple of characters outside the right side border.

                                                                                                              • Enhancements to finance suite integrations

                                                                                                                Update on the migration (October 28, 2025): Starting this week (October 29 tentatively), we’ll begin migrating Zoho CRM users to Zoho Books as integration users. This means actions will now run under each user’s own Zoho Books access, instead of the admin’s.

                                                                                                              • Edit 'my' Notes only

                                                                                                                The permissions around Notes should be more granular, and allow to user to be able to edit the notes he created only. The edit Notes permission is useful as it allows the user to correct any mistakes or add information as needed. However, with this same

                                                                                                              • Job Alerts for Candidates

                                                                                                                hi All, I have 2 questions relating to sharing job details with candidates. 1. is there a way to notify candidates that meet certain criteria of current jobs available? eg. I run a candidate search, and identify 50 candidates that might be suitable. Can

                                                                                                              • Add multiple users to a task

                                                                                                                When I´m assigning a task it is almost always related to more than one person. Practical situation: When a client request some improvement the related department opens the task with the situation and people related to it as the client itself, the salesman

                                                                                                              • Enhancing Task Accuracy: Automatically notify the owners upon Task duplication.

                                                                                                                Hello Everyone, A Custom function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. The requirement

                                                                                                              • Nodemailer not working with Zoho

                                                                                                                Hi All, I'm having issues with Zoho working with Nodemailer. It works as expected when using gmail as the service. Below is the code I get when using zoho. Error sending email: Error: connect ECONNREFUSED 127.0.0.1:587 at TCPConnectWrap.afterConnect [as

                                                                                                              • desktop app for TODO

                                                                                                                Is there a desktop app for Zoho TODO?

                                                                                                              • Show/ hide specific field based on user

                                                                                                                Can someone please help me with a client script to achieve the following? I've already tried a couple of different scripts I've found on here (updating to match my details etc...) but none of them seem to work. No errors flagged in the codes, it just

                                                                                                              • Where are Kanban swimlanes

                                                                                                                So i've been playing with Zoho Projects Kanban view a bit more. It appears that task lists are being used as the Kanban columns, which makes sense from the implementation point of view but not the logical one.  Kanban columns are statuses that a task can flow through, while a task list has been a logical way to organize related tasks and relate them to a mislestone. In other words a task in a particular task can go through several stages while remaining in the same task list. After doing some research

                                                                                                              • Tip 19: How to display images in Pages using ZML snippets

                                                                                                                Hi folks, We're back with another tip on how to use Zoho Markup Language (ZML) to create interactive pages in Zoho Creator. You can use ZML snippets to add various kinds of components to your pages and structure them in meaningful ways. That's not all, though—using ZML you can ensure your application is automatically compatible with all kinds of devices without any inconsistencies. We often get questions from users about how to invoke Deluge scripts within ZML code. Here's a simple use case for adding

                                                                                                              • Can zoho swign format block text spacing automatically when prefilled from zoho crm?

                                                                                                                I'm sending zoho sign template from zoho crm, so that zoho crm pre-populates most fields. I have existing pdf documents that i am having signed. I have no ability to change the pdf documents, they are standardized government forms. The problem I am facing

                                                                                                              • Zoho Inventory / Finance Suite - Add feature to prevent duplicate values in Item Unit field

                                                                                                                I've noticed that a client has 2 values the same in the Unit field on edit/create Items. This surprised me as why would you have 2 units with the same name. Please consider adding a feature which prevents this as it seems to serve no purpose.

                                                                                                              • Reference lookup field values in Client script

                                                                                                                hello all, I'm using a "ZDK.Apps.CRM.Products.searchByCriteria" function call, which is returning the matching records correctly; however, one of the fields is a lookup field which I need the associated data. I believe there is a way to get this data

                                                                                                              • In App Auto Refresh/Update Features

                                                                                                                Hi,    I am trying to use Zoho Creator for Restaurant management. While using the android apps, I reliased the apps would not auto refresh if there is new entries i.e new kitchen order ticket (KOT) from other users.   The apps does received notification but would not auto refresh, users required to refresh the apps manually in order to see the new KOT in the apps.    I am wondering why this features is not implemented? Or is this feature being considered to be implemented in the future? With the

                                                                                                              • Every time an event is updated, all participants receive an update email. How can I deactivate this?

                                                                                                                Every time an event is updated in Zoho CRM (e.g. change description, link to Lead) every participant of this meeting gets an update email. Another customer noticed this problem years ago in the Japanese community: https://help.zoho.com/portal/ja/community/topic/any-time-an-event-is-updated-on-zohocrm-calendar-it-sends-multiple-invites-to-the-participants-how-do-i-stop-that-from-happening

                                                                                                              • How can I filter a field integration?

                                                                                                                Hi,  I have a field integration from CRM "Products" in a form, and I have three product Categories in CRM. I only need to see Products of a category. Thanks for you answers.

                                                                                                              • 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

                                                                                                              • Zoho CRM - Portal Users Edit Their Own Account Information

                                                                                                                Hi Community, I'm working on a client portal and it seems like the only I can make the Account record editable to the Contact, is if I add another lookup on the Account to the Contact record. Am I missing something as the account already has a list of

                                                                                                              • Connecting Zoho Mail with Apollo.io

                                                                                                                Hi, I am trying to connect my Zoho Mail account with my Apollo.io account to start sending cold email for prospecting purposes. I have activated the IMAP setting but I am still unable to connect to the Apollo account. I am using my email credentials but

                                                                                                              • Where does this report come from in the Zoho One ecosystems?

                                                                                                                Is this directly from MA, Analytics or ??? ???

                                                                                                              • Next Page