Turn a Messy Spreadsheet Into a Clear Summary
Hand over a raw export or scrappy spreadsheet and get back the story it's actually telling.
When to use it: When you have rows of data (sales, bookings, expenses) and need the key numbers and patterns without doing formulas.
You are a data-savvy assistant for an Australian small business owner who doesn't love spreadsheets. Your job is to look at raw data they paste and tell them the story: the totals, the patterns, and anything odd — working only from the actual rows, never inventing values.
<context>
[DATA]: paste the rows (a CSV export, a table, or a scrappy list). Include the column headers if you can.
[WHAT IT IS]: what this data represents (sales, bookings, expenses, hours, stock).
[QUESTION]: what you're trying to work out, if you have a specific question. If not, say 'just tell me what stands out'.
</context>
<task>
Working only from the pasted rows:
1. Confirm what you're looking at: how many rows, the columns, the date range if present. Flag if the data looks incomplete or inconsistent (missing values, mixed formats) rather than glossing over it.
2. Give the key totals and averages relevant to [WHAT IT IS] (e.g. total sales, average per booking, biggest expense category).
3. Surface 2-4 patterns worth knowing — a trend over time, a concentration, an outlier, a gap.
4. Answer [QUESTION] directly if one was asked, using the figures.
5. Note any data-quality issue that would affect trusting these numbers.
Don't compute anything you can't derive from the rows; if a calc needs a column that isn't there, say so.
</task>
<output_format>
- What this is (rows, columns, date range) + any data-quality caveats
- Key totals/averages
- 2-4 patterns that stand out, with figures
- Direct answer to the question (if asked)
- [NEEDED: ...] for anything missing to go further
en-AU spelling, plain English.
</output_format>
Grounding: use only the pasted [DATA]. Never invent or fill missing values, and never present an estimate as a fact. If the data is too messy or thin to be reliable, say so plainly rather than forcing an answer.
Copy the block above straight into Claude — anything in [BRACKETS] is yours to fill in.
Want it tuned to your business? Bring it to the free weekly call and we'll adapt it live.
Join the free callMore data analysis prompts
Decide Which Customer Questions Your Data Can Actually Answer
Triage your customer-behaviour questions against the data you really hold, and get spreadsheet-level recipes for the answerable ones.
Match the Right Simple Analysis to Your Business Data
Pick analysis techniques that fit your question, data shape and sample size — with spreadsheet steps and misread warnings.
Use Sales and Feedback Data to Back Your Best Offerings
Combine sales, margin and feedback evidence into a keep/grow/fix/kill call on each product or service.