Workflow 10 / Data quality
Clean a spreadsheet without losing the original
Find inconsistent formats, duplicate candidates and missing values before the data enters a report.
What you need
A copy of a small dataset, column definitions, valid formats and the business rule for identifying duplicates.
What you’ll produce
A proposed cleanup plan, a change log and a separate exceptions list.
Follow the workflow
- Keep an untouched original and work on a copy. Assign stable row IDs and define formats such as dates, currencies and account codes.
- Ask AI to identify problems and suggest formulas or transformations. Preserve leading zeros and distinguish blanks from zeros.
- Test proposed changes on a sample. Check row counts, duplicates, totals and formulas with spreadsheet tools rather than relying on generated text.
- Review every ambiguous match before applying the cleanup to a separate output file. Retain the mapping from original to corrected values.
Your starter prompt
Review this sample using the data dictionary. Propose cleanup rules and give a table of row ID, original value, proposed value, reason and confidence explanation. Flag uncertain dates and duplicate candidates for human review. Do not fill missing values, merge records or remove rows without an explicit rule. Preserve IDs and leading zeros. Provide validation checks for row counts and numeric totals. Data dictionary and rules: [paste] Sample rows with IDs: [paste]
Before using the result
Recompute totals and compare row counts before and after. Test formulas in your own spreadsheet version and never overwrite the only copy.
Choose an approved tool
Start with the assistant your organization already approves. Work from a small sample and use only information you are permitted to share. File support and connected-app features depend on the product and plan. These guides do not connect to your accounts or run tasks for you.
Further learning: Microsoft Learn: workplace Copilot training. This is an original OutOfAI℠ workflow and prompt, not a vendor-certified procedure or a tested claim of time savings. Prepared October 22, 2026.
