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 extract form data to a spreadsheet?

    Asked by tonycrowther on November 17, 2016 at 07: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?

    Page URL:
    http://georgeatburpham.co.uk/reservations.html

    form data export to Excel
  • Profile Image
    JotForm Support

    Answered by Boris on November 17, 2016 at 08: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):

    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.