Survey Response Summary

Summarize a multi-select survey question from CSV, TSV or Excel. Review who counts, how blanks are handled and which percentage base you use, then save an editable Excel summary.

Count people and selections with an explicit base

Survey exports often put several choices in one cell. This tool counts each choice once per respondent and shows both the percentage of eligible people and the percentage of selections. Keep blank answers, excluded rows and the rules you chose visible in the saved workbook.

A worked example

Five eligible people include four who answered and one blank. Those four respondents made seven selections: Excel three times, Presentation twice and Writing twice. Excel is 75% of answering people and 42.86% of selections. With all eligible people as the respondent base, Excel is 60%. The workbook records the chosen base alongside the counts.

How to summarize survey responses

  1. Upload one CSV, TSV or XLSX export with one row per respondent. For Excel, choose one visible worksheet containing plain values.
  2. Select the question column and its separator: semicolon, comma, pipe or line break.
  3. Optionally select an eligibility column and exact eligible value, or group results by a column.
  4. Choose answering people or all eligible people as the respondent base. Review blank answers and duplicate choices.
  5. Download an XLSX with a Data worksheet of counts, bases and both percentages, plus a Summary worksheet recording the counting rules.

What to know

A blank answer is not automatically “none.” Repeated choices in one person’s answer count once. You can supply allowed choices and an exclusive choice; conflicts stop the result for correction. Groups use literal values, including a blank group. This tool does not apply weights or statistical inference.

Excel input must contain plain values. Formulas, macros and linked workbook content are not supported. The saved workbook contains values, not executable formulas. Numeric percentages use a 0–100 scale.

Limits: one 20 MiB file, 20,000 respondent rows, 100 columns and 500,000 input cells; up to 250 choices and 100 groups. Expanded XLSX content is bounded at 128 MiB, processing at 60 seconds and saved output at 32 MiB.

Try one result without an account. Previews are free. Additional new results use your SuperTool account and available paid access. Downloading the same completed result again does not consume another allowance.

Files are processed on SuperTool’s servers and held temporarily for your session. No external file-processing API is used. Download your result before closing the tab.

Questions about survey summaries

Why can percentages add to more than 100%?

One person can select several choices. Each choice’s respondent percentage uses the same answering or eligible people as its base. Selection percentages divide each choice’s count by all selections, so their total is 100% apart from rounding.

Does a blank answer mean none?

No. Blanks stay explicit. Choose whether your respondent base includes all eligible people or only eligible people who answered. An optional exclusive choice can represent a supplied “none” answer, with conflicting selections refused.

Can I compare groups?

Yes. Select one grouping column to report each literal group, including a blank group. You can also select an eligibility column and an exact eligible value. Counts are unweighted.

Browse all SuperTool tools.