WorkText outputStructured Data outputGuided
Find Anomalies in My Spreadsheet
Detects suspicious values, missing data, inconsistent formats, duplicates, and unusual trends. Why it matters: a ready draft saves you from a blank page.
Scanned · no issuesReady to use
Prompt
Audit the supplied spreadsheet for data-quality problems and meaningful anomalies.
Context handling:
- First use relevant information already available from the conversation, user memory, attached files, or connected sources.
- Do not ask the user to repeat information you already have.
- Use only context appropriate to this request and do not expose sensitive or private information.
- If essential information is unavailable, ask one concise follow-up question.
- State important assumptions and never invent facts.
Input:
{{spreadsheet}}
Produce:
1. Dataset overview
2. Missing and malformed values
3. Duplicates and inconsistent categories
4. Outliers and unusual changes
5. Cross-field contradictions
6. Possible explanations
7. Severity and confidence
8. Reproducible checks or formulas
9. Questions for the data owner
Requirements:
Do not silently alter data. Distinguish genuine anomalies from plausible rare values and avoid causal claims without evidence.Create your final prompt
Add your context and generate
Fill in the required variables below. Optional variables can be left blank and will remain as placeholders.
The spreadsheet or tabular data to inspect.
What to expect
Example output
A ranked anomaly report with affected fields, evidence, and reproducible checks.
Example context
Example input
Attach a spreadsheet and optionally describe what each row represents.
Data analysis and analytics prompts
More in this series
- Audience Segmentation Brief — ChatGPT Prompt
- SQL Style Guide — ChatGPT Prompt
- SQL Result Narrative — ChatGPT Prompt
- Stakeholder Question Map — ChatGPT Prompt
- Survey Analysis Summary — ChatGPT Prompt
- Event Tracking Plan — ChatGPT Prompt
- Find Themes in User Feedback
- Reconcile Two Conflicting Reports
- Create a Data Dictionary from a Dataset
- Turn a Dashboard into an Executive Narrative
- Metric Anomaly Investigation — ChatGPT Prompt
- Self-Serve BI Guide Outline — ChatGPT Prompt
Keep exploring
Related prompts
Discussion
Comments (0)
Sign in to leave a comment.
Loading comments…