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

    Filtering submissions in order to get the email fields only

    Asked by andreasath on August 21, 2016 at 12:47 PM

    I have a field in my form which asks for an email. However, I want to email everyone who has submitted the form, except for one or two of them. I am not referring to an automated email. I want to send these emails 1 or 2 months after they submit the answers to the form. Is there any way I can download an excel with simply the name and the email and then maybe upload that information to MailChimp?

    emails send emails filter submissions excel email field
  • Profile Image
    JotForm Support

    Answered by Jan on August 21, 2016 at 03:00 PM

    Yes, it is possible to filter the submissions by removing the other fields and leaving the email field only. After filtering it, you can then export it in an Excel file. Here's a a guide:

    1. In My Forms, select the form and then click the "Submissions" button.

    2. On the Submissions page, click the "Properties" icon and un-check all the fields except for the email field. Click the "Properties" icon again when you're done.

    3. After that, click the "Excel" button at the Grid Report.

    Hope that helps. Thank you.

  • Profile Image

    Answered by andreasath on August 21, 2016 at 03:01 PM

    That is perfect, thank you so much!

  • Profile Image
    JotForm Support

    Answered by Jan on August 21, 2016 at 03:33 PM

    Glad to hear that. If you need any help, we are here to assist you. Thank you.