Excel Cleaner

Cleans up messy Excel and CSV files. Removes duplicate rows, drops empty rows, collapses extra spaces, converts Turkish characters to ASCII, fills empty cells.

What it does

Use this on Excel/CSV files coming from different sources with extra spaces, duplicate records and empty rows. Run it before merging CRM exports, before reporting, or before sending to analysis - quick cleanup in one pass.

How to use

  1. Drag files into the list.
  2. Optionally pick a Worksheet and the Columns to clean. Leave blank and every text column gets cleaned.
  3. Tick the cleanup options you want.
  4. Click Run.

You get one cleaned copy per input, in the same format.

Structural cleanup

  • Remove duplicate rows: If multiple rows have identical content, only one survives.
  • Remove fully empty rows: Rows with no data in any cell are deleted.
  • Remove fully empty columns: Columns with no data are deleted.

Text normalization

  • Trim leading/trailing whitespace: Ali becomes Ali. On by default.
  • Collapse multiple spaces: Ali Smith becomes Ali Smith.
  • Convert to UPPERCASE: ali becomes ALI.
  • Turkish to ASCII: şahin becomes sahin, çağrı becomes cagri. Useful for legacy system integrations.

Character filtering

  • Remove non-alphanumeric: Keeps only letters and digits, drops punctuation.
  • Remove specific characters: Whatever you type (e.g. @#$%) is stripped from every cell.

Data integrity

  • Fill empty cells: Empty cells get whatever value you type (e.g. 0, N/A).

Examples

Clean up a CRM list: Add the CSV, tick "Remove duplicate rows" + "Trim whitespace" + "Fill empty cells (N/A)", run. Your customer list is now standardised.

Prep for database load (ASCII only): Add the Excel, tick "Turkish to ASCII". şahin becomes sahin and legacy systems accept it.

Clean only the email column: Add the Excel, pick a Worksheet, turn off "Apply to all text columns", select just the email column, tick "UPPERCASE" + "Trim whitespace".

Drop unused columns: Add the Excel, tick "Remove fully empty columns". Unused sheet columns disappear.

Watch out

  • Numeric columns are automatically protected from text operations, they are not transformed.
  • Structural cleanup (duplicates, empty rows) applies to the whole table, the column selection does not change that.
  • In batch mode the column list comes from the first file only. If other files have different columns, they will not be touched.
  • Turkish-to-ASCII is irreversible, keep the original.
  • Very large files (100MB+) may take a while.

License

Free tier has a monthly clean cap. Office plan removes it.