Creator Help

Import Data From Google Spreadsheet

You can import the XLS/CSV/TSV files from the Google Docs and create a Form in Zoho Creator. Follow these steps to import data from Google spreadsheet, to your existing application.

  1. Access the application and select the required Form or Report.
  2. Select the Settings icon -> Import Data option from the Form/Report header as shown in the screen-shot below.
  3. The Import Data dialog will be displayed. Select the File Type as Excel, Data Location as Google Docs and choose the excel file to be imported. Click Next to go the next screen of the Import Data process.
  4. The next screen will display the data in the following format:
    • The data in the first row will be displayed as the default Label Name for each column. If the option First row of data is field label names is checked as "Yes", the first row values will be displayed as label names.
    • Select the appropriate field for each column from the Select a Field list-box displayed below the label names.
    • Select the appropriate option from the On Import Errors list box.
      • Skip corresponding rows: If there is any conflict found in any of the row values, Zoho Creator will skip the corresponding rows. Eg. If a row containing an email field type has text, then ZC will not import that row alone and the rest of the rows will be imported.
      • Set empty values for the column: If there is any conflict found in any of the column values, Zoho Creator will set empty(NULL) values for the corresponding columns.. Eg : If a integer column has text, then ZC will not import that column value alone and the rest of the columns of that particular row will be imported.
      • Don't import the data : If there is any error in the data to be imported, the entire data will not be imported.
  5. Click Import Data to update the existing report with new records.

Top