Importing Data into an Existing Table | Zoho Analytics On-Premise

Importing Data into an Existing Table


You can easily import data stored in local drives, web URLs, or cloud storages/drives in various file formats into existing tables in Zoho Analytics. This allows you to update and modify the records in existing tables in a workspace. You could also copy the required data and paste it into Zoho Analytics, and import into the required table. 

We will discuss the following sections in this documentation:

Importing data

The process of importing data into an existing table in Zoho Analytics is similar to steps followed while importing data to create a new table.

Import data from files and feeds

You can import data stored in local drives in various tabular formats into existing tables in Zoho Analytics with ease. To learn more about importing data from files, and the various file types that are supported, refer this documentation.  

You can also import data stored in web URLs into existing tables in Zoho Analytics with ease. To learn more about importing data from web URLs, and the various file types that are supported, refer this documentation.  

Import data from cloud storage

Zoho Analytics allows you to import varied data stored in different cloud drives/storages like Google Drive, Dropbox, OneDrive, etc., into existing tables with ease. To learn more about importing data from cloud storages/drives, refer this documentation.

Import settings

You can invoke the Import Wizard by clicking Import > Import into Existing Table option available at the top right corner of the table.

The following options are available:

  • How do you want to Import?: Choose how the data need to be added in the table using the drop-down list. The available options are:

    • Add records at the end: Use this option to append imported records to the end of the table.

    • Delete existing records and add: Use this option to delete entire records in Zoho Analytics table and add the new records into the table.

    • Add records and replace if already exists: Use this option to update the already existing records in the table with the new values and append the new records at the end of the table.

    • Add records, replace existing and delete missing record: Use this option to update the already existing records with the new values, append new records in the file to the end of the table and delete records that are not available in the file but present only in the table.

Note: When the Add records and replace if already exists or the Add records, replace existing and delete missing record option is selected, it is mandatory to specify matching columns. You can choose one or more columns as matching columns. Zoho Analytics will use the values in these columns as the key to match the existing records with the new records being imported. Hence the matching column(s) combination should uniquely identify each record in the table. Once a match is identified, then Zoho Analytics will update that existing record in the table with the new values present in the file being Imported. In case the specified matching column does not identify unique records, then all records will be appended at the end of the table.

  • File Type/Cloud Storage Type: Choose the type of file or cloud storage you wanted to import.

  • Data Location: Choose the data location. In case of choosing Web as data location, it will provide the following options. Choose the appropriate option and provide the full path to the URL in the field provided.

    • URL: Choose this to import data from a publicly accessible URL.

    • URL With Authentication: Choose this to import data from URL with basic authentication. On choosing this, you need to provide username and password to access data from the URL.

The remaining settings are similar to those present in importing data to create a new table. To learn more, refer this documentation


      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


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


                  Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                  BOOK A SESSION





                              Quick Links Workflow Automation Data Collection
                              Web Forms Enterprise Begin Data Collection
                              Interactive Forms Workplace Data Collection App
                              CRM Forms Customer Service Accessible Forms
                              Digital Forms Marketing Forms for Small Business
                              HTML Forms Education Forms for Enterprise
                              Contact Forms E-commerce Forms for any business
                              Lead Generation Forms Healthcare Forms for Startups
                              Wordpress Forms Customer onboarding Order Forms for Small Business
                              No Code Forms Construction RSVP tool for holidays
                              Free Forms Travel
                              Prefill Forms Non-Profit

                              Intake Forms Legal
                              Mobile App
                              Form Designer HR
                              Mobile Forms
                              Card Forms Food Offline Forms
                              Assign Forms Photography
                              Mobile Forms Features
                              Translate Forms Real Estate Kiosk in Mobile Forms
                              Electronic Forms Banking 
                              Notification Emails for Forms Alternatives Security & Compliance
                              Holiday Forms Google Forms alternative  GDPR
                              Form to PDF Jotform alternative HIPAA Forms
                              Email Forms
                              Encrypted Forms
                              Embeddable Forms
                              Secure Forms
                              Drag & drop form builder
                              WCAG

                                      Create. Review. Publish.

                                      Write, edit, collaborate on, and publish documents to different content management platforms.

                                      Get Started Now




                                                        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.




                                                            Manage your brands on social media


                                                              • Desk Community Learning Series


                                                              • Digest


                                                              • Functions


                                                              • Meetups


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner


                                                              • Word of the Day


                                                              • Ask the Experts


                                                                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 TeamInbox 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

                                                                                                                        • Importing data from MariaDB

                                                                                                                          If you have your data stored in MariaDB local database, you can easily import the data into Zoho Analytics or connect live with the MariaDB for advanced reporting and analysis.  Data Import: Data from your database will be imported and stored in Zoho ...
                                                                                                                        • Import data from files

                                                                                                                          If you have data stored in local drives in tabular file formats such as CSV, Excel, JSON, etc., you can easily import them into Zoho Analytics. Zoho Analytics offers easy import and copy-paste options of such data to jump start your reporting and ...
                                                                                                                        • Import data from Feeds

                                                                                                                          If you have data stored in web URLs in tabular file formats such as CSV, Excel, JSON, etc., you can easily import them into Zoho Analytics. Zoho Analytics offers easy import and copy-paste options of such data to jump start your reporting and ...
                                                                                                                        • Import data from PostgreSQL

                                                                                                                          If you have your data stored in PostgreSQL local database, then you can easily import your data into Zoho Analytics for reporting & analysis.  Data Import 1. How do I import data from the PostgreSQL local database? 2. How can I edit the setup? You ...
                                                                                                                        • Import data from MongoDB

                                                                                                                          If you have your data stored in MongoDB, then you can easily import your data into Zoho Analytics for reporting & analysis.  Data Import 1. How do I import data from the MongoDB? 2. How can I edit the setup? You can edit the import setup anytime ...
                                                                                                                          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