Make Sense of Spreadsheet Data with Claude
Give Claude your data and get clear insights, chart recommendations, and the narrative to tell, without becoming a data analyst.
The situation
You have a spreadsheet full of numbers and a presentation tomorrow that asks you to explain the trends.
After this guide you'll be able to turn any dataset into a clear story using Claude as your analyst.
What you walk away with
The key trends and patterns in your data explained in plain English
Specific chart recommendations for your data type
The one-sentence headline finding to lead with in any presentation
The difference one prompt makes
Don't
analyze my data [paste]
Do this
I'm pasting 3 months of sales data. Columns: Date, Region, Product, Revenue, Units Sold, Sales Rep. I need to present this to leadership next week. Tell me: 1) The top 3 trends or patterns you see. 2) Any anomalies I should be prepared to explain. 3) The charts that would make this story clearest. 4) In one sentence, what's the headline finding? [paste data]
Without context Claude does generic statistics. With your goal ('present to leadership') it tells you what matters.
Copy a sample of your data
50 to 200 rows is usually enough for Claude to find patterns. If your dataset is larger, copy a representative sample across the full time range, not just the most recent rows. Include the header row so Claude knows what each column contains.
- Include the header row in your copy
- 50 to 200 rows is the right range for pattern detection
- If you have a large dataset, sample across the full time range rather than just recent data
- Exclude any columns with personal information (names, emails, addresses)
Paste with context: what the data represents and what decisions it informs
The same data means something completely different depending on what you are trying to do with it. Tell Claude what the data is, why it exists, and what question you are trying to answer. This changes what it highlights.
Ask for patterns and anomalies, not just summaries
A summary tells you what you already know (revenue was up 12%). A pattern tells you something you missed (revenue was up in three regions and flat in the fourth, which drove the average). Ask Claude specifically for what is unusual, not what is typical.
- "What is the most surprising thing in this data?"
- "Are there any outliers I should investigate before I present this?"
- "What is driving the number that looks best? What is driving the one that looks worst?"
- "If I only had 60 seconds to present this, what would I say?"
Ask for chart recommendations and how to build them in Excel
Once you know what story you are telling, ask Claude which chart type tells it best. Different stories need different chart types, and the wrong chart actively makes your point harder to see.
- Trends over time: line chart or area chart
- Comparing categories: bar chart (not pie chart)
- Part-to-whole: stacked bar or treemap
- Relationship between two variables: scatter plot
- Ask Claude: "Given this story, what chart type makes the point fastest?"
Ask Claude to write the narrative for your presentation
The chart shows the data. The narrative tells people what to think about it. Ask Claude to write the two or three sentences you say when each slide appears.
- "Give me 3 sentences I can say when presenting the trend slide."
- "Write the setup line that makes the anomaly feel significant, not random."
- "How do I explain the Friday spike without it sounding like an excuse?"
What's next?
Create presentations with ClaudeNew guides, when they ship
One email, roughly weekly. CLAUDE.md templates, workflows I actually use, and the cut-for-length stuff that does not make the public guides. One-click unsubscribe.
Or follow on Substack