By importing data

Table of Contents  [ Hide]

Overview
Create new application by pasting data from an XLS file
Create new application by importing data from XLS files

Overview

You can create a new application via import (i.e convert your .xls/.csv /.tsv data into a new Zoho Creator application) or import data to your existing Zoho Creator application. To import data to an existing application refer the topic Import and Export Data. 

You can turn your excel data into a Zoho Creator application in two ways:

• Copy/Paste Data from the XLS file
• Import Data from the XLS files by specifying the file name

Comma separated values (.csv) or Tab seperated values (.tsv) stored in other file formats can also be used to create your application with data. The created application will be directly displayed in Live mode with data.

Create new application by pasting data from an XLS file

1. Select the Import XLS icon from the Create New Application dialog.
2. Specify the Application Name and select the Choose Type as Write/Paste data.
   
3. Copy the data from your .xls file or from other file formats that store comma separated values or Tab separated values.
4.  Paste the data copied from your .xls/.csv/.tsv file.
5. If the data contains a date field, select the required date format from the list of supported date formats.
6. Select the Time Zone for the application from the list of time zones.
7. Click on Create Now to import the data.
   
   
   
   
8. The "Importing Data" dialog will display the data in the following format:
   • The default Field Type is displayed based on the type of data pasted for each column. If a field type is not correct, select the appropriate field type from the drop-down list..
   • The data in the first row will be displayed as the default Label Name for each column. If the option Consider first row as Label Names is unchecked, the Label Name will be left blank. You can type a new name in the Label Name box or modify the displayed names.
   • Click Finish to create the application with the form data.
     
     
     
   • The created application with form and view will be directly displayed in Access mode.
     
     
     

Create new application by importing data from XLS files

To create an application by importing data from an XLS file,

1. Select the Import XLS icon from the Create New Application dialog.
2. Specify the Application Name and select the Choose Type as Import data.
3. If the data contains a date field, select the required date format from the list of supported date formats.
4. Select the Time Zone for the application from the list of time zones.
5. Click on Create Now to import the data from the specified file.
   
   
   
   
6. The "Importing Data" dialog will display the data from the excel file. Refer the step 8  specified in Copy-Paste Data section, to create the application.