Fuzzy Match Similar Values in Excel

Match '19.95' with '20.00', or 'John Smith' with 'john smith'. Find duplicates Excel misses.

100% Local Processing

Up to 10M Rows

Instant Results

The Problem

Excel's Remove Duplicates only finds exact matches. Real data is messy - prices differ by cents, names have extra spaces, product codes have different formats. These are the same records, but Excel treats them as different.

Our Solution

Our fuzzy matching catches duplicates Excel misses. Set numeric tolerance (±0.01, ±1, ±10), ignore case and extra spaces, use regex to extract patterns. Match 'Product-123' with 'PROD123' by extracting just the numbers.

Key Features

Features optimized for this use case

Numeric tolerance matching

Case-insensitive comparison

Whitespace normalization

Symbol removal

Regex pattern extraction

Per-column rules

How It Works

Complete data cleaning in three simple steps

Upload Data

Drop your messy Excel file

Set Tolerance

Configure fuzzy matching rules

Review & Export

See matches and download clean data

FAQ

Common questions about this use case

It's the maximum difference between two numbers that should be considered the same. With tolerance 0.1, values 19.95 and 20.00 would match.

Yes! Set regex patterns per column. Extract numbers from one column, ignore case in another.

Yes! Our symbol normalization preserves Chinese, Japanese, and Korean characters while removing punctuation.

Ready to Clean Your Data?

100% free. 100% local. Your data never leaves your browser.