FILEHUB ANALYST GUIDES

How can I match messy customer names in Excel?

A sales export might say “Grace Kennedy Ltd” while your master list says “GraceKennedy Limited”. Matching raw names with an exact lookup can leave gaps. The safe solution is a master mapping file with your original name and its verified customer ID.

1. Start with exact IDs

Where possible, use the company’s account number or customer ID. Do not guess that two customers are identical because their names look alike.

2. Use XLOOKUP for approved mappings

If the source identifier is in A2 and your reference sheet has IDs in column A and official names in B, use =XLOOKUP(A2,Map!$A:$A,Map!$B:$B,"Needs review",0).

3. Create an exceptions list

Filter “Needs review” and inspect abbreviations, spelling mistakes, trading names, merged accounts and duplicate keys. Add approved corrections to your mapping table.

4. Map extra attributes at the same time

Once the customer ID is trusted, bring back region, sales rep, customer group and channel from the same reference table. Avoid matching each field independently.

5. Reuse your mapping

FileHub Analyst’s mapping workflow currently lets you upload your reference list, review suggestions and export a mapped workbook. A reusable saved mapping library is a planned addition.

Frequently asked questions

Can fuzzy matching be trusted automatically?

Not for customers or financial reporting. Suggestions need human confirmation.

What if a customer has changed regions?

Use an effective date or period-specific mapping so historical sales are attributed correctly.

Prefer to do this without building the formulas?

Upload your Excel file to FileHub Analyst, select the columns and get a report. If your data needs mapping first, you can review matches before exporting.

Run your numbersClean and match data

More Excel guides: Unique customers · Match names · Sales by region · Sales vs target · SKU mapping · FMCG reports