Capabilities

Configurable similarity thresholds per input list
Cluster review pane with keep / merge / split controls
Reference crosswalk flagging canonical matches against orphans
Handles lists up to several hundred thousand rows
Color-coded output showing confidence, action taken, and provenance
Clean mapping table suitable for feeding back into your system of record

Works on any name list

Vendor masters. Customer lists. Entity registries. Any dataset where the same real-world thing shows up under different strings. The matching engine does not care what the records represent. It cares about the shape of the variation.

Why it exists

Standard Excel =COUNTIF and pivot-table workflows break down once a name list grows past a few thousand rows with organic variation. Commercial master-data-management products cost tens of thousands per year and assume you have a data governance team. The Vendor Normalization Engine sits between those extremes. You get cluster-grade matching inside the Excel your analysts already open.

Full documentation (click to expand)

The user manual covers: installation, input file setup, similarity threshold tuning, the cluster review workflow, reference crosswalk configuration, and output format. It also includes a troubleshooting section for the common input file issues.

Read it here: VNE User Manual.

Need something similar?

Every dedup job has its own rules. Names, addresses, product SKUs, account numbers. Send a sample file and the current manual process. Quote comes back same day.

Describe your problem

Related services

This tool is part of the record matching service. For broader data cleanup work beyond name matching, see the Excel VBA development service.