Survey Results Report Template: Worked Example

A survey results report template with six sections and a worked example: 214 sample responses, the findings a report engine returned, and the CSV.

Have your Excel file ready? Upload it and get a presentation-ready bar chart in seconds.

Create bar chart from Excel →

A survey results report needs six parts: a short summary with the response count, the question and the sample, the results per question, a breakdown by group, the findings ranked with a recommendation each, and a method note. Lead with the answer, end with the method. Download the sample survey file used below (CSV) to follow the worked example.

We make CleanChart, so weigh our ranking accordingly. The template works in Word, Google Docs or Excel. The example shows what a generated report returns for a real-shaped survey file, and what it cannot do.

What should a survey results report contain?

Six sections cover most survey reports, from a customer feedback round to a class questionnaire. Keep the first one short enough to read in a minute.

SectionWhat goes in itTypical length
1. SummaryNumber of responses, the headline score (for example percent agree or Net Promoter Score) and the weakest and strongest result3 to 5 sentences
2. Question and sampleWhy you asked, who was invited, who answered, the period and the response countOne short paragraph
3. Results per questionFor each statement: share who agree, neutral and disagree, plus how many skipped itOne table or one stacked bar chart
4. GroupsWhether age, region or customer type answer differently, and who responded at allOne table per group column
5. Findings and recommendationsThree to five findings, ranked, each with one actionOne line each
6. Method and limitsHow agreement was defined, how skipped answers were handled, what open comments were not analysedA short appendix

Two choices decide whether the report can be trusted. First, define "agree" before you count: for a five-point Likert scale it is usually the two answers above the middle. Second, report skipped answers separately and never as zero. A statement that 29% of respondents skipped is a different finding from one they all answered.

Advertisement

Example: 214 responses to an 8-statement survey

The example is a sample file, not real customer data: 214 responses to a fictional online shop's feedback survey, collected between 1 September and 11 October 2026. Columns: a timestamp, age group, gender, eight statements rated from strongly disagree to strongly agree, a 0 to 10 recommendation question and a free-text comment. It is one of the sample files CleanChart uses to test its report engine; download it as CSV.

The starting chart is a bar chart of the share who agree per statement. Everything quoted below is the output of CleanChart's data report for this file, and it is the same report you can open as a PDF: survey report sample (PDF, 7 pages).

Page 1 of CleanChart's sample survey report: 214 responses, 48% agree on average, Net Promoter Score +11, weakest statement Customer support solved my problem, a written summary and the top three insights
Page 1 of the sample survey report: key figures, a written summary and the top findings. Sample data: Customer Feedback Survey (Responses).csv, 214 rows, 1 Sep to 11 Oct 2026.

The numbers at the top

  • 214 responses to 8 statements
  • 48% agree on average
  • +11 Net Promoter Score: 38% promoters (9 to 10) minus 27% detractors (0 to 6)
  • Customer support solved my problem is the weakest statement

What did the analysis find?

The report returned seven insights, ranked by importance. One is rated key, five notable and one informational. Here is the table of results per statement from page 2 of the report.

StatementAgreeNeutralDisagreeSkippedAnswers
The checkout was easy to use61%27%12%3%208
My order arrived on time56%31%13%2%209
The product matched the description74%22%4%3%207
Customer support solved my problem19%40%41%29%152
Prices are fair for the quality35%11%54%4%205
I found what I was looking for quickly45%36%19%1%211
The packaging was environmentally friendly31%41%28%4%206
I would buy from this shop again62%26%12%3%208

The insights, in the engine's own words with its recommendations:

FindingDetailRecommendation
Only 19% agree with one of your statementsCustomer support solved my problem: 19% agree, 41% disagree (152 answers)The weakest point: read the open comments about it and fix the process behind it first
Net Promoter Score +1138% promoters, 27% detractors; no single question separates them clearly (every link below rho = 0.30)None stated; informational
74% agree with the strongest statementThe product matched the description (207 answers)Use it in your messaging
One question splits respondentsPrices are fair for the quality: 35% agree, 54% disagree, few neutralLook at who answers which way; a split usually means two different groups
2 of 5 age groups bring 52% of responses25-34 and 35-44: 112 of 214Focus where the volume is
1 question was skipped by 29%Customer support solved my problemAdd a "not applicable" option so skips are not mistaken for missing answers

Source for all numbers: Customer Feedback Survey (Responses).csv, 214 rows, 1 Sep to 11 Oct 2026, sample data. The skipped-answer finding changes how to read the weakest statement: 19% agree among the 152 who answered, but 62 of 214 respondents did not answer at all, so the true picture may be a mix of unhappy customers and customers who never needed support.

