Clean the text of an Excel or CSV file
"Smith" and "Smith " are not the same value to a spreadsheet, and a VLOOKUP fails without a word. Choose the columns: extra spaces, non-breaking spaces, line breaks and invisible characters go, and the case is made consistent if you want.
What this tool does
- Leading, trailing and double spaces, and non-breaking spaces from a web page or a PDF.
- Line breaks inside cells, replaced by a space.
- Invisible characters: zero-width spaces, soft hyphens, control codes.
- Case: UPPERCASE, lowercase, Title Case, or Sentence case.
- The preview highlights every changed cell before you save.
What it does not do: Only the ticked columns are touched, and only their text cells: numbers and dates stay as they are. Typos are not corrected.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Fix a CSV file : Broken accents, everything in one column, lost zeros: a file Excel opens right the first time.
- Remove duplicates : On the columns you choose, optionally ignoring case, spaces and accents.
- Near-duplicates : "Smith Ltd" and "SMITH LTD.": the almost-identical duplicates, reviewed one by one.
- Convert text to numbers : "1,234.56 $", "(45.00)", "12.5-": real numbers that add up.
- Fix dates : Dates as text, day and month swapped, "20260315": real dates.