Import data from a local filesystem
To import a local file
- Files
- URL
- FTP
You can also click the Try sample link to import the sample dataset and see how it works. To import files from local network
Using the Import from local network toggle, you can perform dynamic file selection based on the regex. This can be used for getting new or incremental data from your local file system. Incremental fetch is a method used to import new files from a source after the previous sync. Zoho DataPrep helps you import incremental data from your local files using Zoho Databridge.
In DataPrep, you can incrementally import various file types, including CSV, TSV, JSON, XML, XLS, XLSX and TXT.
2. Choose an active Databridge and provide the following details:
Folder path : The folder path where you want to search for files. Eg. D:\DataPrep\Datasets
Include subfolders : You can select this checkbox if you want to include subfolders while searching for a file.
File pattern : The pattern used to match the file names in the specified location. This supports regex type matching. You can also use the pattern, ".*" to match any file in the path specified.
Note: The file pattern match is a simple regex type match. For example, to fetch files with names such as Sales_2022.csv,Sales_2023.csv, Sales_2024.csv , you can input the pattern Sales_.*
Similarly to fetch files such as PublicData1.csv , PublicData2.csv , PublicData3.csv , use Public.*
If you want to import a single file, then specify the pattern using the exact file name.
Eg: leads_jan_2022.*
Note: If this checkbox is unchecked then, only 1 sheet will be fetched at a time. 
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:
Create. Review. Publish.
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.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Import configuration for local files
You can import data from local files using Zoho Databridge. Look into the following sections to learn about the import configuration of each selection type. How to import data from local files without using Databridge? How to import data from local ...Import data from YugaByte
You can import data from the YugaByte database into Zoho DataPrep using Zoho Databridge. Click here to know about Zoho Databridge. Before looking into how to import data, let's take a look at the pre-requisites to connect to the Denodo database. ...Import data from local databases
You can import data from the following local databases into DataPrep using Zoho Databridge: MySQL MS SQL Server Oracle PostgreSQL Maria DB Pervasive SQL Sybase DB2 Exasol Sqlite Actian Vector Greenplum Denodo Progress OpenEdge YugabyteDB Microsoft ...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, ...Import data from Progress OpenEdge
You can import data from the Progress OpenEdge database into Zoho DataPrep using Zoho Databridge. Click here to know about Zoho Databridge. Before looking into how to import data, let's take a look at the pre-requisites to connect to the Progress ...