How to clean similar textual data in Excel via Fuzzy lookup add-in?

In this post, we would see how to get started with Fuzzy look-up add-in for excel.

First up, Which problem does Fuzzy Lookup add-in for excel solve? It cleans similar (a.k.a matching) textual data in Excel. E.g. “Mr Paras Doshi”, “Doshi Paras”, “Paras A Doshi” are similar and may refer to the same person – Fuzzy look-up helps you detect such similar textual data. This add-in is really handy if you are “combining” data from different systems where the data is not in the same format – using this add-in you can detect similar looking text and clean the data-set at hand. With that, Here are the steps to download, install and play with this add-in:

1) Download “Fuzzy Lookup add-in for Excel. Read: Over view, system requirements and Instructions

URL: http://www.microsoft.com/en-us/download/details.aspx?id=15011 

(If this doesn’t work – search for “Fuzzy lookup add in for excel”

2) Note the sample excel file called “Portfolio” that comes with the download files. We’ll open it after the Successful installation of the add-in:

1 excel 2010 sample excel file to play with fuzzy lookup

3)Install it.

I left the default on all dialog boxes.

4) Open the sample file: “portfolio

5) Click on Install if you see a dialog box “Microsoft Office customization folder”

(please read the message in the dialog box too)

6) Can you see Fuzzy Lookup in Excel Toolbar? Yes? Great!

7) Now if you have opened the Portfolio file then you’ll see a tutorial on how to get started on the worksheet named portfolio:

3 excel 2010 tutorial to play with fuzzy lookup

8) follow the above tutorial to get started. I just did!

2 excel 2010 tutorial to play with fuzzy lookup output

Conclusion:

In this post, we saw how Fuzzy Lookup add-in for excel 2010 help you find matching text from two data sources. I hope that helps.

 

2 thoughts on “How to clean similar textual data in Excel via Fuzzy lookup add-in?

  1. Pingback: Guest Blog: How we use Fuzzy Lookup add-in in our company to solve data inconsistency problems: | Paras Doshi – Blog

  2. Pingback: How to create a MDS entity via Excel add-in? | Paras Doshi – Blog

Thank this author by sharing the article on social media. If you have any questions or comments, please leave a reply below:

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s