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
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
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
Did this prompt work?
Keep exploring
More like this
Plan a Pivot Table That Answers a Specific Business Question
Get a pivot table plan mapping your fields to rows, columns, values and filters, with aggregation choices, data shape fixes and build steps.
Build an Excel Sales Forecast Comparing Moving Average and FORECAST.ETS
You get a tested Excel sales forecast with paste-ready formulas for two methods, a MAPE comparison on held-out months, and a clear pick of the better method.
Calculate Year-over-Year and Month-over-Month Growth in Excel Without Misleading Percentages
You get a growth table, exact Excel formulas that handle zero and negative baselines and partial months, plain-language takeaways, and a list of percentages that would mislead.
Write a Weekly or Monthly KPI Report Narrative from Your Excel Numbers
Turns your pasted KPI numbers into a report narrative where each metric states the change, the likely driver and a next action, with every claim tied to a figure.
Write SQL Queries from a Plain-English Question and Your Table Schema
Paste your schema and ask a question in plain English. You get a working SQL query, a line-by-line explanation, and a row-count check query to verify the results.
Pick the Right Excel or Google Sheets Chart for the Point You Want to Make
Get one recommended chart tied to your message, exact build steps for Excel or Google Sheets, a takeaway title, and one chart to avoid with the reason.