Zoho DataPrep is now launched!

Zoho DataPrep is now launched!

We are excited to announce the launch of Zoho DataPrep – An advanced self-service data preparation and data pipeline service. 


Introducing Zoho DataPrep

Zoho DataPrep helps organizations prepare data by automatically identifying errors, discovering data patterns, and transforming and enriching data, all without the need for any coding. It also helps in setting up pipelines to sync prepared data to a wide variety of destinations including Zoho Analytics, or to data warehouses.



We want to thank all beta users whose valuable feedback helped us improve the product since the beta launch, a few months ago. We have also enhanced the product with more features during the beta to make data preparation even easier and robust. Here are some of the highlights.

New data sources

Apart from the data sources such as files, feeds, local databases, cloud databases, and cloud storage services we already support, we have now added more data sources like Amazon S3 and local databases such as Pervasive SQL, DB2, Exasol, SQLite, and many more. Learn more 


Pivot transform 

The pivot operation distributes the data for easy consumption. It spreads out the data in long, winding tables by converting categories in rows into columns. Learn more 


System-wide search powered by Zia  

Zia, Zoho’s AI assistant for business is now integrated with Zoho DataPrep and it helps you to perform a system-wide search of all your data. Learn more


Advanced  Filters  

Cleanse data using complex data filters based on wildcards, patterns, data quality, regex, and more. Learn more 


Window functions  

Window functions enable you to perform summations and calculations based on a rolling window of data, relative to the current row. Unlike normal aggregate functions, the window functions keep the original rows intact and add the result as a new column. Learn more 


We’ve been hearing great things from our early adopters!

“From the time we got access to Zoho DataPrep we have put our IT team to the task of integrating our call center data into Zoho DataPrep, so that when we push it to Zoho Analytics, we should be able to offer metrics and data at the customer level. Being able to do this will change the way we do business, and allow us to be competitive in a space not possible before — without crippling fees for dynamic coding. Our eyes are firmly on the future now, thanks to Zoho DataPrep.”
Marc Fishman
Director of Sales and Marketing, Call Center Sales Pro

“We spend a lot of time writing and maintaining custom scripts to import data, fix errors and transform the data. Using Zoho DataPrep, we easily found the errors in the data and fixed them all from within the tool. We are now looking to eliminate manual scripts and use Zoho DataPrep to automate data preparation.”
Claudio Cabeza
Business Development Director, Grupo Premo

Go ahead and explore!

Try Zoho DataPrep with a 15-day no-commitment free trial now!


