How to import data from FTP servers?

Import data from FTP servers

You can import files from FTP servers using the following steps. 

To import data using an FTP connection

1. Select the FTP option from Choose a data source box.



2. Configure FTP connection to connect to the server and fetch the file. Enter the file path in the FTP server.

3. Select the FTP server type.

4. Enter the FTP server host. You can also enter the IP address or the FQDN (Fully Qualified Domain Name) of the server.

5. Enter the username and password if authentication is required.

Note: The connection configuration will be saved for importing data in the future. Credentials are securely encrypted and stored. 

6. Give a name to your connection in the Connection name text box.



7. Click Import to upload data into Zoho DataPrep from the FTP server. 

8. Once you have completed importing data, you can choose to schedule this import or start preparing your data right away.

To edit the FTP connection

DataPrep saves your data connections to avoid the hassle of keying in the credentials every time you need to connect to a data source or destination. You can always edit the saved data connection and update them with new parameters or credentials using the Edit connection option. 

1. Click Saved data connections from the Choose a data source box while creating a new dataset. 



2. You can manage your saved data connections right from the data import screen. Click the ellipsis (3 dots) icon to share, edit, view the connection overview, or remove the connection. 



3. Click the Edit connection option to update the saved connection with new parameters or credentials. 




    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 CRM Training
      Redefine the way you work
      with Zoho Workplace

        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 CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Get started with Zoho Sign

            in a few quick steps!

            Download Help Guide





                      Still can't find what you're looking for?

                      Write to us:  support@zohoforms.com


                            




                          

                          Zoho Marketing Automation

                            Zoho Sheet Resources

                             




                                Zoho Forms Resources


                                  Secure your business
                                  communication with Zoho Mail


                                  Mail on the move with
                                  Zoho Mail mobile application

                                    Stay on top of your schedule
                                    at all times


                                    Carry your calendar with you
                                    Anytime, anywhere




                                          Zoho Sign Resources

                                            Sign, Paperless!

                                            Sign and send business documents on the go!

                                            Get Started Now


                                                Zoho SalesIQ Resources



                                                    Zoho TeamInbox Resources



                                                            Zoho DataPrep Resources



                                                              Zoho DataPrep Demo

                                                              Get a personalized demo or POC

                                                              REGISTER NOW


                                                                Design. Discuss. Deliver.

                                                                Create visually engaging stories with Zoho Show.

                                                                Get Started Now











                                                                                      • Related Articles

                                                                                      • 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. Click URL  from the Choose a data source box while creating a new dataset.  2. Enter ...
                                                                                      • Import data using saved data connections

                                                                                        DataPrep saves your data connections to avoid hassles in keying them often. To access your saved data connections  1. Click Saved data connections from the Choose a data source box while creating a new dataset.  2. Manage your saved data connections ...
                                                                                      • Import data from a local filesystem

                                                                                        In DataPrep, you can import various file types, including CSV, TSV, JSON, HTML, XLS, XLSX and XML.   Note: DataPrep also supports files without any extension or files in plain text format. However, binary files cannot be parsed during import; users ...
                                                                                      • Import data from Zoho CRM

                                                                                        Zoho DataPrep allows you to seamlessly bring in your sales data from Zoho CRM using the Zoho CRM connector. Using the connector, you can import your sales data from CRM to perform data cleanup, data migration, and data backup in more than one way.  ...
                                                                                      • Import data from cloud databases

                                                                                        You can import data from the following cloud databases:  Amazon RDS - MySQL Amazon RDS - MS SQL Server Amazon RDS - Oracle Amazon RDS - PostgreSQL Amazon RDS - Maria DB Amazon RDS - Amazon Aurora MySQL Amazon RDS - Amazon Aurora PostgreSQL Amazon ...
                                                                                      Wherever you are is as good as
                                                                                      your workplace

                                                                                        Resources

                                                                                        Videos

                                                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                        eBooks

                                                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                        Webinars

                                                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                        CRM Tips

                                                                                        Make the most of Zoho CRM with these useful tips.



                                                                                          Zoho Show Resources