Validate, alert & clean up spreadsheet data

Upload a sheet to get an instant data-quality report โ€” duplicates, blanks, invalid emails and dates, stray spaces, numbers stored as text and outliers. Add your own rules, then fix everything in one click.

1. Load your data

Drop a file here or click to browseXLSX, XLS, CSV, TSV, ODS, JSON โ€” processed locally

What this tool checks

  • Duplicates โ€” identical rows, ignoring case and surrounding spaces.
  • Missing values โ€” blanks in columns that are otherwise filled.
  • Invalid emails and dates, plus mixed date formats in one column.
  • Numbers stored as text โ€” values like "29" or "$9.00" that SUM ignores.
  • Inconsistent values โ€” London, london and LONDON in the same column.
  • Extra spaces & hidden characters that silently break VLOOKUP and MATCH.
  • Outliers โ€” numbers far outside the normal range (likely typos).
  • Spreadsheet errors โ€” #N/A, #REF!, #VALUE! and friends.

Set up the same alerts inside Excel or Google Sheets

Use Data โ†’ Data validation to block bad input at the source, and Conditional formatting with a custom formula such as =COUNTIF($A:$A,A2)>1 to highlight duplicates as they appear.