SIGN UP FOR FREE


    • Sticky Posts

    • Announcement: Migrate your workspaces to Zoho DataPrep 2.0

      Zoho DataPrep 2.0 was recently launched with exciting new updates to the platform. You can read more about the new updates in the previous announcement. To take full advantage of the new data pipeline features, migrate your existing workspaces from the

    • 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

    • Announcing DataPrep 2.0 Beta!

      Being data-driven is an important end goal for all organizations, because when businesses can manage, analyze, and make actionable decisions based on data, they have a competitive advantage. With that said, how confident are you in making business decisions

    • Zoho CRM connector's export functionality enables end-to-end CRM data pipeline

      We're thrilled to announce an update to our Zoho CRM connector that will enable you to create data pipelines to Zoho CRM. The public beta of "export to Zoho CRM" is now available, and can be enabled for users requesting it via email. Using the feature,

    • Zoho DataPrep is now launched!

      We are excited to announce the launch of Zoho DataPrep – An advanced self-service data preparation and data pipeline service.  Introducing Zoho DataPrep Zoho DataPrep helps organizations prepare data by automatically identifying errors, discovering data

    • Recent Topics

    • How to Add and Manage Flexible Shift Patterns in Zoho People

      I am managing a team of 40 employees and need to set up flexible shift patterns in Zoho People. Previously, I was using BrightHR, where creating a rota was simple with drag-and-drop functionality. In Zoho People, I find it more complex to assign shifts

    • COQL equivalent to zoho.crm.getRelatedRecords

      Hello i add a standalone function, that i call from my js app with ZOHO.CRM.CONNECTION.invoke etc in the function i fetch with something like this AllContacts = zoho.crm.getRelatedRecords("relation_name","parent_module_name",recordid); it works great

    • execute workflow when a package is create

      hji, there is a wey to make a workflow when a package is sended o created ?

    • Translation support expanded for Modules, Subforms and Related Lists

      Hello Everyone!   The translation feature enables organizations to translate certain values in their CRM interface into different languages. Previously, the only values that could be translated were picklist values and field names. However, we have extended

    • Trigger an action when a Product item is added to the Deal's Product Related List section?

      Hello, Is it possible, via workdlow, to trigger an action when a Product is added to the Deal's Related List section? Thank you Moderation Update: We are locking this post as a similar discussion is ongoing in the linked post below. We encourage you to

    • Search bar in portals

      Is there a way to add a search bar in portals for finding Contacts or Deals in the list?

    • Syncing Fields Between Accounts AND Deals

      Please don't email me, I will check this thread for updates daily. I have a custom set of 10 fields (CFSET) in my account pages and deals pages. I want to fill them out on accounts pages per each, then when I make a new deal in an account, I want to copy

    • Invalid SupportPlan ID Create Contract error Zoho Flow to Zoho Desk

      I get the following when trying to create a contract in Zoho Desk from a webhook from Zoho Flow. "Zoho Desk says "Validation failed for the condition : Invalid SupportPlan ID""

    • Global Sets for Multi-Select pick lists

      When is this feature coming to Zoho CRM? It would be very useful now we have got used to having it for the normal pick lists.

    • MULTIPLE SUPPLIERS

      I am a wholesale/retail business that has thousands of inventory lines that we buy from multiple suppliers. I would like to do the following: Be able to quickly identify suppliers with their MPN's, costs and lead times in the product screen so that i

    • Is there a API to fetch tasks in a Board/Section

      I am writing a scheduled function that retrieves all the tasks and send an reminder on cliq. I cannot seem to find a API to fetch tasks (by user / board / section) What are the way to fetch tasks?

    • "Invalid entries found. Please correct and submit again." error needs to be clearer

      Hi Zoho, We have had many users email us in frustration because they get the "Invalid entries found. Please correct and submit again." error and get angry because all they see is an unclear error and they think they have to start over.  They are not aware that there is a red error message on the field indicating the problem after they click OK.  Many are abandoning the form. Please add information to this error such as: Invalid entries found. Please correct and submit again.  Click OK to go back

    • Is it possible to DISABLE emailing invoices?

      My husband's not real computer-savy.  I've set up Zoho so that he can enter invoices for his customers, but I don't ever want him to accidentally send an invoice before he's reviewed it.  Up until recently, emailing an invoice would send it to me (I don't

    • Animated GIF Images in Chat

      I know this seems to be a small feature request but in a recent Cliq update Zoho disabled autoplay for animated GIFs posted in Cliq conversations. We think this was not a good change. In our organization, animated GIFs in a chat play a role in expressing

    • How can i Customize Delivery Note?

      I need to customize delivery note like change the tittle for language purposes and also include only the balance due

    • Generate a Zoho Sign link

      From time to time I get a response "I never received your you e-document for electronic signature" is there a way to generate a Zoho Sign link to share.

    • can we split the Whatsapp Message (Business Messaging) to only appear to certain user?

      I know that we can split the leads record if a user send a message through Whatsapp API in here as you can see from the image above, we assign two users to handle the messages but it seems to me that all users can see all messages in the 'Message' module

    • 【Zoho CRM】翻訳機能のアップデート

      ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中から翻訳機能のアップデートをご紹介します。 今回のアップデートにより、翻訳機能が拡張され、さらに多くの言語に対応できるようになりました。 またこれまでは、「見込み客のデータ元」の選択リストの値や商談のステージ名といった、特定の値については画面の設定言語を変更しても標準言語のままで表示され、言語変更が反映されませんでした。 今回のアップデートにより、そのような一部項目にも言語変更を適用できるようになります。

    • Zoho Visual Editor Not Opening

      Hello There I am trying to build a website using zoho and I can't open the visual editor. It keep saying Loading...  Do you know why it is happening. Thanks in Advance Regards Rajat

    • Customer Statement Template

      Hi. how can i add order number "customer LPO number" in the customer statement. regards

    • Linking an email to a Contact when the email is sent in deluge via sendmail

      The "to:" address in this code is a CRM Contact. Email address is forced unique in CRM This sendmail gets sent via a workflow which is in a custom module. It works, except that the outbound email does not appear (i.e, get linked to) the Contact such that

    • Where do i find my latest mass email draft?

      I spent hours doing an eblast, sent it out to my team, and now cannot find it in my CRM. Where do I locate drafts?

    • Introducing Bot Filtering for Accurate Email Campaign Analytics

      Dear Marketers, We're excited to announce a new feature designed to enhance the accuracy of your email campaign analytics: bot filtering. This feature helps you filter out bot-generated opens and clicks, ensuring your campaign reports reflect genuine

    • Edit HTML of forms? Add autocomplete="off"?

      Recently I've noticed that something — one customer suggested it was Chrome — is auto-filling one of my form fields with the customer's address. The field is a textarea that has nothing to do with the address — it's just a comment field. I'd like to be

    • All notes disappeared

      I've been using the notebook app for over five years on my phone without being logged into an account. A few days ago I opened the app and all my notes had disappeared. Since then I tried restarting my phone, updating the app and logging into my account,

    • Function 56: Automatically enable the option for customers to pay via bank account

      Hello everyone and welcome back to our series! One of the key features of Zoho Books is its integration with multiple payment gateways, allowing you to receive online payments for your invoices. This ensures faster payments, automates payment tracking

    • Issues hosting Zoho Desk Web Form on SharePoint and/or Power BI

      Zoho Desk onboarding support has no experience with embedding their web form in either SharePoint or Power BI. Microsoft states that SharePoint and Power BI only support iframe HTML. And unfortunately, the web form embed code that Zoho generates is not

    • Sales receipt drop down

      Is the option for Sales receipt only in a paid subscription? If it is which subscription, if it is not how do I get it up on my drop down sales tab.

    • Standalone function is not working

      Hi, We have created a standalone function to integrate with a third-party service using OAuth. However, the standalone function's REST API key is expiring automatically after some time. When we regenerate the API key from the admin account, the function

    • slider scale

      We have justed moved from Survey Monkey to Zoho Surveys. One feature that was very important in SM was a slider scale to estimate spending. We ask a question "how much money do you spend on x?" Depending on the product the scale goes from 0 to 5000+ so

    • Function went from fine to nonfunctioning without change

      url = "https://www.zohoapis.com/crm/v7/Accounts/" + id + "/Attachments/" + attach_id; file_engage = invokeurl [ url :url type :GET connection:"zoho_attachments" ]; The attach id is grabbed from a file upload field account = zoho.crm.getRecordById("Accounts",id);

    • Can I give access of my Zoho Spreadsheet?

      Hello Everbody! I work with a travel and tourism company, and my job is to record the data of clients of the company. And I use zoho for my work. So my question is can I give access of my sheet to the clients and my company. Kindly guide me. Thankyo

    • Domain verification is in progress... (How long do I need to wait?)

      Trying to setup my first email domain by connecting with GoDaddy. Have been here for quite some time and the screen is not changing. How long should this take?Send DataSend Data

    • This mobile number has been marked spam. Please contact support.

      Hi Support, Can you tell me why number was marked as spam. I have having difficult to add my number as you keep requesting i must use it. My number is +63....163 Or is Zoho company excluding Philippines from their services?

    • Unable to send message;Reason:553 Relaying disallowed. Invalid Domain

      Team, When i try to send mail through ZOHO mail i am getting the following error. "Unable to send message;Reason:553 Relaying disallowed. Invalid Domain" Can i get some help on this. Thanks

    • Zoho mail stopped receiving emails

      My Zoho email addresses that are linked to a domain suddenly stopped receiving messages yesterday, even though I've been using Zoho mail without problems for 1,5 years. I receive this reply to test emails: "553 Relaying disallowed". Due to this, my SMTP

    • Email client fails to connect to IMAP & POP EU Servers for ALL users

      For the last couple of days, all users on my account are failing to connect to the Zoho EU mails servers. This is using mobile app on various phones & desktop mail clients on different computers. Everything works fine when using webmail & email is still

    • Zoho Project API search?

      Good day, i would like to search our entire portal for a task using the API. We have over 20k tasks so I dont to search for all tasks and then do a for each as it would take way to long and also would need to go over the limit of 200 records per query.

    • My email client shows no emails anymore

      I let my account expire due to old payment method. I repurchased it I turned back on IMAP Then all my emails disapeared. Everything is fine in the webview and and zoho mail app

    • Invalid Domain

      Team, When i try to send mail through ZOHO mail i am getting the following error. "Unable to send message;Reason:553 Relaying disallowed. Invalid Domain" Can i get some help on this. Thanks

    • Next Page