Welcome! Sign in to access your account. New user?

The Official Mister Poll Forum


Posted by gww on 2007-12-26 20:47:57

Is there any limit as far as how many questions a poll can have? Or the number of possible answers per question? Or for the entire poll. I downloaded results, and it appeared to cut off at a certain point and did not show the entire poll. Everything else in the new version is great.

Posted by Mister Poll on 2007-12-28 03:25:31

There is no limit to the number of questions a poll can have or the number of choices a question can have. You may be be running into a limitation of Microsoft Excel when viewing the exported results file, though. Most versions of Excel can only support a maximum of 256 columns in a spreadsheet.

When you export the results of your poll, the number of columns that are used depends on your question types. Single-selection multiple-choice questions (where the voter can select only one choice) use only one column per question in the results file. If your poll used only that question type, you could fit 256 questions within Excel's column limit. However, fill-in-the-blank and multi-select multiple choice questions can take up more than one column per question. Those are the question types that will get you closer to hitting the 256-column limit in a large poll.

All of the results data does get written to the Mister Poll results file, though. So if you use a spreadsheet program that can handle more than 256 columns, you will be able to see all of the data. The newest versions of Microsoft Excel can support up to 16,384 columns. You can download a 60-day trial version here:


Corel's Quattro Pro spreadsheet supports over 18,000 columns. It appears to be available only as a part of WordPerfect Office. They also have a downloadable trial.

Unfortunately, Google Spreadsheets also currently has a 256 column limit. Hopefully they will expand that in the future. It would be a great way to view result data online for free.

Posted by gww on 2007-12-28 13:31:43

Checked spreadseet version and found 256 limit. That you greatly for your time and work keeping this site going :)