What "dirty data" means
Spreadsheets merged from several systems are usually messy before you load them into a CRM or database:
- Empty cells — key columns missing data
- Extra spaces — leading/trailing spaces like
John, or repeated spaces inside a cell - Invisible characters —
\u200bor tabs pasted from the web - Duplicate rows — the same customer/order appearing multiple times
- Inconsistent formats — emails missing
@, wrong phone-number length, mixed date styles
Checking every column by hand is slow and error-prone. The ComTools Excel Data Cleaner scans for all of these on upload, produces a clean report, and exports a tidy sheet.
How to use
- Open Excel Data Cleaner
- Upload
.xlsxor.csv(first row = header) - Pick checks to run:
- Empty cells / blank rows
- Leading/trailing and repeated spaces
- Duplicate rows
- Email, phone, and date formats
- Click Preview to see the clean report: count and location of each issue
- Choose the fixes to apply (trim spaces, drop blank rows, dedupe, etc.)
- Click Download to export a clean XLSX
Checks explained
| Check | Finds | Suggested action |
|---|---|---|
| Empty cells | Missing key values | Flag or delete those rows |
| Spaces | Leading/trailing or repeated | One-click trim |
| Duplicate rows | Exact or key-based dupes | Dedupe, keep first |
| Email format | Missing @, typos |
Flag for review |
| Phone format | Wrong length/prefix | Flag for review |
| Date format | Text dates, mixed styles | Send to date converter |
What the clean report gives you
The report summarizes the count and sample rows for each issue type, so you can:
- Quickly judge whether data quality is acceptable
- Locate which column the anomalies cluster in
- Decide what to auto-fix versus review manually
Recommended workflow
Remove blank rows/columns → clean data → dedupe → Excel to SQL
- Remove Blank Rows — strip empty rows/columns first
- Remove Duplicates — clear duplicates
- Excel Date Converter — fix date formats
- Excel to SQL — import into a database