Creator Help

Create Application From Google Spreadsheets and Google Forms

You can create your online database application in Zoho Creator by importing data from Google Spreadsheets and Google Forms. The data submitted through Google Forms are stored in excel files. For example, the data submitted in the Google Form named "Tasks" is stored in excel format as shown in the screen-shot below:

Google Form

Google Spreadsheet

Now let us create an application in Zoho Creator by importing the Google spreadsheet.

1. Click on the Create New application button in your Zoho Creator Home page and select the Import File -> Google Docs option. Specify the Application Name in the Application Name text box. Click on the Browse From Google Docs option. The Google spreadsheets and Google Forms created in your Google Docs account will be listed in Import from Google list box. Select the file to be imported to Zoho Creator and click on Create button, as shown in the screen-shot below.

2. The Importing Data dialog will display the data in the following format, as shown in the screen-shot below.

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

3. Click Finish to create the application with data. The application "Zoho Tasks" is created in Zoho Creator with the "Zoho Tasks" form and the "Zoho Tasks form" view, as shown in the screen-shot given below.

Zoho Creator Tasks Form

Zoho Creator Tasks View