Google spread sheet backup

  • Profile Image
    Michael1986
    Asked on January 07, 2014 at 10:09 AM

     Google sheet presents message on the top that indicates that the maximal number of columns is 255. Since I have more than 255 columns is it possible to continue the inserting of data to the next sheet? Otherwise what can I do without spliting my form into two parts?

  • Profile Image
    KadeJM
    Answered on January 07, 2014 at 12:35 PM

    To my knowledge if I remember correctly we had a similar question about this as of awhile back. Unfortunately, From what I recall there really isn't a way to fully control that from our end which was due to the max limitation of data that can be sent to your spreadsheets for the columns according to google's api.

    However, Google has improved thier spreadsheets since then and it you can actually change this in your Drive Settings. I think that once you enable that you should be able to go beyond that limitation to my understanding according to the google info about the updated increase of that previous limitation. Try it without and then if the data doesnt exceed past after enabling it in your Settings then you may need to re-integrate after the change.