how do I convert my data to Google Sheets

  • Profile Image
    ESL_Classes
    Asked on January 13, 2022 at 01:56 PM
  • Profile Image
    Sigit_W
    Answered on January 13, 2022 at 06:40 PM

    Hi,

    Thank you for reaching out to us.

    Regarding "how do I convert my data to Google Sheets"

    Setting up an integration with Google Sheets for your form is quick and easy. Just follow the steps below.

    1. Click on the Settings tab (at the top of the Form Builder) and then Integrations (from the menu on the left). Search and select the Google Sheets integration.
    2. Click Authenticate to connect your Google account. If you have already authenticated your account, you can select your Google account from the dropdown.
    3. Once you’ve connected your account, you can choose one of two options; create a new spreadsheet or use an existing spreadsheet.
    4. To create a new sheet, please enter names for your spreadsheet and worksheet, and then select the form questions that you want to use to create columns.
    5. To use an existing sheet, please select a spreadsheet from your Google account and enter a worksheet name, then select the form questions that you want to use to create columns.
    6. When you select Select All to send all form fields to Google Sheets, every form field you add to your form will automatically create a new column. Submission ID is selected by default and cannot be removed. However, it will be displayed as a hidden column in your spreadsheet. You’ll be able to show, hide, or remove it in the sheet.
    7. If you don’t want to send your existing submissions to this sheet, please click the checkbox to deselect this option. Then click Save to complete the integration.

    And that’s it! When you receive submissions to your form, they will instantly be sent to your spreadsheet. 

    You can read the complete guide with images here: https://www.jotform.com/help/228-how-to-integrate-forms-with-google-sheets/

    Please give it a try, and let us know if you need further assistance.