This guide walks you through using Flookup in Google Sheets to build an accurate redirect map.
Mapping URLs for Site Migrations and 404s
Whether you are moving to a new domain or cleaning up broken links, you must accurately match old URLs to their new counterparts. An incorrect redirect map can lead to lost traffic and a poor user experience.
The 80/20 Rule of Redirect Mapping says that 80% of a site's organic traffic flows through just 20% of its URLs. Prioritising these high-value pages in your redirect map catches the majority of traffic risk before it happens.
A Step-by-step Flookup Workflow for Your Redirect Map
- Prepare Your Data: In a new Google Sheet, paste your old URLs into Column A e.g. from a site crawl or Google Search Console's 404 report and your new URLs into Column B.
- Clean and Normalise URLs: To ensure the most accurate match, isolate the meaningful parts of your URLs. Use the Text Standardisation function to extract just the path from each URL. This removes protocol and domain noise.
- Perform the Fuzzy Match: Now, match the cleaned old paths to the cleaned new paths using the Fuzzy Match function. Select your cleaned old paths as the source and your cleaned new paths as the lookup range. Set the similarity threshold to 80 per cent.
-
Retrieve the Full New URL:
The previous step gives you the matched *path*. To get the full, final URL for your redirect map, use a standard `VLOOKUP`. This finds the matched path from column E in your cleaned new path list (Column D) and returns the corresponding original full URL from Column B.
=VLOOKUP(E2, D:B, 2, FALSE) -
Review and Export:
You now have your original old URLs in Column A and their best-matched new URLs in Column F. Manually review this list for accuracy. Once satisfied, you have a clean, two-column redirect map ready to be implemented in your
.htaccessfile or server configuration.
Protecting Your SEO Value during Migration
Whether you are a researcher cleaning complex datasets or an SEO professional managing a critical site migration, Flookup provides a powerful, integrated solution within Google Sheets.
These capabilities, from fuzzy matching to robust data normalisation, are designed to protect your site's data quality while saving time and reducing manual errors.
By bringing these powerful features into the familiar, collaborative environment of Google Sheets, Flookup streamlines complex workflows. It helps you protect hard-earned SEO value and ensures a higher standard of data integrity. For any professional looking to master their data without leaving your spreadsheet, Flookup is the clear choice for efficient, scalable and automated data management.
Frequently Asked Questions
How can Google Sheets help with SEO site migration?
Google Sheets provides a convenient platform to manage URL mapping, redirect lists, 404 tracking and content inventory during a site migration. With add-ons such as Flookup, you can fuzzy-match old and new URLs, identify broken links and standardise large datasets without leaving the spreadsheet environment.
What is URL mapping and why is it important?
URL mapping is the process of creating a correspondence between old website URLs and their new equivalents after a migration or redesign. Proper mapping preserves link equity, ensures users land on the correct pages and prevents 404 errors that damage both user experience and search rankings.
Can Flookup help with 404 detection after migration?
Yes. Flookup can cross-reference your list of old URLs against your new sitemap to identify broken links. Its fuzzy matching capabilities are particularly useful when URLs have changed structure or naming conventions, allowing you to map legacy URLs to their closest equivalents in the new site architecture.