Free tool · runs in your browser
Excel Data Quality Checker
Free Excel data quality checker - paste rows and find duplicate rows and IDs, extra spaces, mixed date formats, text in number columns and blanks, with cell addresses. Runs in your browser.
8 issues found
6 of 7 checks flaggedDuplicate rows 1
row 5 = row 3
Data > Remove Duplicates, or Power Query > Remove Duplicates so it repeats on every refresh.
Same "Invoice" with different data 0
Mixed date formats 1
Date (both DD/MM and MM/DD present)
Some dates are text or the wrong way round; month totals will be wrong. Power Query > Change Type > Using Locale fixes this per source.
Text in a number column 1
D6
SUM skips these cells without warning. Remove the symbols or units, then convert with VALUE() or Data > Text to Columns.
Extra spaces 2
B3, B5
Lookups fail on "Blue Leaf " vs "Blue Leaf". Use =TRIM() or Power Query > Format > Trim.
Same name, different capitals 1
Customer: Acme Traders / acme traders
Pivot tables treat these as one item but Power Query and exact matches don't. Standardise with =PROPER().
Blank cells 2
B7, D4
Check whether blanks mean zero, unknown or missing; filters and averages treat them differently.
Cleaned copy ready
6 cells fixed (spaces, dates as YYYY-MM-DD, units removed from numbers) and 1 duplicate row removed. 1 date was left unchanged because the day and month can't be told apart. Capitals and blanks are left for you to decide.
Fixing this once is easy. If the same mess arrives every month, it should clean itself on refresh.
Send these results on WhatsAppData cleaning, done once
Stop fixing the same data every month.
A Power Query clean-up fixes duplicates, spaces and date formats automatically each time new data arrives. See the data cleaning service.
Self-serve
Direct channels
Score it, then
build it.
- Free tools
- 15
- Time to result
- <2m
- Forms to fill
- 0
- 1Run the tool
- 2Send the output
- 3Get the build