How to Summarize Text Data with Claude in Excel
Turn long comments, survey responses, and notes into clean summaries and themes using Claude in Excel.
2026/02/06
When this guide helps
Use this guide for survey responses, support tickets, meeting notes, or any column with long text that needs a clear summary.
Step-by-step workflow
1. Summarize each row
Prompt:
Summarize the text in column D into one concise sentence. Put the summary in column E.2. Extract themes across the dataset
Prompt:
Review column D and list the top 5 themes with a short explanation of each.3. Tag each row with a theme
Prompt:
Assign one of the 5 themes to each row in column D. Put the theme label in column F.4. Create a quick dashboard
Prompt:
Create a pivot table that counts the number of rows in each theme (column F).Practical tips
- Limit the range if the dataset is large, then process in batches.
- Ask Claude to keep summaries under a specific word limit.
- Use consistent theme labels to avoid duplicate categories.
Common pitfalls
- Mixing multiple topics in one cell can lead to unclear summaries.
- If the text contains sensitive data, remove or mask it before analysis.