Free utility · Browser processing

CSV Cleaner

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.

Loading secure workspace…

Ads stay outside the primary workflow.

What you can do

Useful for tidying exported tables and preparing data for spreadsheets or imports.

Find common data issues

Inspect duplicate rows, blank cells, surrounding whitespace, and values that spreadsheet software might treat as formulas.

Normalize with a preview

Choose cleanup options for duplicates, whitespace, recognizable year-first dates, and phone-number separators.

Read common text exports

Detect or select UTF-8 or Shift_JIS and comma, tab, or semicolon delimiters. Save the cleaned result as UTF-8 CSV.

How to clean a CSV file

  1. Choose your CSV or TSV and check the detected encoding and delimiter.
  2. Review issue counts, select cleaning options, and inspect the change preview.
  3. Download a new UTF-8 CSV. The original file remains unchanged.

Worked example: Normalize a small contact export

Save the input below as CSV. Enable whitespace trimming, recognizable date normalization, phone separator cleanup, and duplicate removal, then check the preview.

Input CSV
name,date,phone
 Alice ,2026/1/3,090-1234-5678
Alice,2026-01-03,09012345678
Cleaned table
name,date,phone
Alice,2026-01-03,09012345678

What to expect

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.

How to use the result

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.

Before you start

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.

Common questions

Will it decide what an ambiguous date means?

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.

Why is there an apostrophe before an exported value?

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.