Fuzzy Match (Fuzzy VLOOKUP)

Match names that are spelled slightly differently between two lists, with a similarity score for every match.

๐Ÿ”’ Runs in your browserโšก Instant results๐Ÿ‘ค No sign-upโญ Downloads with Pro

1. List to match

For example your messy supplier names or a list someone sent you.

โ€ฆor paste a list

2. Master list

The clean list to match against, for example your customer or supplier database.

โ€ฆor paste a list

Match names that are almost the same

VLOOKUP only finds exact matches, so "ABC Ltd", "A.B.C. Limited" and "abc limited" never line up. Fuzzy matching compares names the way a person would, giving each pair a similarity score, so you can match supplier lists, customer databases, CRM exports and bank statements in minutes.

The scores use the same similarity measures as the widely used rapidfuzz library (ratio, token sort and token set), and are checked against it.

Frequently asked questions

What score should I use?

80% is a good starting point. Use 90% or more when wrong matches are costly, for example payments. Always check "Possible match" rows by eye.

How many names can it handle?

Tens of thousands. It narrows each name down to likely candidates first, so it stays quick.

Is my data uploaded?

No. Matching runs inside your browser and nothing is sent to our servers.

More data analysis & spreadsheet tools

๐Ÿ“Š
Excel Data AnalyserInstant KPI dashboard, insights, report & slides
๐Ÿ“ˆ
Instant DashboardPower BI style dashboard from any Excel file
๐Ÿ”
CSV โ†” Excel ConverterConvert CSV, XLSX, XLS, ODS and JSON
๐Ÿงฉ
Excel File MergerCombine many spreadsheets into one
๐Ÿงน
Duplicate RemoverFind and delete duplicate rows
๐Ÿ“ˆ
Chart MakerPaste data, get a chart, download PNG or PowerPoint
๐Ÿ—„๏ธ
Excel to SQLCREATE TABLE & INSERT statements from any spreadsheet
๐Ÿงฎ
SQL Query BuilderBuild SQL with clicks, explained in English, run on your data
โœจ
SQL FormatterMake messy SQL clean and readable
๐Ÿงฝ
Data CleanerFix spaces, capitals, text numbers, dates, blanks and duplicates
๐Ÿ”—
VLOOKUP / Merge Two SheetsMatch two files on a shared column, no formulas
๐Ÿ†š
Compare Two Excel FilesSee added, removed and changed rows and cells
๐ŸงŠ
Pivot Table BuilderGroup, total and chart your data with clicks
๐ŸŒ
Web Table to ExcelCopy tables from websites into clean Excel
๐Ÿ”ฃ
JSON โ†” Excel ConverterFlatten JSON into a spreadsheet, or Excel into JSON
๐Ÿ“
UK Postcode Lookup (Bulk)Add council, region and lat/long to postcodes
๐Ÿ”„
Unpivot / Reshape DataColumns to rows and back, ready for Power BI
๐ŸŽฏ
Outlier FinderSpot unusual values, typos and errors
๐Ÿ“
Statistics CalculatorMean, SD, correlation, t-test, chi-square explained
๐ŸŽฒ
Random Sample PickerRandom rows for audits, surveys and prize draws
๐Ÿง 
DAX Measure GeneratorYTD, YoY %, rank and % of total for Power BI
๐Ÿ“…
Date Table GeneratorPower BI / Excel calendar with UK bank holidays
๐Ÿงฉ
Excel Formula BuilderXLOOKUP, SUMIFS, IF and more in plain English
โš™๏ธ
Power Query SnippetsCopy-paste M code to clean and reshape data
๐Ÿ—„๏ธ
SQL PlaygroundRun SQL queries and JOINs on Excel & CSV files
๐Ÿ˜
Large CSV ViewerOpen & filter CSVs with millions of rows
โœ‚๏ธ
Split Excel by ColumnOne sheet or file per region, rep or month
๐Ÿ”—
Fuzzy Match (Fuzzy VLOOKUP)Match similar names between two lists
๐Ÿ›ก๏ธ
Data AnonymiserMask, hash or code personal data for GDPR
๐Ÿ“‡
Extract Emails, Phones & PostcodesPull contact details out of any text or file
๐Ÿ”ฎ
Forecast & RegressionSales forecast and what drives your numbers
๐Ÿ‘‘
RFM Customer SegmentsFind champions, loyal and at-risk customers
๐Ÿ“Š
Cohort RetentionHow many customers come back month by month
๐Ÿ…ฐ๏ธ
ABC / Pareto AnalysisThe 20% of products that make 80% of sales
โš–๏ธ
A/B Test CalculatorIs version B really better? p-value and sample size
๐Ÿงช
Test Data GeneratorRealistic fake UK data for testing and demos

See all 123 tools โ†’