Power Query Problems

Use Excel Power Query Fuzzy Matching for Corporate Names

Muhammad TalhaMuhammad Talha Nov 22, 2026 868 views

Question details

The user needs to match variations of corporate names to standardized names across more than 36,000 records.

Use Excel Power Query Fuzzy Matching for Corporate Names
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
Incoming customer records need to be matched to a reference list and refreshed each month.
Observed behavior
Ordinary formulas and approximate lookups cannot reliably identify the correct company without reference data.
Before you start

Prepare a reference table with known name variations and their approved corporate names, and make sure each variation maps to the intended company. Check that your Excel version offers Power Query fuzzy merge.

Solution 1Recommended

Match name variations with a Power Query fuzzy merge

Use a master mapping table to standardize a large list of corporate names and repeat the process when new records arrive.

Fuzzy matching compares incoming names with entries in your reference table; it does not determine the correct company without reference data. Similar names can belong to different companies, so review uncertain results before approving them.

1
Create the mapping table

In Excel, create a table with columns such as Name Variation and Standard Corporate Name. Add known variations, such as J.C. Penney and JC Penney, alongside the approved standard name, then select the range and choose Insert > Table.

2
Load both tables

Format the incoming records as a table using Insert > Table. Select each table in turn and choose Data > From Table/Range to load it into Power Query.

3
Merge the name columns

In Power Query Editor, select the incoming-records query and choose Home > Merge Queries. Select the mapping table, choose the incoming corporate-name column and the Name Variation column, and enable Use fuzzy matching to perform the merge.

4
Adjust and review matches

Open the fuzzy matching options in the Merge dialog to adjust the similarity threshold as needed. Complete the merge, use the expand button on the new column to add Standard Corporate Name, and filter the results to inspect unmatched or questionable names.

5
Update and refresh

Add reviewed name variations to the Excel mapping table, then choose Data > Refresh All to rerun the queries. For the next monthly batch, update the source table and refresh again.

Match name variations with a Power Query fuzzy merge
Check ambiguous matches: A fuzzy match is a suggestion, not proof of identity. Review close matches and check for duplicate output rows when a source name matches multiple reference entries.
Free Microsoft Office alternative

Review Corporate Name Lists with WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility. Open existing Excel workbooks to review and maintain name lists as you migrate your everyday spreadsheet work. Excel's Power Query fuzzy merge must be performed in a version of Excel that supports it.

Review and maintain corporate-name mapping tables in a familiar spreadsheet interfaceOpen and edit Microsoft Excel XLSX and XLS filesUse a free, lightweight Office alternative for everyday spreadsheet workContinue working with existing Office documents during migration
QA img-9

Frequently Asked Questions

Can fuzzy matching identify a company without a reference list?

No. Power Query compares each incoming name with values in a reference table. Create a mapping table of known variations and approved corporate names before merging.

Where is fuzzy matching in Excel Power Query?

In Power Query Editor, choose Home > Merge Queries, select the two name columns, and enable Use fuzzy matching in the Merge dialog. Availability depends on your Excel version.

What should I do with names that do not match?

Filter the expanded standard-name column for blanks, research the unmatched names, and add approved variations to the mapping table. Then choose Data > Refresh All.

How do I reduce incorrect fuzzy matches?

In the Merge dialog, open the fuzzy matching options and adjust the similarity threshold. Review similar company names manually, because a higher threshold alone cannot guarantee a correct match.

Can I reuse the matching process each month?

Yes. Update the incoming source table and the master mapping table as needed, then select Data > Refresh All to rerun the Power Query merge.