Profile column types, missing cells and schema issues, then preview selected-column cleanup and export CSV or Excel.
Useful to know
Does a suggested type change my cells?
No. Profiling does not coerce values. Leading-zero identifiers, large numbers, formatted currency and unrecognised date formats stay text. Empty or whitespace-only cells are counted according to the selected missing rule.
How are duplicate rows counted?
The original profile counts exact repeated data records, including case, spaces and original record width. The cleanup option can remove duplicates using only the selected columns, so its removed count can differ from the original full-row count.
Does this validate a database schema or calculate Excel formulas?
No. It describes the imported columns and flags shape issues. XLSX formulas are preserved as literal text, not recalculated. The first worksheet is read without interpreting styles or date formatting.
Where are my files and inputs processed?
This tool processes your entries on your device. It does not upload them or save them in an account. Downloads remain on your device; Reset clears the current tool workspace.
Rate this tool
Tell others how well Excel and CSV Data Cleaner worked for you. No account needed.