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


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

                          Form Designer HR

                          Card Forms Food
                          Assign Forms Photography

                          Translate Forms Real Estate
                          Electronic Forms

                          Notification Emails for Forms Alternatives
                          Holiday Forms Google Forms alternative 
                          Form to PDF Jotform alternative





                                            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

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


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

                                                                                                              • 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