Data template

Survey Results Analyser

Turns 1–5 responses into averages, top-box scores and a distribution per question.

$12one payment, yours to keep

✓Instant download
✓Every later version free
✓Commercial use
✓No signup, no watermark

26: live formulas, each one recalculated and checked
9: columns: Question, 1, 2, 3, 4, 5, Responses, Average, Top box
5: figures worked out for you

Whoever ran the survey · Teams, charities and schools running surveys — usually looking for this when responses are in and nobody has turned them into findings.

Need more than one? All 9 Data templates for $39 — $119 bought separately. All 66 for $99.

Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide. Version 1, updated 25 September 2026.

There are free templates. Why this one?

There are, and some are fine. The difference is what has been checked. This file was built from scratch, then every formula in it was recalculated by a separate checker that compares each result against an independently worked-out answer — 26 of them here. A template that looks right and totals wrong is worse than no template at all, and that is the usual failing of one downloaded from a search result.

It also opens with sample rows already filled in, so you can see every formula working before you touch it, and it is set up to print without fighting the page setup. No email wall, no signup, no watermark, and you can use it commercially.

About this Survey Results Analyser template

Rating-scale survey results only become useful once they are summarised properly. This Excel survey results analyser takes the number of 1, 2, 3, 4 and 5 responses for each question and works out the total responses, the average rating and the top-box score.

The headlines show the overall average, the best and worst scoring questions, the average top-box score and total responses.

Good for

→Customer satisfaction and feedback surveys
→Employee engagement surveys
→Event and training feedback forms

What it works out for you

Headlines

→Overall average
→Best scoring question
→Worst scoring question
→Average top box
→Total responses

What is inside the Survey Results Analyser template

The table has 9 columns. Calculated columns fill themselves in; the rest are yours to type over.

→Question
→1
→2
→3
→4
→5
→Responses
→Average
→Top box

How to use the Survey Results Analyser in Excel

Paste your counts per rating. Average, top-box (4s and 5s) and the response spread all calculate.

The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.