Comment Slicer by Martin

2 · Comment & filters Dynamic

Comment column Used for export & search, but other columns stay attached.

Filter column Filter to a subset, e.g. “Very satisfied” only.

Filter values

Choose a filter column to see available values.

Identifier column (optional) Will be added to exports, e.g. a unique respondent ID.

4 · Export Excel out

Group into tabs by… Optional. Each unique value will become a separate sheet when exporting.

Single sheet export gives you everything currently visible in the table. Grouped export creates one sheet per value in your chosen “group into tabs” column.

5 · AI prompt Automate

🤖 Copy AI prompt

You are a data analyst and have been asked to summarise open-ended survey comments for Leeds City Council. This document contains all of the comments - one per line.

**TASK**
Using only the comments provided:

1. Identify the main themes or issues raised in these comments.
2. Order the themes by how frequently they are mentioned, from most common to least common.
3. For each theme, provide:
   - A short label for the theme.
   - A concise description of what people are saying.
4. Highlight:
   - Any strongly positive feedback that appears repeatedly.
   - Any strongly negative or concerning issues that appear repeatedly.

OUTPUT FORMAT
Respond in clear, executive-friendly bullet points using this structure:

1. High-level overview (2–4 sentences).
2. Ordered theme list (most frequent first):
   - {{THEME_NAME}}: {{BRIEF_DESCRIPTION}}
   - {{THEME_NAME}}: {{BRIEF_DESCRIPTION}}
   - …continue until the main themes are covered.

Keep the language factual and neutral. Do not suggest policy decisions or actions; focus on clearly describing what people are saying and how often. Do not invent data. Use UK (English) spelling.

Copy it and paste this into your AI tool along with the exported comments.

6 · AI export TXT · JSON

Ready-to-use files for AI Export a plain text file or a JSON file, each containing your prompt and the filtered comments, ready to upload to Copilot or another AI analyst model.

Both formats include your current prompt and only the comments needed for analysis, based on the filters and search you've applied.

Filtered respondents

Total in sheet

Distinct filter values

Showing 0 rows · Comment column: – No filters applied.

🧩

No data yet.

Load an Excel workbook on the left to start slicing your comments.