FuzzyMatch

Getting started

FuzzyMatch compares two lists and finds the rows that describe the same person, company or thing, even when the spelling, formatting or word order differs. A typical job: match a CRM export against a billing system to see which customers appear in both.

Your first match

  1. Add files. Drop in two files: the records you want to find matches for, and the records to search. Don't have files handy? Click Try with sample data under each upload box.
  2. Pick columns. FuzzyMatch pairs columns that look alike, such as Full Name with Contact Name. Check each pair, set how much it matters, and choose how strict to be.
  3. Review matches. Every match has a score from 0 to 100%. Filter by score, check the uncertain ones, then download the results as CSV.

You can try FuzzyMatch on the home page without an account. Create a free account to keep your results and match bigger files.

What it's good at

  • Names with typos, nicknames or a different order: Bob Smith, Robert Smith, Smith, Robert
  • Company names with or without Inc, LLC or Ltd, or in different case
  • Phone numbers and emails in different formats

Next steps