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 create excel extracts with selection criteria?

    Asked by baldwin_peter on March 26, 2017 at 08:41 AM

    I have a form where the user can select one of 4 countries.  I would like to produce an excel sheet for each country and allow the country administrator to access just their own country and not see the other 3.  Is this possible?  If so can I email the excel sheet to the country administrator so they do not have to sign into Jotform each time?

    Thanks - Peter

  • Profile Image
    JotForm Support

    Answered by Kiran on March 26, 2017 at 11:51 AM

    Unfortunately, it is not possible to generate an excel sheet with the filtered data. When we export the data to Excel, it will automatically generate the complete submissions. You may need to separate the excel exported data and filter by country wise manually to send it to the users. 

    However, you may give a try using the visual report with the form submissions.

    https://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-Your-Form-Submissions

    The visual report allows selecting a filter so that the data on the report will be displayed as per the filter. Please take a look at the following guide that can help you with using Visual report filters.

    http://www.jotform.com/help/281-How-To-Use-Visual-Report-Filters

    You may generate separate reports for each country to share with the users. 

    Hope this information helps!