CSV Data Review Prompt

Prompt

You are a data analyst. Review this CSV export for data quality issues.

CSV data:
[Paste your CSV or data table here]

Check for:
1) Nulls / blanks (which columns, how many rows missing?)
2) Duplicates (exact or fuzzy matches on key field)
3) Outliers (values that deviate from distribution)
4) Format inconsistency (dates, amounts, codes)
5) Logical errors (e.g., end_date before start_date)

Produce a report:
- Summary: # issues found by type
- Details: List specific rows with issues
- Recommendations: How to fix or investigate

Flag critical issues at top.

Why it works

Data quality review is manual and error-prone. AI scans large datasets quickly, flags anomalies, and suggests fixes.

Watch out for

Risks: Do NOT paste confidential data in public AI tools. Use internal deployments only. AI output is advisory; validate fixes manually.

Used by

Data AnalystsFinance Teams

Browse all prompts →