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

    Export to Excel not working for large data set

    Asked by dfresonke 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.

     

    Page URL:
    www.facebook.com/divinetimes

  • Profile Image

    Answered by mythryll 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

    Answered by allanftd 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

    Answered by juliegoodnight 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

    Answered by juliegoodnight 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
    JotForm Founder

    Answered by aytekin on October 04, 2011 at 04:12 AM

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