5

I read on Google Docs, Sheets, and Slides size limits that spreadsheets have a maximum of columns per sheet.

Shall I conclude that the maximum of fields a Google Form can contain is 255 (since one column is reserved for the timestamp)?

1

Incorrect. The current version of Google Forms has an independent form responses repository. Sending form responses to Google Sheets is optional.

Form responses could be downloaded as CSV from the Google Forms. Also they could be retrieved by using Google Apps Script.

It's worth to mention that Google hasn't disclosed Google Forms limits but there are reports of forms having a large number of questions (+300) that can't be responded.

The practical limit could be affected the type of questions if the form loads all the questions on a single page or if it uses sections to split questions into several pages.

Related

| improve this answer | |
4

Correct - Google Forms utilizes Google Spreadsheets to store their data, so you are restricted to the limits imposed on Spreadsheets.

EDIT:

As Jacob pointed out, these limits only apply to old Google Spreadsheets. All limits have been removed in the new version.

All spreadsheet limits mentioned above have been removed in the new version of Google Sheets. The new version of Google Sheets should support 2 million cells of data, though please note that extremely large spreadsheets may have slower performance. Learn more about switching to the new version of Google Sheets.

Google Help Article

| improve this answer | |
  • 4
    Technically you are correct, but the references Franck added are based on the old Google Spreadsheets. With the new Sheets, restrictions are based on the number of cells, being 2 million. You should be able to add more than 255 columns, as long as you are below the 2m. – Jacob Jan Tuinstra Jan 28 '15 at 13:05
  • 3
    Good catch - updated my answer. – codingbadger Jan 28 '15 at 13:15
0

There is a practical limit to how long a section can be, I use 50 questions max. There is also a maximum runtime for a script and so the total questions you can create using Google Apps Script is less than 500 questions. Beyond that length the form page simply won't respond in time and Google will timeout the request before finishing.

Google may allow you to create any size form, but with Apps Script it will not function beyond a few hundred questions.

| improve this answer | |
  • Have you tried to use sections in order to limit the number of questions been loaded? – Rubén Mar 6 at 19:27
  • @Rubén Do I just add a section header to create a new section? – rjurney Mar 9 at 16:25
  • The terms could vary depending on the English variant that is being used. On the one that I use It's just "section" not "section header" (in my case there is a form element type named Title) – Rubén Mar 9 at 16:32
  • @Rubén you just create a section header and it creates a section. That is the API. – rjurney Mar 11 at 17:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.