In recent years, the nature of SEO has become more and more data-driven, paving the way for innovative trends such as AI or natural language processing.
This has also created opportunities for smart marketers, keen to use everyday tools such as Google Sheets or Excel to automate time-consuming tasks such as redirect mapping.
Thanks to the contribution of Liam White, an SEO colleague of mine always keen on improving efficiency through automation, I started testing and experimenting with the clever Fuzzy Lookup add-in for Excel.
The tool, which allows fuzzy matching of pretty much any set of data, represents a flexible solution for cutting down manual redirects for 404 not-found pages and website migrations.
In this post, we’ll go over the setup instructions and hands-on applications to make the most of the Excel Fuzzy Lookup for SEO.
1. Setting up Excel Fuzzy Lookup
Getting started with Fuzzy Lookup couldn’t be easier — just visit the Fuzzy Lookup download page and install the add-in onto your machine. System requirements are quite basic. However, the tool is specifically designed for Windows users — so no Mac support for the moment.
Unlike the not-exact match with Vlookup (which matches a set of data with the first result), Fuzzy Lookup operates in a more comprehensive way, scanning all the data first, and then providing a fuzzy matching based on a similarity score.
The score itself is easy to grasp, with a score of one being a perfect match, for instance. This score then decreases with the matching accuracy down to a score of zero where there is no match. Regarding this, it’s advisable not to venture below the 0.5 to 0.6 similarity threshold in the settings, as the results are not consistent enough for a site migration or 404 redirects purpose below that limit.
For greater accuracy, it’s also desirable to trim the domain (or staging site equivalent) from the URLs, making sure…
Read More Here