Use Excel Power Query Fuzzy Matching for Corporate Names
Question details
The user needs to match variations of corporate names to standardized names across more than 36,000 records.

- 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.
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.
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.
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.
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.
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.
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.
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.

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.

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.




