UseCase Solution

Match Values with Explicit Rules

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

100% Local Processing

Large File Ready

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

Set numeric tolerance, ignore case or edge whitespace, ignore symbols, or use regex to extract a stable identifier. The tool does not infer spelling similarity.

Key Features

Features optimized for this use case

Numeric tolerance matching

Case-insensitive comparison

Edge-whitespace comparison

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 tolerance and comparison 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. The optional symbol comparison rule preserves Chinese, Japanese, and Korean characters while ignoring punctuation for matching only.

Ready to Clean Your Data?

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