Can I extract form data to a spreadsheet?

  • tonycrowther
    Asked on November 17, 2016 at 7:31 AM

    I have a pub table booking form:  'George Reservation Time Slots' from which I would like to automatically extract three fields to a spreadsheet, 'first name' 'surname' and 'email address',  but I would like to add a tick box saying "remove this tick if you would NOT like to receive our newsletters - thus NOT automatically extracting the data from that form submission.  How can this be achieved?

  • Boris
    Replied on November 17, 2016 at 8:59 AM

    To answer your first question, yes, you can extract your form submissions into Excel. You can do this in several different ways:

    https://www.jotform.com/help/101-How-to-Create-an-Excel-Report

    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

    For the second part, about filtering these submissions to only those that have left the "remove this tick if you would NOT like to receive our newsletters" checkbox ticked, you can simply filter for it on your submissions page:

    https://www.jotform.com/help/269-How-to-View-Form-Submissions

    Simply enter the text from that Check Box option into the Search bar of your submissions, and it will display only those submissions where that text was selected (1):

    Can I extract form data to a spreadsheet? Image 1 Screenshot 20

    When your submissions are filtered, simply click on the Excel button and it will export only those search results / filtered submissions into your Excel file.

    Please try it our and let us know should you need further assistance.