Excel Data Cleaner
Trim spaces, remove blank rows, and clean text in a worksheet.
Review one worksheet column against a selected rule and export a report of rows that fail.
Loading workspace…
Preparing the controls for this tool. Your files have not been selected or uploaded.Working with many files? Open batch processing for supported operations. Batch uses its own basic options.
Clean a sales export — Keep product codes intact while preparing a report.
Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.
Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.
Required checks blank or whitespace-only values. Unique flags repeated string values after their first occurrence. Other rules check email syntax, numeric parsing or YYYY-MM-DD calendar dates. Report row 2 refers to the first data row below the source header.
Only one selected column and one rule are checked at a time. A valid email pattern is not mailbox verification. Numeric validity does not establish currency or business constraints. The tool produces an issue report and does not rewrite the original worksheet.
No rows failed the selected rule. It does not mean every column or every business requirement was checked.
No. This rule compares the stored string values without a case-folding option. Normalize your data deliberately if case should not matter.
Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.
Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.