Find Data Quality Issues

Identify duplicates, blanks, inconsistencies, and formatting problems in your data

🧪 Tested by a human Intermediate 👤 Analyst 👤 It Admin 👤 Operations
Scan this table for data quality issues. Look for: (1) Duplicate rows, (2) Blank or missing values in required columns, (3) Inconsistent formatting (dates, currencies, text case), (4) Values that look like typos or outliers. List each issue with the row number and a suggested fix.

Works on

⭐ M365 Copilot (Best)

Copy & Open in

Prompt is copied to your clipboard when you click

Tips for Best Results

  • Run this before any reporting or analysis to catch problems early
  • For large datasets, add “Focus on columns [A, B, C]” to narrow the scope
  • Follow up with “Fix the issues you found” to let Copilot apply corrections

📎 More Prompts

Budget vs Actual Tracker

●●
Set up a budget tracker with monthly columns for budget and actual, auto-calculated variance, conditional formatting, YTD totals, forecast, and dashboard summary.
⭐ M365 🟢 GPT 🟠 Claude

Build a Complex Formula

●●●
Create a formula that [DESCRIBE WHAT YOU NEED — e.g., calculates the priority score based on severity (High=3, Medium=2, Low=1) multiplied by the number of days open, then sorts into Critical/High/Medium/Low tiers]. Explain how the formula works step by step so I can modify it later.
⭐ M365

Create an Insightful Chart

●●
Create a chart that best shows [WHAT YOU WANT TO VISUALISE — trends over time / comparison between categories / distribution of values] from this data. Choose the most appropriate chart type. Add clear labels, a title, and a legend. Then explain in one sentence what the chart tells us.
⭐ M365
💬