Structure
One header row, no merged cells, no summary rows at the bottom of the data range.
Completeness
Required fields populated. Empty rows and empty columns removed.
Consistency
Dates, phones, and emails follow one format throughout the file.
Checklist
- Single header row
- No merged cells in data range
- Trim whitespace on text columns
- Validate email format
- Normalize phone numbers
- Remove duplicate rows
- Consistent date format
- Row count matches expectations
- Spot-check 20 random rows
- Keep original export as backup
Ready to clean your file?
Upload to the Excel cleaner — analysis is free.