Excel data cleaning tools
Exports from CRMs, banking portals and web forms rarely arrive ready to use. The same customer appears twice, names carry invisible spaces, blank rows break filters and capitalisation is all over the place. Each tool below fixes one of those problems and shows you exactly what changed before you download.
Every tool works the same way: open your Excel or CSV file, adjust a few options if the defaults are not right for you, check the highlighted preview, then download a clean copy. The original file is never modified and never leaves your computer.
6tools available
Remove duplicates
Find and remove repeated rows, by whole row or chosen columns.
Remove extra spaces
Trim leading, trailing, double and invisible spaces from cells.
Remove blank rows
Delete empty rows and columns in one step.
Change case
Switch text to UPPER, lower, Proper or Sentence case.
Remove special characters
Strip symbols and punctuation while keeping letters in any language.
Fill blank cells
Fill empty cells with the value from the row above.