100% Free & Secure

Excel Fuzzy Lookup Tool

Match similar text to fix typos and inconsistencies between two tables using Levenshtein distance.

Primary File
The main dataset you want to enrich with new data.
Lookup File (Optional)
If you are matching within the same workbook, leave this empty.

Share this tool

Did this work well?

Why Use Our Fuzzy Lookup Tool?

Clean messy data quickly and securely.

Smart Matching

Matches "Jon Doe" with "John Doe" automatically. Perfect for cleaning messy CRM or email lists.

Lightning Fast

High-performance algorithms process your spreadsheets locally in your browser.

100% Private

Your data never leaves your device. We do not upload your files to any servers.

Online Fuzzy Lookup Tool - Clean Data Easily

Real-world data is messy. You might have "Apple Inc" in one file and "Apple Incorporated" in another. Our Fuzzy Lookup Tool solves this by matching text that is similar, but not exactly identical.

What is Fuzzy Matching?

Unlike a standard VLOOKUP that requires an exact character-for-character match, fuzzy matching calculates the "distance" between two strings (how many edits it takes to turn one into the other). If they are close enough based on your threshold, they match.

Terminology

Similarity Threshold

The minimum percentage of similarity required for a match to be considered valid.

Levenshtein Distance

The mathematical algorithm we use under the hood to calculate similarity.

How Does It Work?

  1. Upload Files: Upload your main dataset and your lookup dataset.
  2. Map Columns: Select the column containing the messy text (e.g. Company Name) and the column you want to return.
  3. Set Threshold: Adjust the similarity threshold slider. A threshold of 80% will catch minor typos, while 60% will catch major misspellings.
  4. Process & Download: Run the fuzzy lookup entirely in your browser and download the cleaned, merged spreadsheet.

Why Use Our Tool?

  • No complex Excel Add-ins to install
  • Process thousands of rows in seconds
  • 100% private - your confidential data is never uploaded to any server
  • Fine-tune the matching sensitivity in real-time

Frequently Asked Questions

Common questions about fuzzy matching

What happens if there are multiple similar matches?

The tool will evaluate all possibilities and return the match with the highest similarity score that exceeds your threshold.

Is my data secure?

Yes. The Levenshtein algorithm runs in a Web Worker directly inside your browser. Your files never leave your device.

What is a good similarity threshold?

Typically, 80% is a great starting point for catching minor typos. If your data is very messy, try lowering it to 65% or 70%.

Our Free Excel & PDF Tools

Everything you need to manage, convert, and transform your spreadsheet files — all free, all private.

Excel File Merger

Merge multiple Excel files (XLS, XLSX, CSV) into one with smart column matching and conflict resolution.

Merge Files

PDF to Excel Converter

Extract tables and data from PDF documents into clean, editable Excel spreadsheets instantly.

Convert PDF

Excel Splitter

Split large Excel files into smaller pieces by rows, sheets, columns, formulas, and more.

Split Files

Excel to JSON Converter

Instantly convert Excel (XLS, XLSX) and CSV files to clean, formatted JSON. Features advanced options for nested structures, custom object arrays, and optimized output.

Convert to JSON

Mail Merge

Generate bulk personalized documents from Excel data using simple {{Tags}}. Download as a ZIP archive instantly.

Generate Documents

Image to Excel (OCR)

Extract text and tables from images using OCR technology. Convert photos and screenshots to Excel spreadsheets.

Convert Images →

JSON to Excel Converter

Convert JSON data into clean, structured Excel spreadsheets. Supports nested objects, arrays, and auto-type detection.

Convert JSON →

Compare Excel Files

Compare two Excel files side by side and instantly see cell-by-cell differences, added rows, and removed rows.

Compare Files

Excel to CSV Converter

Convert Excel files (XLS, XLSX) to CSV format instantly. 100% private client-side processing with no ad-heavy interruptions.

Convert to CSV

Remove Duplicates

Easily find and remove duplicate rows in your Excel files. Select specific columns to check and instantly download the cleaned file.

Remove Duplicates

Encrypt Excel File

Password-protect your sensitive Excel (XLSX) files. 100% private client-side encryption.

Encrypt File

Unlock Excel File

Remove password protection from encrypted Excel files instantly. 100% private local processing.

Unlock File

Compress Excel

Reduce the file size of large Excel workbooks (XLSX, XLS) without losing data or formatting.

Compress File

CSV to Excel Converter

Convert CSV, TSV, and delimited text files into formatted Excel spreadsheets with smart delimiter detection.

Convert CSV →