JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
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?
To answer your first question, yes, you can extract your form submissions into Excel. You can do this in several different ways:
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:
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.