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.

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