Export to Excel not working for large data set

  • Profile Image
    dfresonke
    Asked on September 29, 2011 at 08:30 AM

    Our recent Facebook promotion had a huge turnout.  We received 17,000 responses before shutting it down.  We have tried over a dozen times to export the data to Excel and the export never completes, even after running all night twice.

    The account is dfresonke.   We only have the one form.

     

  • Profile Image
    mythryll
    Answered on September 29, 2011 at 06:28 PM

    Hi dfresonke,

    Have you tried the CSV format? CSV format is significantly smaller than other file formats. A 1kb CSV file is equivalent to approximately 10kb in excel format both having the same content.

    Once you have successfully downloaded it, you can then open and save it using Excel.

    I hope this helps.

    Myth

  • Profile Image
    allanftd
    Answered on September 30, 2011 at 08:18 AM

    Hi dfresonke,

    In addition to what Myth has shared, you may also use the search box below the grid  in order to look for a particular entry and export it into csv:

    If you can still recall when a particular entry was submitted, you can also filter by a particular submission date, click the gear icon and select Custom Time Frame in the Time Frame dropdown menu as shown below:

    When you're done filtering by date or city, click Download as CSV. Please try it and let us know how it goes.

    Let us know if you need further assistance. Thank you for using JotForm!

    JOTFORM SUPPORT 

  • Profile Image
    juliegoodnight
    Answered on October 03, 2011 at 11:59 AM

    I'm having the same problem. Won't download the Excel or the CSV for 1700 entries...

  • Profile Image
    juliegoodnight
    Answered on October 03, 2011 at 12:04 PM

    WHen I clicked on the cog and deselected to hide the empty fields it suddenly let me download the csv.

  • Profile Image
    aytekin
    Answered on October 04, 2011 at 04:12 AM

    That's a very interesting fix. :) We will look into that.