Zoho Sheet

Zoho Sheet

Zoho Survey's integration with Zoho Sheet helps push your responses from your survey into a spreadsheet as and when your respondents submit their responses. You can map the survey responses into a new spreadsheet or to a new sheet in an existing spreadsheet.

How do I...

How do I integrate my survey with Zoho Sheet?

  1. Select the Hub tab.

    Hub

  2. Select the Integrations section.

    Integrations

  3. Click Integrate in the Zoho Sheet section. Make sure you have an account in Zoho Survey and Zoho Docs so you can configure the sync settings. 

    zoho-sheet-integration

  4. Choose an integration option: 

    Zoho Survey integration with Zoho Sheet

    • Select Create a new spreadsheet and type in a name for the spreadsheet. The name of the survey will be displayed by default. You can either use the name of the survey or type in a new one.
    • Select Choose an existing spreadsheet to push responses into an existing spreadsheet. Then enter a keyword in the Search bar to find the spreadsheet that you're looking for.
  1. Select a survey to use.
  2. Click Save.

 

How do I view the responses on a spreadsheet?

  1. Click View Sheet after integrating your survey with Zoho Sheet.

    zoho-sheet-view-sheet

  1. Log on to your Zoho Docs account and find the spreadsheet with the record of responses. If you change the alignment or order of questions in your survey, the changes won't be reflected on the sheet. If you add or delete a row/column in the sheet, the alignment of collected responses will also vary.

 

How do I remove the integration with Zoho Sheet?

  1. Select the Hub tab.

    Hub

  2. Select the Integrations section.

    Integrations

  3. Click Remove Integration in the Zoho Sheet section.

    zoho-sheet-remove-integration

  4. Click Remove.

    zoho-sheet-remove-confirm


    • Related Articles

    • Import spreadsheets to Zoho Sheet

      You can import a file from two sources - one, local file from your system or from the web by using the link (URL). You can also choose to import from any other cloud storage such as Google Drive, Drop Box, Box Drive and One Drive.  To import a ...

    • Create a new spreadsheet in Zoho Sheet

      To create a new spreadsheet:   Click on the File menu. From the drop down, choose New Spreadsheet. Alternatively, from the Zoho Sheet Listing Page, click on the "New Spreadsheet" on the right top. ​If you're trying to create a new spreadsheet from ...

    • Features that can be customized in Zoho Sheet Editor

      Office Integrator API also allows you to customize the below features in Zoho Sheet Editor;   Set Display Language. Add delimiters to CSV & TSV file formats (For example: delimiter=;) Possible values: '|' , ';' , '^' , '~' , ' , ' , '\t' Set username ...

    • What are the functions available in Zoho Sheet?

      A function/formula begins with an equal to (=) sign and is followed by syntax that lets you do the required calculations. Zoho Sheet supports more than 350 default functions click here to view them.

    • What does the Zoho Sheet View option do?

      The Zoho Sheet View option lists records of a module in Zoho Sheet. Using this sheet view, you can view all the records and update them. You can make necessary changes to the records and save the sheet. On saving, the records are updated in your CRM ...