What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    can i have multiple form's submissions get exported in a google spreadsheet

    Asked by worldscen on October 17, 2014 at 04:53 PM

    So if I had a spreadsheet with multiple "sheets" ,each one was pulling submissions from a different form on my account? is there a way to do this?

     

    Page URL:
    http://www.yorku.ca/wrldscen/order.html

    Submissions multiple form different my account google spreadsheet multiple sheet importrange
  • Profile Image
    JotForm Support

    Answered by jonathan on October 17, 2014 at 07:21 PM

    Hi,

    The Google Spreadsheet integration can be used one jotform at a time. The integration is equivalent to one sheet in the spreadsheet. 

    So no. Unfortunately it is just one spreadsheet only. Although it contains multiple sheet, the output of the integration will only result to one sheet -- which you can give name to during the integration setup.

    You can assign a Folder name though. Which means you can collect all the spreadsheets into single folder.

    If you need to contain all the different sheet into single spreadsheet, you will need to do it manually using the Google spreadsheet application.

    That is by importing each of the sheets data from different spreadsheets into a single spreadsheet.

    There is an ImportRange function in Google spreadsheet that can do this.

    I found this article on the internet that described how to do the import range feature.

    Hope this help. Inform us if there is more we can help you with.

    Thanks!