First Look at Spreadsheet Data: Quality Checks, Patterns, Outliers and Next Questions
Paste a spreadsheet and get a data quality check, findings ranked by how solid they are, outliers sorted into errors vs real, and questions to investigate next.
You getData snapshot, quality issues table and findings ranked strongest first
Prompt
Act as a careful data analyst doing a first look at a spreadsheet. I will paste my data (CSV, copied cells or a column summary) right after this prompt, plus one line on what it tracks. Tell me what the data shows, what looks wrong and what to check next.
Rules:
1. Do the data quality check first: missing values per column, duplicate rows, mixed units or formats (kg vs lb, dates stored as text), and impossible values. Make no trend claims until this is done.
2. Every finding cites the specific rows, columns or numbers it rests on.
3. Rate each finding Solid, Likely or Shaky, with a one-line reason (sample size, quality issue, one outlier driving it).
4. Separate outliers that look like entry errors from outliers that look real.
5. Do not state causes as facts. Phrase them as questions to investigate.
Output format:
1. Data snapshot: row count, columns, date range, what each column appears to measure.
2. Quality issues table: Issue | Where | Impact on analysis | Suggested fix.
3. Findings ranked strongest first: table with Finding | Evidence | Rating | Why.
4. Outliers: likely errors vs likely real.
5. Top 5 questions to investigate, each with the check that would answer it.
End with one line on what this data cannot tell me and what extra data would help.Example output
Tips and common edits
Why this works
- Forcing quality checks before trend claims stops the model from building conclusions on duplicates, text-formatted numbers or typos.
- Solid/Likely/Shaky ratings with reasons show which findings you can act on and which need more data.
- Turning causes into questions with a named check gives you a concrete next step instead of guesses dressed as facts.
Use when you open an unfamiliar export and want a sober first pass. Paste up to a few hundred rows into ChatGPT, Claude or Gemini, or upload the file, and add one line on what it tracks.
Common edits
- Add a goal line, such as 'I want to decide staffing,' so findings are ranked by relevance to that decision.
- Ask for Excel or Google Sheets formulas to fix each quality issue listed.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Interpret P-Values, Effect Sizes and Confidence Intervals in Plain English
Paste your statistical output and get a plain-English reading of each number, what it supports, what it does not prove, and the misreadings to avoid.
Build a Verification Checklist for AI Answers and Their Citations
Paste any AI-generated answer and get a table of every claim and citation, rated by risk, with red flags and the exact check needed to verify each one.
Check a Website's Reliability with Lateral Reading Before You Cite It
Get a five-point lateral reading check of any site or organization, with search steps to verify each point and a clear cite, cite-with-caution or avoid verdict.
Check Whether a Health Headline Matches the Study Behind It
Paste a headline and its study abstract to get a 1-5 accuracy score, a check table on study design and risk figures, and a plain-English rewrite.
Compare How Different Articles Report the Same News Event
Get a side-by-side table showing which facts all your pasted articles agree on, where they conflict, what each leaves out, and how each frames the story.
Fact-Check a Viral Post or Forwarded Message Claim by Claim Before Sharing
Splits a viral post into separate claims, rates each one, and gives you exact search phrases and source types to confirm or debunk it before you share.
- Trace a Quote or Claim Back to Its Original Source Step by Step
- Build a Literature Review Matrix from Pasted Abstracts with Gaps and Contradictions
- Code Interview Transcripts into Themes with Participant Counts and Verbatim Quotes
- Design a Bias-Checked Survey Where Every Question Informs a Decision
- Draft a Research Methodology Section with Justified Design and Validity Threats
- Learn Any New Topic Fast with a Concept Map, Key Debates and Self-Check Quiz