How to convert Google response sheet to JotForm?

  • john.bello
    Asked on July 14, 2020 at 11:05 AM

    Is there a way to take a Google response sheet; from a form originally made with Google Forms; and upload it or convert it to JotForm?  The reason is I love the JotForm features and tools such as the ability to create Reports using the JotForm Reporting tool which I don't have in Google. So if possible I'd like to move some of my existing Google response sheets to JotForm for that purpose. Thanks for any help.

  • Niko_N
    Replied on July 14, 2020 at 1:27 PM

    Greetings,

    Yes, it is possible to achieve your requirement by taking advantage of our Import Google Forms app:

    https://www.jotform.com/integrations/import-google-forms

    Using this app, you will be able to import your Google Form and corresponding submissions data into your new JotForm account.


    However, if you only have a Google spreadsheet file of your form submissions, you can use this option below:

    You can use our Import Data app in that case:

    https://www.jotform.com/integrations/import-data

    You need to export your Google spreadsheet data in excel or CSV file and then import it in form through import data app.

    You may like to take a look at the following guide which should help you: https://www.jotform.com/help/308-Import-App-Easily-Import-Your-Excel-or-CSV-Data-into-JotForm 

    Hope this helps,

    Please let us know if you have any further questions.

    Thank you!

  • john.bello
    Replied on July 14, 2020 at 8:28 PM
    That's great however I don't want to convert ALL my Google forms to
    JotForm. That would be hundreds and hundreds of old Google forms. I only
    want to convert one Google form at this time. Is there a way for the *Import
    Google Forms* app to do only a single form? I'm not seeing a way to import
    a single google form. It just immediately starts to import all of them.
    ...
  • Kiran Support Team Lead
    Replied on July 15, 2020 at 12:53 AM

    You may import one form from your Google Forms to JotForm by using the Google Forms import app. Once you authenticate the Google account, you should be able to select the forms required to import to JotForm. Please see the guide below:

    159478876820200715 102053 Screenshot 10

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

  • john.bello
    Replied on July 16, 2020 at 7:55 PM

    Yes that worked thanks. I did not let the initial import screen run all the way before canceling it because it is unclear and appears that it is trying to actually convert all the Google forms immediately. But as you pointed out it is only importing a list of all your forms from which you then choose which to convert. I think the language on the initial import screen should be clear that it is only building the list of form file names and not actually converting them. Thanks again!