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

    Long survey form breaks exel output at 250th column

    Asked by Michael1986 on January 13, 2014 at 01:49 PM

    Dear supporter,

     

    In my form the entring into the fields in the excel file is stoped after it reaches 254 fields. Can you please solve this problem? Otherwise it makes your tool useless for a long surveys.

     

    Many thanks

    Page URL:
    http://form.jotformpro.com/form/33522254284956

    survey problem excel thanks tool
  • Profile Image
    JotForm Support

    Answered by TitusN on January 13, 2014 at 03:11 PM

    Hello, 

    Thank you for reporting this.

    I was able to reproduce the issue: Form with more than 250 questions breaks Excel column output at the 250th column. 

    We have escalated the issue to development for deliberation, and we shall update this thread.

    Thank you for your patience in resolving this.                                      

  • Profile Image
    JotForm Support

    Answered by TitusN on January 13, 2014 at 03:18 PM

    In the meantime, please try integrating with Google spreadsheet: http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Please let us know if this helps. 

  • Profile Image

    Answered by Michael1986 on January 14, 2014 at 08:18 AM

    Dear TitusN

    The integration with Google spreadsheet works even worse; in addition to stoping inserting the fields in the same place, for some reason, for some questions (multichoise) there is a time stamp instead of inserted answer.

    Please let me know if you can solve this problem as soon as possible.

     

    Many thanks

     

  • Profile Image
    JotForm Support

    Answered by TitusN on January 14, 2014 at 08:24 AM

    Our Apologies. 

    Your support request has already been alocated in development, and deliberation is uderway. 

    We shall update you as soon as possible on this thread. 

  • Profile Image
    JotForm Support

    Answered by liyam on January 30, 2014 at 11:41 PM

    We apologize for this delayed response, Michael1986.

    Have you tried downloading via CSV instead?  The problem with MS Excel is that there is a limit of up to 250 columns in it.  Beyond it, everything is cut off.  

    Please let us know if you have further questions.

    Thanks.