Is there a limit to the columns on google spreadheets?

  • Profile Image
    radanza
    Asked 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.

  • Profile Image
    EltonCris
    Answered 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
    radanza
    Answered 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
    jonathan
    Answered 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.