What is JotForm?
JotForm is a freeonline 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.

Why do you not want to answer this thread?(Your answer will be sent to Jeanette and Aytekin)

How to filter submission data and export to excel?

Asked by
Charlie
on April 28, 2015 at 09:15 PM

I love using JotForms - the forms are excellent and I have set up my students using it daily to log the management of our sheep flock. That side of it is working really well.

Our problem is in extracting reports and exporting them to Excel. So far we have access to submissions in four ways but each has frustrating deficiencies:

1 Submissions view - it is possible to filter and export to Excel here but the interface is frustratingly clunky. Both resizing columns and hiding columns is a waste of time as it reverts to the original layout as soon as any other functions are used. Can this be addressed?

2 Grid Report - a much more user friendly grid layout with most of the functionality of submission view except no Excel export! Ahhhh!!

3 Excel Report - no filtering!! We don't want all the submissions exported every time.

4 Export to Google Spreadsheets - very messy to set up in such a way that student scan easily use it.

Looking through the Forum, there are many many requests for the ability to either export the Grid Report data or be able to filter the data for an Excel report. Basically the functionality of these two needs to be brought together.

Please, please move this request up your priority list!!!

Are there any other options that I have missed? Any other suggestions? I have only been using JotForm for few weeks and do love it except for this problem.

If I understand your requirement correctly, you want to filter the submission and then export it to excel. Is that correct?

Can you please let me know your requirement a bit more in detail? How you want to filter he submissions? Do you search for a text to filter submissions? You can do that form your form's submission page as well. You need to just filter the submissions, select them and then export them to excel. Please check the screenshot below:

If this is not what you wanted to achieve, do get back to us with your requirement a bit more in detail and we will send a feature request to our back end team.

If you however want to just permanently limit the fields that will be shown, there is a different way to do it in the Submissions Panel, and you could share the access to submissions themselves instead.