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

                                                                                                              • Not able to Sign In in Zoho OneAuth in Windows 10

                                                                                                                I recently reset my Windows 10 system, after the reset when I downloaded the OAuth app and tried to Sign In It threw an error at me. Error: Token Fetch Error. Message: Object Reference not set to an instance of an object I have attached the screenshot

                                                                                                              • Mapping a custom preferred date field in the estimate with the native field in the workorder

                                                                                                                Hi Zoho, I created a field in the estimate : "Preferred Date 1", to give the ability to my support agent to add a preferred date while viewing the client's estimate. However, in the conversion mapping (Estimate to Workorder), I'm unable to map my custom

                                                                                                              • Is there a way to request a password?

                                                                                                                We add customers info into the vaults and I wanted to see if we could do some sort of "file request" like how dropbox offers with files. It would be awesome if a customer could go to a link and input a "title, username, password, url" all securely and it then shows up in our team vault or something. Not sure if that is safe, but it's the best I can think of to be semi scalable and obviously better than sending emails. I am open to another idea, just thought this would be a great feature.  Thanks,

                                                                                                              • Single Task Report

                                                                                                                I'd like a report or a way to print to PDF the task detail page. I'd like at least the Task Information section but I'd also like to see the Activity Stream, Status Timeline and Comments. I'd like to export the record and save it as a PDF. I'd like the

                                                                                                              • Auto-response for closed tickets

                                                                                                                Hi, We sometimes have users that (presumably) search their email inbox for the last correspondence with us and just hit reply - even if it's a 6 month old ticket... - this then re-opens the 6 month old ticket because of the ticket number in the email's subject. Yes, it's easy to 'Split as new Ticket', but I'd like something automated to respond to the user saying "this ticket has already been resolved and closed, please submit a new ticket". What's the best way to achieve this? Thanks, Ed

                                                                                                              • How to Push Zoho Desk time logged to Zoho Projects?

                                                                                                                I am on the last leg of my journey of finally automating time tracking, payments, and invoicing for my minutes based contact center company - I just have one final step to solve - I need time logged in zoho desk to add time a project which is associated

                                                                                                              • Cannot access KB within Help Center

                                                                                                                Im working with my boss to customize our knowledge base, but for some reason I can see the KB tab, and see the KB categories, but I cannot access the articles within the KB. We have been troubleshooting for weeks, and we have all permissions set up, customers

                                                                                                              • Export to excel stored amounts as text instead of numbers or accounting

                                                                                                                Good Afternoon, We have a quarterly billing report that we generate from our Requests. It exports to excel. However if we need to add a formula (something as simple as a sum of the column), it doesn't read the dollar amounts because the export stores

                                                                                                              • why my account is private?

                                                                                                                when i post on zohodesk see only agent only

                                                                                                              • Getting ZOHO Invoice certified in Portugal?

                                                                                                                Hello, We are ZOHO partners in Portugal and here, all the invoice software has to be certified by the government and ZOHO Invoice still isn´t certified. Any plans? Btw, we can help on this process, since we have a client that knows how to get the software certified. Thank you.

                                                                                                              • 500 Internal Server Error

                                                                                                                I have been trying to create my first app in Creator, but have been getting the 500: Internal Server Error. When I used the Create New Application link, it gave me the error after naming the application. After logging out, and back in, the application that I created was in the list, but when I try to open it to start creating my app, it gives me the 500: Internal Server Error. Please help! Also, I tried making my named app public, but I even get the error when trying to do that.

                                                                                                              • Client Script | Update - Client Script Support For Portals

                                                                                                                Dear All! We are excited to announce the highly anticipated feature: Client Script support for Portals. We understand that many of you have been eagerly awaiting this enhancement, and we are pleased to inform you that this support is now live for all

                                                                                                              • Professional Plan not activated after payment

                                                                                                                I purchased the Professional Plan for 11 users (Subscription ID: RPEU2000980748325) on 12 September 2025, and the payment has been successfully processed. However, even after more than 24 hours, my CRM account still shows “Upgrade” and behaves like a

                                                                                                              • Auto Update Event Field Value on Create/Edit

                                                                                                                Hi there, I know this question has been posted multiple times and I've been trying many of the proposed similar scripts for a while now but nothing seems to work... what might I do wrong? The error I receive is this: Value given for the variable 'meetingId'

                                                                                                              • Pre-orders at Zoho Commerce

                                                                                                                We plan to have regular producs that are avaliable for purchase now and we plan to have products that will be avaliable in 2-4 weeks. How we can take the pre-orders for these products? We need to take the money for the product now, but the delivery will

                                                                                                              • Payroll and BAS ( Australian tax report format )

                                                                                                                Hello , I am evaluating Zoho Books and I find the interface very intuitive and straight forward. My company is currently using Quickbooks Premier the Australian version. Before we can consider moving the service we would need to have the following addressed : 1.Payroll 2.BAS ( business activity statement ) for tax purposes 3.Some form of local backup and possible export of data to a widely accepted format. Regards Codrin Mitin

                                                                                                              • Problem with Email an invoice with multiple attachments using API

                                                                                                                I have an invoice with 3 attachments. When I send an email manually using the UI, everything works correctly. I receive an email with three attachments. The problem occurs when I try to initiate sending an email using the API. The email comes with only

                                                                                                              • Page Layouts for Standard Modules like CRM

                                                                                                                For standard modules like quotes, invoices, purchase orders, etc, it would be a great feature to be able to create custom page layouts with custom fields in Zoho Books similar to how you can in Zoho CRM. For example, and my current use case, I have a

                                                                                                              • Non-depreciating fixed asset

                                                                                                                Hi! There are non-depreciable fixed assets (e.g. land). It would be very useful to be able to create a new type of fixed asset (within the fixed assets module) with a ‘No depreciation’ depreciation method. There is always the option of recording land

                                                                                                              • Fixed asset management

                                                                                                                I want to know if there is any individual module for fixed assets management

                                                                                                              • One time sale item in billing automatically detects as service

                                                                                                                if i have some items which i don't want to add in my "item" list because its sold only for one time. but when i type item name in invoice, it (system) automatically takes it as a service and despite of HSN , it shows SAC code to be entered. if its selectable i.e. either item or service , it would be very helpful and a must have feature.

                                                                                                              • Project template after project creation

                                                                                                                How can I apply a project template AFTER the project has been created?

                                                                                                              • convert the project to templet

                                                                                                                i have some deployment ME product for different customer , i need to create a fixed template for use it rather then keeping creating this template every time

                                                                                                              • Related Module in Sharing Rules

                                                                                                                Zoho CRM team recently added the feature to filter records by Related Records It will be really beneficial if we can have this feature for Sharing Rules as well

                                                                                                              • Assignment Thresholds Resetting After Lead Conversion

                                                                                                                Hello everyone, We're facing an issue with Zoho CRM's lead assignment thresholds that makes them unsuitable for our workflow. I'm hoping to find a potential workaround or solution from the community. Here’s our current process: A new lead is created automatically

                                                                                                              • Territory view for custom modules?

                                                                                                                I have recently activated territories however I can't seem to find how to use territories for custom modules? These modules have territories:  Contacts /  Accounts / Opportunities These modules don't have territories:   Buildings (custom module) and 

                                                                                                              • Approval Process Comments

                                                                                                                Is it possible to view the comments entered during the approval or rejection of a record in the approval process? If not, is there a way to require a field to be completed upon approval or rejection?

                                                                                                              • Login for test case

                                                                                                                Had a few questions regarding authentication test cases and couldn't find an answer in the the docs. 1. If an app like Zoho Creator requires authentication before providing access, do I need to create a login function and add it to each test case? 2.

                                                                                                              • Customer members area

                                                                                                                Does FSM support a customer members area? If not what do you propose we use if we want the data used in FSM for customers to give them an area / login to see past orders, create new orders and general announcements.

                                                                                                              • Notes created in mobile can no longer be accessed in desktop

                                                                                                                Working with a 2013 Mac running OS 10.14.6; Desktop Notebook version 4.5.3. Using Motorola Moto G Power 5G - 2024; Android app version 6.7 I have been using Notebook for some years. Starting several weeks ago, the notes newly created ion the phone can

                                                                                                              • Function #49: Manage varying installment payments using Zoho Books

                                                                                                                . Hello everyone, and welcome back to our series! Last week, we discussed automating the collection of fixed installment payments in Zoho Books. But what if your payment structure involves charging varying percentages of the invoice total as installments?

                                                                                                              • Is it possible for contacts to "Re-enter" a workflow in Zoho Campaign?

                                                                                                                We are currently working on a way to automatically add users to from one list to other lists based on specific criteria, but can't seem to find a native way of doing this so we are trying to use Workflows to do this. So, for example, if a user's status is set to "Active," then they should be added to the list "Active Users." If the same user's status is then set to "Paused," they should be added to the list "Paused Users" and removed from the list "Active Users." This works fine for the first go

                                                                                                              • Bulk upload images and specifications to products

                                                                                                                Hi, Many users have asked this over the years and I am also asking the same. Is there any way in which we can bulk upload product (variant) images and product specifications. The current way to upload/select image for every variant is too cumbersome.

                                                                                                              • Out of Office for Just One of My Alias Email

                                                                                                                Can I set up the Out of Office Reply for Just One of my Alias Email Addresses?

                                                                                                              • Can I map multiple Surveys into the CRM using the same fields?

                                                                                                                Hello, We are a healthcare practice that offers two distinct services (Nutrition and Primary Care). We use Zoho Survey for our lead generation form (Get Started Survey), which allows people to express interest in one of the two services and even allows

                                                                                                              • Dealing with API responses where integers have more than 16 digits

                                                                                                                Hi there How do I deal with an api response contaning an int or float with more than 16 digits (before any decimal places for a float). I constantly receive the response "Unable to cast the 'BigInteger' value into a 'BIGINT' value because the input is

                                                                                                              • Add Zoho Mail for users who do not need Zoho One

                                                                                                                We have licenses for ZOho One for teams that need to use the suite of products that Zoho One offers.  We have 8 more people who only need email access and we would like to add just a Zoho Mail.  They do not need the Zoho One license.  We are currently

                                                                                                              • ZML vs HTML Snippet - which is better?

                                                                                                                Are there certain use cases where one is better than the other?

                                                                                                              • Auto CheckOut Based On Shift.

                                                                                                                This Deluge script runs on a scheduled basis to automatically set the 'Actual_Check_Out' time for employees who haven't manually checked out. If the current time is past their scheduled 'Shift_End_Time', the script updates the check-out time to match

                                                                                                              • Load PO_Date field (Purchase Order) with current date in Deluge

                                                                                                                Hi, I'm not a full time developer, just helping to customize our CRM, in the small company I work for. There must be something wrong with me, because I can't do something so simple as complete a field with the current date in a function using Deluge.

                                                                                                              • Next Page