What's New in Zoho DataPrep?
2023
Oct
"Products" module added to Zoho CRM integration
EnhancementYou can now export your prepared dataset to Zoho CRM's Products module from Zoho DataPrep. Here's the full list of all supported modules you can export your data to in Zoho CRM. Learn more
Export data to FTP
New Feature
Column Explorer
New FeatureThe Column Explorer feature allows you to search for, navigate to, and control visibility of the columns in your dataset. It helps you focus on the columns that matter in your dataset.
Sep
Improvements to Open AI powered transforms
EnhancementThe Open AI Chat GPT powered transforms, namely, Transform by Example and Formula Generator in Zoho DataPrep gets a facelift! You can now get the output column names contextually auto-generated by ChatGPT based on your input prompt. Learn more
Also, the transforms are now equipped with a re-try mechanism which gets you the best result out of ChatGPT's response by re-trying the query automatically in a different way if the output data did not match your expectation. Learn more
UI/UX improvements to import and export wizard
EnhancementIntroducing enhanced data import and export wizard. The UI/UX improvements lets you seamlessly bring in data into Zoho DataPrep for data wrangling and push prepared data to your destination neatly in a couple of steps.
Aug
DataPrep is now listed in Zoho Directory
Zoho Directory, a platform for workforce identity and access management, now has Zoho DataPrep listed. You can now seamlessly manage your organization users from Zoho Directory and have them added automatically in Zoho DataPrep.
Jul
Improvements to ruleset
EnhancementThe ruleset pane is revamped with a whole host of new features to make it easier for you to work with the rules. You can now selectively choose some rules to create a template, import and export your ruleset as files, bulk select to move around the rules, or choose to delete them from your ruleset and more. Learn More
Import Query Tables from Zoho Analytics
EnhancementMay
Generative AI built with OpenAI technologies
New FeatureOpenAI's ChatGPT integration with Zoho DataPrep enhances your data wrangling process multifold with advanced generative AI features powered by ChatGPT API. Here's how you can enable OpenAI integration for your DataPrep Org.
Note: The OpenAI integration is live only in US, EU, and IN Data Centers.
Transform by Example powered by ChatGPT API
New FeatureTransform by example easily helps you transform the data in any column just by providing examples of the output. Learn more
Chat Formula Builder powered by ChatGPT API
New FeatureUsing the formula builder, you can enter your data requirements in natural language as prompts, and the formula will be generated automatically for you. Learn more
Dataset Finder built with Open AI's ChatGPT API
New FeatureDiscover relevant public datasets and generate sample data by simply asking for it. Dataset finder enables you to generate datasets based on your data needs. Blend generated data with your dataset for data enrichment, data analysis and more. Learn more
Mar
Set up data pipeline using Zoho CRM Connector
New FeatureIntroducing export feature in Zoho CRM connector. You can now export clean, aggregated, and prepared data straight to your Zoho CRM account and build a robust sales data pipeline. Zoho DataPrep helps you continuously clean, prepare, migrate, and warehouse your CRM sales data. Learn more
Feb
Deduplicate transform
Deduplicate transform now supports Date Time, Duration, List, and Map data types with even more manual conditions to perform deduplication.
Learn moreSSO for Microsoft OneDrive
DataPrep now supports SSO for Microsoft OneDrive. You can now seamlessly access to import data from Microsoft OneDrive, and export back your data.
Jan
Custom duration format
EnhancementYou can now create your own duration format using custom duration format support in DataPrep. You can also pick from one of the many newly supported predefined duration formats.
Learn moreZoho Databridge's silent installation
EnhancementYou can now perform a silent installation of Zoho Databridge on a Linux machine using the command line. This is useful to retrieve data from systems not having a graphical user interface.
2022
Dec
Amazon S3
Introducing Amazon S3 advanced selection to import data from your S3 bucket's folders using file pattern matching capability. You can also export to a specific location in your S3 bucket with this update.
Learn moreOct
Google BigQuery Connector
Introducing Google BigQuery connector in Zoho DataPrep. You can now import and export data using Google BigQuery connector and create data pipelines.
Learn MoreSep
Filter support for more transforms
You can now apply transforms such as Create buckets, Cluster and merge, Fill empty cells, Keyword extraction, and Language detection along with conditional filters.
Learn MoreJul
Target matching feature updates
Target matching is revamped with a whole host of new features to catch possible errors before exporting data to your destination.
Learn MoreAdd constraints to columns
You can add constraints to your column data as part of the Change data type transform.
Learn MoreAdvanced filters
The Advanced filters option allows you to filter data based on custom conditions applied over one or more columns.
Learn MoreJun
Extract from time
You can now extract time components by applying the Extract time transform on a time column.
New filter options added
Filter options "All column" and "Any column" have been added. Delimiters and case-sensitive options in the filter transform are now supported under the wildcard tab.
May
Change time and duration formats
Change time and duration transforms introduced.
30+ Time and Duration related functions introduced
You can now add new formula columns using 30+ time and duration related functions.
Apr
Time and duration as data types
Time and Duration are newly supported data types. This also includes formatting transforms and formula functions based on these data types.
Learn moreTransform with filters
You can now apply transforms such as Replace text, Split text, Extract data, etc. along with conditional filters.
Learn moreBetter XML file handling during import
XML files are readily flattened during the import process making it easier to handle the data.
Mar
Connect to data in shared folders from Dropbox
Connect and import data from the shared folders of your Dropbox into Zoho DataPrep.
Feb
Cloud Storage - File versioning
File export option lets you choose to update the file with a new version, or add a new file at your data destination during every export.
Learn morePagination in URLs
You can now import larger data in batches using the pagination functionality when you import data from URL and feeds.
Learn moreJan
Zia help widget integration
Get contextual help - Zia help widget lets you refer help articles from within the DataPrep application. You can also move around the widget pane and work with your data contextually.
Shared files support for Google Drive
You can now import files shared with you in Google Drive in your shared folder.
2021
Dec
Google sheets Import
New FeatureThe Google sheets connector now allows you to import your data from Google sheets into Zoho DataPrep directly.
Connect to data in shared folders from cloud storage services
New FeatureConnect and import data from the shared folders of your Box and OneDrive with Zoho DataPrep.
Nov
Zoho DataPrep now in Zoho One
Zoho DataPrep is now included in Zoho One. With this update Zoho One users can now enable Zoho DataPrep and start using it with their existing plan.
Learn moreChange data type for multiple columns at once
New FeatureWith this feature, you can now select multiple columns at a single time and change their data types with a single click.
Learn moreOct
Zoho CRM connector
New FeatureZoho DataPrep helps you clean, prepare, migrate and warehouse your CRM sales data in more than one way. Enhance your Zoho CRM experience with Zoho DataPrep.
Learn moreAug
Integration with Zoho Workdrive
New FeatureConnect your data in Zoho WorkDrive with Zoho DataPrep and schedule data imports and exports seamlessly.
Learn moreJul
Zoho DataPrep is publicly launched!
Support for more data sources
EnhancementYou can now import data from Amazon S3 and Local databases such as Pervasive SQL, DB2, Exasol, SQLite, Greenplum, Progress OpenEdge, Yugabyte DB, Microsoft Access, Actian Vector, SAP Hana and Denodo. You can also connect to any local database that supports JDBC using the JDBC URL.
Learn morePivot transform
New FeatureThe pivot transform distributes the data for easy consumption. It spreads out the data in long, winding tables by converting categories in rows to columns.
Learn moreSystem-wide search powered by Zia
New FeatureZia, Zoho's AI assistant for business is now integrated with Zoho DataPrep to perform a global faceted system-wide search of your data.
Learn moreFilter transform
EnhancementCleanse data using complex data filters based on wildcards, patterns, data quality and regex.
Learn moreWindow functions
New FeatureWindow 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 moreMar
Public beta of Zoho DataPrep
Smart selection
New FeatureSmart selection offers you an array of suggestions using the pattern matching notations when you select portions of the column data that you wish to transform.
Learn moreData cataloging
New FeatureData cataloging helps with data management and discoverability depending on the usage of data assets, their status, and associated information.
Learn more2020
Sep
Closed beta of Zoho DataPrep
Closed beta program for Zoho DataPrep launched for select Zoho customers.