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

    Is there a limit to the columns on google spreadheets?

    Asked by radanza on May 28, 2014 at 03:02 PM

    I have a super long grant application, some of the fields are not making it into the google spreadsheet. I have 7 sections but the spreadsheet ends somwhere in the middle of section 5.

    Page URL:
    http://form.jotform.us/form/41337103649149

    Screenshot
    sections section spreadsheet google spreadsheet google integration column limits
  • Profile Image
    JotForm Support

    Answered by EltonCris on May 28, 2014 at 05:07 PM

    Hi,

    Yes, and that's 256 columns per sheet. More info: https://support.google.com/drive/answer/37603?hl=en

    You might have probably reached the limit and there's nothing we can do about that if that's the case. How about using Jotform's HTML Table or Grid Listing Report? This might be of help.

    Thanks!

  • Profile Image

    Answered by radanza on May 28, 2014 at 05:29 PM

    Actually this isn't it, because I can export manually. I suspect that it has to do with similar column names(Another post commented that this caused data not to populate to google forms).

  • Profile Image
    JotForm Support

    Answered by jonathan on May 28, 2014 at 08:22 PM

    Hi,

     I suspect that it has to do with similar column names(Another post commented that this caused data not to populate to google forms).

    That is correct. If form field have same label names, chances are it will fail to transfer into the google spreadsheet on integration.

    Since the column name of the generated spreadsheet uses the field labels/names, similarly name fields will overwrite each other in the spreadsheet -- making it appear that only the last column name is working.

    To correct this, do not use same field labels/names in the form that is going to be integrated to Google spreadsheet.

    Thank you.