Summarize Pasted Spreadsheet Data into Key Findings and Trends

Paste rows from Excel or Google Sheets and get numbered findings tied to exact figures, a trend table, data quality flags and the gaps that limit conclusions.

You getData snapshot, key findings and trends

Prompt

Prompt
You are a data analyst who writes short, evidence-based summaries for busy managers.

I will paste data copied from Excel or Google Sheets right after this message. Summarize it into key findings and trends.

Rules:
1. Use only the numbers in the pasted data. Do not add outside benchmarks, industry averages or guesses presented as facts.
2. Every finding must cite the specific figures behind it (values, column names, periods) and show any calculation you did, such as percent change or share of total.
3. Keep what the data shows separate from explanations. Label any explanation "Possible reason (not confirmed by data)".
4. Flag anything odd: blanks, duplicate rows, outliers, totals that do not add up, mixed units or date formats.
5. If the data is too small or unclear to support a trend, say so instead of forcing one.

Output format:
1. Data snapshot: 2-3 lines on what the sheet contains (rows, columns, date range).
2. Key findings: 3-6 numbered findings, each one sentence plus its supporting figures.
3. Trends: table with columns Metric | Direction | Start value | End value | Change.
4. Data quality issues: bullet list.
5. Data gaps: what is missing that limits conclusions, and what to add.
6. Worth checking next: 2-3 bullets.

End with one line stating any assumptions you made about column meanings or units.

Example output

Example for: a sales coordinator pasting monthly revenue and units by region, January to June.

1. Data snapshot

19 rows, 4 columns (Month, Region, Revenue, Units). Three regions (North, South, West), January to June. Revenue appears to be in USD.

2. Key findings
  1. Total revenue grew 11.8% from $108,500 in January to $121,300 in June (+$12,800).
  2. West grew fastest: $27,900 to $36,300, up 30.1% (+$8,400).
  3. North remains the largest region: $51,800 in June, 42.7% of the June total ($51,800 / $121,300), up 23.0% from $42,100.
  4. South declined: $38,500 to $33,200, down 13.8% (-$5,300), and fell every month from February onward.
  5. South's drop offset about 29% of North and West's combined gain ($5,300 / $18,100).
3. Trends
MetricDirectionStart valueEnd valueChange
Total revenueUp$108,500$121,300+11.8%
North revenueUp$42,100$51,800+23.0%
South revenueDown$38,500$33,200-13.8%
West revenueUp$27,900$36,300+30.1%

Possible reason (not confirmed by data): South's steady monthly decline could reflect lost accounts or pricing changes. The sheet has no field that would confirm either.

4. Data quality issues
  • South, March appears twice with identical values ($35,900, 412 units). I counted it once.
  • West, April has a blank Units cell, so unit trends for West are incomplete.
  • Revenue mixes formats ("$36,300" and "36300"). Values match after cleanup.
5. Data gaps
  • No prior-year figures, so seasonality cannot be ruled out. Add January to June of last year.
  • No customer or product breakdown, so the South decline cannot be traced. Add a Product or Account column.
  • No targets, so performance against plan is unknown.
6. Worth checking next
  • Confirm whether the duplicate South March row is a copy error or a second real entry.
  • Fill West April units and recheck revenue per unit by region.
  • Pull South revenue by account to see if the drop is concentrated.

Assumptions: Revenue is USD and monthly; Units are items sold; the duplicate row is an error.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Requiring the figures and calculations behind each finding lets you verify every claim against the sheet in seconds.
  • Labeling explanations as unconfirmed stops the model from turning guesses about causes into stated facts.
  • A dedicated data gaps section shows what the summary cannot support, so you don't overstate results in a report.

Use when you need a quick written read of a sheet for a report or meeting. Copy the range with headers and paste it into ChatGPT, Claude or Gemini right after the prompt. Under about 500 rows works best.

Common edits

  • Ask for a 3-sentence executive summary at the top for email or Slack.
  • Add a rule to compare against a target column if your sheet includes one.

Prompt details

By
Prompts-GPT editors
Published

Keep exploring

More in Excel & Spreadsheets