Using the [table name] table ([columns]) for [period]: 1) Total revenue by month and the percent change month to month. 2) Top 5 products and top 5 customers by revenue. 3) Anything unusual: big one-off orders, products that dropped, customers who stopped ordering. Explain each finding in one plain sentence and show which columns you used. Show the math for each total and double-check it. Use only this data; don't add prices or facts that aren't in it. I'm deciding [decision].
Summarize a sales sheet in plain English
You have a spreadsheet of orders and want to know what's selling, who's buying, and what changed, without building pivot tables.
- Copilot
- Claude
- ChatGPT
For: Owner, Office manager, Sales · Updated October 25, 2026
A starting point: fill in the [brackets] with your own details, and check the answer before you use it. Tool screens change often, so yours may look a little different.
Video walkthrough
Video coming later: One Spreadsheet, Two AIs, and an Answer Key (P2-04). Until then, watch the free episodes that are out now.
The prompts
Copy the version for the tool you use, then replace every [bracket].
Here's our sales export for [period] with columns [columns]. Give me monthly revenue with change, top 5 products and customers, and three things that changed. Show the math for every total and double-check every total, and tell me if any rows look like duplicates or errors. Use only the rows I gave you; don't add prices or facts that aren't in the data. I'm deciding [decision].
Fill in these [brackets]
| Bracket | What to put there |
|---|---|
[table name] | Format your data as a table first (Home > Format as Table). e.g. Orders2026 |
[period] | e.g. April to September |
[columns] | e.g. Date, Customer, Service, Qty, Revenue, Tech |
[decision] | What you'll do with the answer. e.g. which service to promote in November |
Real example (Claude, free plan, tested Oct 25, 2026):
Total: $16,730 across 30 rows. The monthly totals add up to this, and the row counts (5+5+6+5+5+4) add up to 30.
Check: 1,400+1,945+1,760+2,150+8,055+1,420 = 16,730.
…
If the Jun 18 duplicate below is removed, drain cleaning drops to $1,665 and falls to 5th place.
…
- August was driven by one job. The $6,800 repipe for Cedar Bend was 84.4% of August (6,800 ÷ 8,055) and 40.6% of the six-month total (6,800 ÷ 16,730). It was a one-time quoted project, not a repeatable pattern.
…
- Likely duplicate: 2026-06-18 appears twice with the same customer (Pine Hollow Apartments), service (drain cleaning), qty (1), revenue ($185) and tech (Luis Ortega). If it’s a duplicate, June is $1,575, not $1,760. It could be two real visits, so check the invoices.
Answer given with our fictional inputs (Kettle Creek Plumbing & Drain, a made-up plumbing company). Excerpt trimmed; “…” marks cuts. AI answers vary, so yours will be different. Check it before you use it.
Watch for: In the same test, ChatGPT compared prices to a price list that wasn’t in the data. The prompt above now says to use only the rows you give it.
Check before you send
- Spot-check one total against the sheet with a SUM
- Percent changes compare the right months
- Duplicates or refunds didn't inflate the numbers
- The 'unusual' items are real, not one data-entry typo
Privacy note: what not to paste
Delete phone, email, and address columns before uploading to any AI outside your Microsoft 365 account. Revenue and product data is usually enough.