hide or show editor

WebTools

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