Skip to content
Veracy Toolbox
← All prompts

CSV Data Review

Finance Data Analyst Finance Ops

The 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 this works

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

Risks & review

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