Windows Data Quality Tools Guide

On This Page

Before You Run

Open a data file and select a range. Every tool reads the active table. A tool that writes changes marks the workbook dirty and saves it after a short delay.

Read the notices column after a run. A notice explains a cell that could not be changed. The value in the cell is not replaced by an error marker.


Profile and Insights

Profile reports fill rate, distinct values, duplicates and length statistics for a column. It also reports issues such as mixed case, stray whitespace and inconsistent country names.

Use the issue list to choose a cleaning operation. Each issue names the repair the engine can run. The result table shows counts and examples, not a rewrite of your data.


Clean and Transform

Clean and Transform rewrites the selected column. Available operations include whitespace collapse, control character removal, HTML stripping, case rules, find and replace, regular expression replace, name and phone parsing, email normalisation and type coercion.

A regular expression must compile and stay within the allowed size and flags. A bad expression records a notice and leaves the source cell untouched.

Beside writes place the result in the first free column so the source remains visible. Multi part pipelines write one column per part with its own heading.


Match and Dedupe

Match and Dedupe uses a ladder of strategies. Exact match runs first, then normalised text, then phonetic keys, then a bounded fuzzy comparison. The bigram bound prunes impossible pairs before scoring, which keeps large lists practical.

Keep mode chooses the first record, the last record or a golden record built from the most complete values. The result lists groups, chosen records and merge previews. Merge and purge reduces the table after you review the plan.


Data Verification

Explain Matches reports a score, a strategy and a reason for each pair. Use it when a match looks wrong and you need to know why it was suggested.

Golden record selection scores completeness and chooses the best value per field. Numeric match compares columns within a tolerance and reports deltas.


Automation

Schedule a job to repeat a cleaning function on an interval. Jobs survive a restart. Pause and resume keep the remaining wait.

Run now reaches the scheduler directly. The Recent activity table in My Account records every operation and every scheduled run with a status and row count.