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.
Long survey form breaks exel output at 250th columnAsked by Michael1986 on January 13, 2014 at 01:49 PM
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.
survey problem excel thanks tool
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.
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.
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.
Your support request has already been alocated in development, and deliberation is uderway.
We shall update you as soon as possible on this thread.
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.