Prompt Almanac

Create beginner Works with: Any AI

Google Sheets Survey Results Summary With Pivot Tables

Structured brief Has example

Summarise survey answers by group.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Rate this prompt

Loading ratings…

Summarise survey results in Google Sheets. Questions, answer scales and response count: [SURVEY_STRUCTURE]. Groups I want to compare: [GROUPS]. Sample of responses: [SAMPLE_RESPONSES]. Minimum group size for reporting: [MINIMUM_GROUP].

Give the steps and pivot settings to create counts and percentages by group, formulas for average score, response rate (84 responses from 120 invitations is 70 percent) and the share who chose each option, and how to handle blanks, 'don't know' and free text [VERIFY menu names]. Worked example with ten invented responses and the arithmetic. Recommend suitable charts and when not to chart small groups.

Do not report groups below the minimum, combine or suppress them so individuals cannot be identified. Reading guide: compare groups only when each has enough responses, show counts with percentages, avoid claiming a difference from a handful of answers, and put a caution line under each chart. Keep the output to a one-page summary and a table I can paste into a report. If the sample responses are too few to support a comparison, say so plainly and tell me what to report instead.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

See an example result (fictional data)
Invented survey: 84 responses from 120 invitations, a 70 percent response rate. Question: 'How satisfied are you?' scale 1 to 5. Counts: 5 = 30, 4 = 27, 3 = 15, 2 = 8, 1 = 4. Average = (150 + 108 + 45 + 16 + 4) / 84 = 323 / 84 = 3.85. Satisfied (4 or 5) = 57 / 84 = 67.9 percent. Pivot by department: Sales 20 responses, average 4.1; Support 12 responses, average 3.2. Support has fewer than 15 responses, so show counts and treat the average as indicative. Caution line under the chart: 'Small groups: interpret with care.'

Illustrative only, made-up data. Your results will differ and must be reviewed.

Related prompts