How to export data into excel file?

  • Profile Image
    Belmontptsa
    Asked on April 09, 2019 at 10:10 PM

    hello-


    once I am in my form builder, how can I export my data to excel?  I have used an external link that I googled (https://www.jotform.com/help/374-How-to-Export-All-of-Your-Data-at-Once) but it is not exporting all of my data in that downlaod.  I am cross checking with me emails after submission and all of the registrants are not on that form.  I am wondering if I am using the wrong way to export data.  


    Katie

  • Profile Image
    Richie_P
    Answered on April 10, 2019 at 12:44 AM

    To clarify, do you want to export all your submissions at once? The guide will let you download all your submissions into a Zip file.

    May we know if you have received an email notification with a link to the file?

    If you want to download your submissions as excel per form, you may use this guide:-How-to-Download-Form-Submissions-as-Excel-CSV-PDF

    Please give it a try and let us know how it goes.

  • Profile Image
    Belmontptsa
    Answered on April 10, 2019 at 10:22 AM
    Yes. I have been downloading the file and receiving through email. But for some reason all the participants data is not on the excel sheet. Many are but it seems like the ones who selected “check or cash payment” are not showing up. Would they be on another file?. I know because I’ve been getting emails after submission and then I check the download and only some of them are on the excel zip file.
    Yes I need all participants information on one spread sheet.
    Katie Fullenkamp
    Sent from my iPhone (please excuse typos)
    ...
  • Profile Image
    Richie_P
    Answered on April 10, 2019 at 11:35 AM

    All your submission data should be in your excel file.

    I have downloaded your submissions as excel and it seems all the submissions data are found in the excel file. Currently, you have 57 submissions and I was able to download all the data in your submission page.

    https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF

    May we know the submission ID or the name of the users that are missing in your excel file?

    Looking forward for your response.

  • Profile Image
    Belmontptsa
    Answered on April 10, 2019 at 02:43 PM
    Three submissions below are not on the excel file that I just again downloaded. It is the ones who have “pending payment” and are sending payment to school rather than PayPal. There are many more than these four.

    Katie Fullenkamp
    Sent from my iPhone (please excuse typos)
    ...
  • Profile Image
    Richie_P
    Answered on April 10, 2019 at 03:58 PM

    To clarify, are you referring to the incomplete Payments?

    Can you please share to us the name o email address of the submission that are not included in your excel files?

    Looking forward for your response.

  • Profile Image
    Belmontptsa
    Answered on April 10, 2019 at 06:43 PM
    There are probably at least 20 not included on the download. Is it because payment is pending? We will have pending payments for some time due to the nature of our event so is there another way to export everyone who has signed up regardless of their payment status?
    Katie Fullenkamp
    Sent from my iPhone (please excuse typos)
    ...
  • Profile Image
    Kevin_G
    Answered on April 10, 2019 at 08:22 PM

    Yes, the submissions you find under the "incomplete payments" section will not be downloaded on the Excel file, you must complete the submissions in order to have them showing on the submissions page and included on the report. 

    Try completing at least one payment and downloading your report. 

    Let us know how it goes.