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

    How to transfer my data to an excel file?

    Asked by 200clubmarketing on November 16, 2016 at 05:34 AM

    Good morning,

    I am in the process of completing a scholarship application form.  Upon completion of the form, can the responses be populated in an excel document?  Our goal is to be able to extract data for all applicants into a simple sheet for us to view them all.  We are trying to eliminate manually copying and pasting data.

    Also,

    is there a way to set up an alert to designated email addresses when a form is submitted?

    Thank you!

    Page URL:
    https://200clubofatlanticandcapemaycountiesdotorg.wordpress.com/

    populated completion how application form excel responses document
  • Profile Image
    JotForm Support

    Answered by emily on November 16, 2016 at 06:19 AM

    You can integrate your form with Google Spreadsheet.

    I created an example form with the fields you can see below. To integrate your form with Google Spreadsheet, kindly click on Integrations button.

     

     

    Choose Google Spreadsheet and approve authentication. 

     

    When you make submissions, they will be shown in the spreadsheet. You are able to see the submission date, the fields in the form, IP address and submission ID.

     

     

    For further information please have a look at the user guide below.

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet 

    I moved your second question to a new thread. Your question will be answered there.

    https://www.jotform.com/answers/991224 

    If you have any question, please let us know. 

    Thanks.

     

     

     

  • Profile Image
    JotForm Support

    Answered by emily on November 17, 2016 at 07:58 AM

    In addition to the solution above, you can download your submissions as excel files. However, since the fields will not be automatically updated after each submission, you will need to download it after each submission.

     

    Please have a look at the user guides below for further information.

    https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel 

    https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF 

     

    Thanks.