Technical limitations
Look into the below sections to understand the scope and limitations of Zoho DataPrep.
The sections below covers the various technical limitations in Zoho DataPrep.
Import limits
Description | Limit |
| Maximum JSON file size supported during import | 20 MB |
| Maximum XML file size supported during import | 20 MB |
| Maximum local file size (other formats) supported during import | 100 MB |
| Maximum local file size supported to import via Zoho Databridge | 100 MB Note 20 MB for JSON and XML files |
Maximum file size supported to import from cloud storage services | 1 GB |
Maximum file size supported to import from FTP | 1 GB |
Maximum file size supported to import from FTP via Zoho Databridge | 100 MB Note: 30 MB for JSON and XML files |
Maximum file size supported to import from URL | 1 GB |
Maximum number of files or tables supported during import | 10 |
Maximum records that can be imported from Zoho Analytics at a time | 10 million |
Maximum records that can be imported from Zoho CRM at a time | 6 million |
Maximum records that can be imported from Zoho Creator at a time | 5 million |
Export limits
Description | Limit |
Maximum file size that can be exported to FTP | 1 GB |
Maximum file size that can be exported to cloud storage services | 100 MB |
Maximum records that can be exported to Zoho Analytics at a time | 10 million |
Maximum records that can be exported to Zoho CRM at a time | 600,000 |
Maximum records that can be exported to Zoho Creator at a time | 1 million |
Organization, workspace and other limits
Description | Limit |
Maximum number of workspaces in an organization | 100 |
Maximum number of users in an organization | 100 |
Maximum number of connections in an organization | 200 |
Maximum number of ruleset templates in a workspace | 500 |
Maximum sample size supported | 5 MB |
Maximum cell size limit | 2 MB |
Maximum number of rules per stage | 500 |
Maximum character limit for entity names (such as org name, workspace name, pipeline name, etc.) | 100 |
Maximum number of clusters found in cluster and merge transform | 300 |
Pipeline and related limits
Description | Limit |
Maximum number of stages per pipeline | 300 |
Maximum number of data sources per pipeline | 100 |
Maximum number of destinations per pipeline | 100 |
Maximum number of pipeline schedules allowed in an org | 250 |
Maximum number of trigger-based jobs allowed for a pipeline in an hour(From Zoho Flow and Webhook) | 4 |
Maximum number of pipeline templates in a workspace | 500 |
| Maximum number of columns allowed per stage | 500 |
Maximum number of unstructured destinations per stage | 3 |
Access your files securely from anywhere
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 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 Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Zoho FSM Video Tutorials
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho CPaaS?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Import data from a local filesystem
In DataPrep, you can import various file types, including CSV, TSV, JSON, HTML, XLS, XLSX and XML. With this connector, you can streamline your ETL workflows, enable smooth data movement, and simplify data integration between local files and Zoho ...Zoho DataPrep 2.0 - Pricing FAQ
1. What are "rows processed"? 2. How do you calculate "rows processed"? What rows are counted towards "rows processed"? 3. How many data sources and destinations are counted for the license? 4. What is the batch size in Zoho DataPrep? 5. How do I ...Zoho DataPrep - User Guide Overview
Zoho DataPrep is an advanced self-service ETL software. You can move large volumes of data from multiple data sources to various destinations to serve data analytics and data warehousing with exceptional data quality. You can also clean, transform ...Import incremental data from local files
Incremental data fetch is a method used to import new files or modified files from a source. Zoho DataPrep helps you import incremental data from your local files using Zoho Databridge. In DataPrep, you can incrementally import various file types, ...HubSpotCRM connector for Zoho DataPrep [BETA]
The HubSpotCRM connector for Zoho DataPrep allows you to seamlessly bring in your sales data from HubSpot. You can import your sales data from HubSpot to perform data cleanup, data migration, and data backup in more than one way. With this connector, ...
New to Zoho LandingPage?
Zoho LandingPage Resources