Page 2 of the sample survey report: a stacked bar chart of agree, neutral and disagree per statement, a table with skipped answers and answer counts, and the Net Promoter Score of +11
Page 2: results per statement with skipped answers shown separately. Sample data, 214 responses, 1 Sep to 11 Oct 2026.

The group section is worth noticing for what it does not say. The report compared every group column against every statement, 16 comparisons, with a chi-squared test on agree versus not agree, corrected for multiple comparisons with the Holm method. Its conclusion: no difference between groups holds after the correction, and the group tables only describe the groups, so differences can be chance. Average agreement by age group runs from 41% (55+, 31 respondents) to 51% (18-24, 28 respondents), but with groups this small the report does not call it a finding. A hand-written report should say the same instead of picking the biggest gap.

How do you turn the results into a report?

Fill the six sections in order from the tables above.

  1. Summary: "214 responses; 48% agree on average; Net Promoter Score +11. Support is the weak point: 19% of those who answered agree it solved their problem, and 29% skipped the question."
  2. Question and sample: "Where do customers see problems with checkout, delivery, support and price? Source: Customer Feedback Survey, 214 responses, 1 Sep to 11 Oct 2026." Add who was invited and the response rate if you know it; the file cannot tell you.
  3. Results per question: the table or a stacked bar chart of agree, neutral and disagree, sorted from strongest to weakest, with skipped shown as its own column.
  4. Groups: who answered (25-34 is 30% of responses) and how groups compare, with the caveat about small groups.
  5. Findings and recommendations: keep the first four findings above and one action each.
  6. Method and limits: agreement means an answer above the scale middle; skipped answers are not counted as disagree; open comments were counted, not read. In the sample file, 58 open answers exist and the report counts them without analysing them, so someone has to read them. For wider layout advice see how to build business reports with charts.

To pick the chart for each question type, see which chart suits Likert, ranking and NPS data. This page is about the report around the charts.

How do you get a first draft from your own survey file?

If your survey results are a CSV or Excel file, for example a Google Forms or Google Sheets response sheet downloaded as CSV or .xlsx, CleanChart can compute the findings and lay out the report.

  1. Upload the file to the CSV to bar chart converter or the Excel one and check the column mapping.
  2. Once the chart renders, open the report offer. The teaser and a blurred preview of page 1 are free.
  3. The full PDF comes with the Deadline Pass ($4.99 for 7 days) and with Pro.

A data report needs 10 to 20,000 rows and enough findings; files that do not meet that show no Report button. The report is an English PDF generated on demand. It is not saved to your dashboard, cannot be emailed on a schedule and is not a Word, PowerPoint or Excel file, so you cannot edit it inside the app. Free-text answers are counted, not read. There is no direct Google Sheets import and no paste: download the sheet as CSV or .xlsx first. More at how CleanChart reports work.

Write it by hand or generate it?

OptionProsCons
Word or Google Docs templateFull control of wording and house style; editable; freeYou compute percentages, ranking and charts yourself; easy to count skips as disagree
Excel pivot tables or survey tool dashboardsEvery figure traceable to a cell; survey tools often include basic chartsNo ranking of what matters and no group test; the report is still written separately
CleanChart data reportRanks findings, separates skipped answers, tests group differences with correction, one-page brief plus method appendixPaid (comes with the Deadline Pass or Pro); English PDF only, not editable; needs 10 to 20,000 rows; does not read open comments and cannot explain causes

Write by hand when the report needs your judgement on every line or a fixed house format. Generate a first draft when you have a clean response table and want to see what stands out before you write.

Frequently Asked Questions

What is a survey results report?

A document that states how many people answered, what they said per question, whether groups differ, and what to do about it. It usually has a summary, per-question results, findings with recommendations and a method note.

Is there a free survey results report template?

The six-section structure on this page is free to copy into any document, and so is the sample CSV. A generated PDF report from CleanChart is a paid feature with a free teaser and preview.

How do you calculate the percent who agree?

Count answers above the scale middle (agree and strongly agree on a five-point scale), divide by the answers given to that statement, and report skipped answers separately. The sample report does exactly this and leaves "don't know" answers out.

How many responses do you need?

There is no single number. Overall results can be read at a few dozen responses, but group comparisons need enough answers per group; the sample report only compares groups with at least 10 answers and still finds no gap that survives correction.

Which file formats can I analyse with CleanChart?

CSV, Excel (.xls and .xlsx), ODS, JSON, XML, YAML, TSV, TXT and Markdown. Google Sheets or Forms results work as a CSV or .xlsx download.

Related CleanChart Resources

Tools

Related Blog Posts

External Resources

Advertisement

Turn your Excel data into a bar chart

Upload your Excel file → the bar chart is built from it → download the result. No account needed.

Create bar chart from Excel