Skip to content
Data AnalysisIntermediate

Summarize a Dataset in Plain English

Get a plain-English read on what a small dataset shows, before diving into deeper analysis.

Prompt

Here is a small dataset (as text/CSV):

{{data}}

Summarize the key patterns you notice in plain English — trends, outliers, or anything that stands out. Then list two or three follow-up questions I should investigate further. Don't perform statistical tests; just describe what's visibly notable.

Fill in these placeholders

  • {{data}}

How to use it

Keep the pasted data small enough to review at a glance yourself — use this to sanity-check a dataset, not as a substitute for real statistical analysis on large data.

Example use case

Getting a first-pass read on a small spreadsheet before deeper analysis.

Why this prompt works

The requirement to distinguish what the data shows from what it might mean is the safeguard here. Language models pattern-match toward causal explanations because that is how humans write about data, and correlation quietly becomes cause somewhere in the second paragraph. Asking for the caveats separately keeps that boundary visible instead of buried.

What good output looks like

A clear description of the pattern, an explicitly separate section for possible explanations, and stated limitations. If explanations and observations are mixed in the same sentences, ask it to split them apart and re-read the result.

Common mistakes

  • Pasting data without saying what it measures or over what period, which invites confident nonsense.
  • Accepting causal language. 'Sales rose because of the campaign' is a claim your data almost certainly cannot support.
  • Using the summary in a decision without checking the numbers yourself. Arithmetic is not a strength of these models.

Variations worth trying

  • Add 'list what this data cannot tell us' — often the most decision-relevant paragraph in the output.
  • Ask what additional data would make the pattern conclusive, which turns a summary into a next step.
  • Ask it to describe the pattern without using any causal words at all, then see what remains.

Want to write prompts like this yourself? Prompt Engineering for Real Work covers the structure behind every template here — free, no sign-up.