Find common data issues
Inspect duplicate rows, blank cells, surrounding whitespace, and values that spreadsheet software might treat as formulas.
Free utility · Browser processing
Check a CSV or TSV before importing it elsewhere. Find duplicate rows, blanks, and inconsistent formatting, choose what to clean, and preview the changes before saving a copy.
The cleaning workspace runs on an isolated Webutila origin. Advertising scripts on this page cannot read your selected file or cleaned output.
Ads stay outside the primary workflow.
Useful for tidying exported tables and preparing data for spreadsheets or imports.
Inspect duplicate rows, blank cells, surrounding whitespace, and values that spreadsheet software might treat as formulas.
Choose cleanup options for duplicates, whitespace, recognizable year-first dates, and phone-number separators.
Detect or select UTF-8 or Shift_JIS and comma, tab, or semicolon delimiters. Save the cleaned result as UTF-8 CSV.
Save the input below as CSV. Enable whitespace trimming, recognizable date normalization, phone separator cleanup, and duplicate removal, then check the preview.
name,date,phone Alice ,2026/1/3,090-1234-5678 Alice,2026-01-03,09012345678
name,date,phone Alice,2026-01-03,09012345678
After normalization, both rows describe the same values and only one row is kept in the output. Compare the preview with your intended rules before saving: matching whole rows is different from identifying the same person.
Keep phone numbers and identifiers as text when importing the result into a spreadsheet, or leading zeroes may disappear. Selecting the correct input encoding also matters; exporting UTF-8 cannot restore characters that were decoded incorrectly.
Blank cells and ambiguous dates are reported rather than guessed or filled in. Phone cleanup normalizes separators; it does not verify whether a number exists. Formula-like exported cells are prefixed to reduce spreadsheet injection risk.
Current limits: One file up to 25 MB, with 50,000 data rows, 250 columns, and 2 million cells.
No. A value such as 03/04/2026 could mean March 4 or April 3. Resolve ambiguous formats at the source; this tool normalizes recognizable year-first dates rather than guessing a locale.
Values that could be interpreted as spreadsheet formulas are prefixed to reduce formula injection risk. The saved text may therefore differ from the input. Review this behavior if another application requires an exact text match.