Is there a limit to the columns on google spreadheets?

  • radanza
    Asked on May 28, 2014 at 3: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.

    Jotform Thread 384302 Screenshot
  • Elton Support Team Lead
    Replied on May 28, 2014 at 5: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!

  • radanza
    Replied on May 28, 2014 at 5: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).

  • jonathan
    Replied on May 28, 2014 at 8: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.