FuzzyMatch

Two lists.
Same people.
Spelled differently.

FuzzyMatch finds the customers, vendors and contacts your spreadsheets share, even through typos, nicknames and mismatched columns.

Free, no sign-up: match two files of up to 500 rows each, twice a day. Files are deleted after an hour.

crm_export.csv

  • Jon Smith
  • Maria Gonzales
  • Bob's Plumbing LLC

event_signups.xlsx

  • John Smith
  • María González
  • Robert's Plumbing
  • Jon Smith ↔ John SmithMatch 96%
  • Maria Gonzales ↔ María GonzálezMatch 93%
  • Bob's Plumbing LLC ↔ Robert's PlumbingCheck 71%

How it works

  1. Step 1: Add two files

    CSV, Excel or JSON. You see the rows in your browser before anything is sent.

  2. Step 2: Check the columns

    Matching columns are paired for you, even when the headers differ. Change any pair you like.

  3. Step 3: Review and download

    Every match has a score. Look over the close calls, then download both records side by side.

People use it to…

  • Deduplicate a CRM

    Find the same customer entered twice with a typo, a nickname or a new email domain.

  • Reconcile vendor lists

    Match supplier names across accounting and procurement systems that spell them differently.

  • Merge mailing lists

    Combine sign-up sheets and newsletter exports without emailing anyone twice.

  • Clean up research data

    Link survey responses to participant records when names and addresses don't line up.

Questions

What is fuzzy matching?

It finds records that refer to the same thing even when they aren't written identically, such as "Jon Smith" and "John Smith". Each pair is scored on how similar it is, and close-enough pairs count as matches.

Do I need an account?

No. No sign-up needed. Match two files of up to 500 data rows each (the header row doesn't count), 2 times in any 24 hours. Your files and results are deleted 1 hour after upload. A free account raises that to 2,500 rows per file and keeps your results for 90 days.

What happens to my data?

The matching tool runs on its own page that loads no ads or trackers. Guest files and results are held only in memory and deleted 1 hour after upload, so download your result before then. They are never written to our database or to disk, and never used to train models.

Which file types work?

CSV, TSV, Excel (.xlsx) and JSON arrays of objects. The first row of a spreadsheet should hold the column names.

How is the match score calculated?

Each pair of columns is compared with a method suited to its contents (names, emails, phone numbers, addresses or free text), then combined using the importance you set for each column. A score of 90% or more usually means the same record.

Got a bigger list?

Plans from $19 a month: files up to 25,000 rows, saved results, no ads.

See plans