What a migration redirect map is
A migration redirect map is a spreadsheet with one row per legacy URL, columns for the old URL, the new URL on Squarespace, the redirect type (direct, wildcard, external, drop), and notes. It is the source of truth for the URL Mappings paste at launch. It is also the audit artifact a year later when an old URL shows up in Search Console as soft-404 — you can look back at the row and see whether the destination is wrong or the redirect never made it into the panel.
Crawl the old site — the source list
You cannot map URLs you do not know about. The crawl step enumerates every URL on the legacy site. Two methods work: Screaming Frog as a desktop crawler (free for up to 500 URLs, paid above) or the legacy site's existing sitemap.xml if it has one. For sites where both exist, run both and merge — sitemaps frequently miss URLs that the live site still serves, and crawls miss URLs that are only linked from external sites.
Decide every destination
Every row gets one of four decisions. Direct: a one-to-one redirect to a specific new URL. Wildcard: a path prefix that absorbs many URLs at once. External: the destination is on a different domain (booking platform, payment processor, third-party blog). Drop: the URL has no destination because the content has been deleted and removing it is intentional. Drop is also where the 410-vs-redirect call happens — some dropped URLs should return 410 Gone rather than redirect to the homepage.
The map schema
Four core columns and two derived columns. Old URL is the source. New URL is the destination (or DROP or wildcard pattern). Type is one of direct/wildcard/external/drop. Notes is for human context. Derived: traffic_rank (computed from GA4 sessions) and squarespace_rule (computed from a concatenation formula). The traffic_rank column is the audit lever — sort descending and you have the URLs that must redirect cleanly, in priority order.
The pre-launch sign-off
Before the new site ships, the map needs three sign-offs. Engineering: every Squarespace rule passes syntax validation locally (no duplicate sources, no missing destinations, all arrows correct). Marketing or owner: every top-100 traffic URL has a confirmed destination — no defaults to homepage. Content: any DROP row is intentional, and the team is comfortable losing whatever traffic that URL had. Without all three, the map is incomplete and the rollout risks the 404 gap Google penalises.
Roll out the redirects
At launch — typically the moment DNS swings from the old host to Squarespace — paste the map into Settings > Advanced > URL Mappings in batches of 200-500. Save between batches. Submit the new sitemap to Google Search Console immediately. Then monitor for 4-12 weeks: Search Console Pages report should show old URLs categorised as 'Page with redirect' and new URLs as 'Indexed'. If old URLs show up as 'Crawled — currently not indexed', the redirect is working but the new URL needs more authority signals (internal links, sitemap inclusion) before Google fully replaces it.