Find near-duplicates

Before a CRM import, the same company appears under three spellings, a customer with a typo. Exact deduplication cannot see them: here, rows that look alike are grouped, and you decide group by group.

What this tool does

Spellings reduced to the essentials: case, accents, punctuation, dotted abbreviations, legal forms (Ltd, Inc, LLC, GmbH, SA…), "&" and "and".
Typos and words in a different order brought together, with an adjustable sensitivity.
The least certain groups first; rows identical once cleaned are accepted in advance.
Your choice: remove the duplicates and keep the first row, or number the groups in a column and remove nothing.

What it does not do: Similarity is not proof: "Martin Ltd" in Leeds and "Martin Inc" in Boston may be two companies. Add the city or the postcode to the compared columns, and review the groups.

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.
Clean text : Extra spaces, non-breaking spaces, line breaks, invisible characters, case.
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.