hide or show editor


Help and Information pages

Web Services Survey and Form Builder FAQ

Entering content area for Web Services Survey and Form Builder FAQ

blog posts

  • Excel reports: showing all questions/answers


    Microsoft Excel only supports 256 columns in the spreadsheet.  So if your Form or Survey has more possible answers than 256 it will not be possible to display it in Excel.

    Options for displaying all of your data include:

    1. When you run your report, try checking the "single result" checkbox next to your radio or pulldown question.  Since radios and pulldowns only have one possible answer we can then put the value into one cell, rather than 0's or 1's that require a cell per answer.
    2. You can also choose to run more than one report.  Meaning choose the first half of the questions for the first report and the second half for the second report.
    3. Save the results to your computer and choose a different analytical software to load your them into.

additional blog information