Money & Admin · Starter

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.

Prompt Park Sessions · Three-Minute AI for Small Business

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].

COPILOT
Copilot in Excel needs the file saved to OneDrive or SharePoint with AutoSave on, and data as a table or a clean range. Try chat mode first so nothing in the sheet changes.
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].
CLAUDE OR CHATGPT
Upload the file (remove customer contact columns first). Tested as written in Claude and ChatGPT (free plans), Oct 25, 2026.
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]

BracketWhat 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.

…

  1. 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.