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, 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.*
Parse file as : Choose the required extension to parse the file. If your file format is not a commonly used one, you can use this option to parse the file into one of the following formats before importing the data into a readable format. The available formats are CSV, TSV, JSON, XML, and TXT.
Note: If this checkbox is unchecked then, only 1 file will be fetched at a time.3. Click the Import button.
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:
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
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Import configuration for local files
You can import data from local files using simple selection or advanced selection. Look into the following sections to learn about the import configuration of each selection type. How to import data from local files using simple selection? How to ...Import data from URLs
You can enter the URL to a CSV, TSV, JSON, HTML, XLS, XLSX or XML file. DataPrep also supports URL imports that require authentication. To import files from URLs 1. Create a pipeline or open an existing pipeline from the Home Page, Pipelines tab or ...Import data from FTP servers
You can import files from FTP servers using the following steps. To import data using an FTP connection 1. Create a pipeline or open an existing pipeline from the Home Page, Pipelines tab or Workspaces tab and click the Add data option. You can also ...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 options
DataPrep offers a wide range of import options. Your data can be imported from BI tools, cloud storage services, cloud databases. To import your data, 1. Create a pipeline or open an existing pipeline from the Home Page, Pipelines tab or Workspaces ...