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.
Feb 6, 2026
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.