How to Build 301 Redirect Lists

How to Build 301 Redirect Lists

Knowing how to build 301 Redirect lists is an important skill for website redesign specialists. It should be a fundamental consideration in any website SEO redesign project because it is quite common to need to change page file names. Especially so if changing platforms such as in a Weebly or WIX to WordPress migration. That presents a potential (but easily avoided) problem from the search engines perspective.

Why 301 Redirects Are Important

Not providing a site-wide 301 Redirect pathway from all old page names to all new page names means your entire old site will be de-indexed. That’s usually pretty catastrophic on website traffic for at least a few weeks, possibly months!

  • This terminates all rankings for affected pages
  • 404 Page Not Found error rates increase dramatically
  • Search engines are forced to begin indexing and evaluating new pages from zero…
  • All your client’s bookmarks to your site’s internal pages are rendered useless

The tragedy here is that all of this is completely avoidable! A professional NZ web design company will always utilise a solid methodology to eliminate the FUD factors (fear, uncertainty and doubt) from the redirect process. If your website is on an *Apache web server, the procedure is relatively straightforward;

  • list the old pages
  • match them to new pages
  • convert the list to 301 Redirect format
  • copy and paste the list into the .htaccess file in the root directory

NB: any syntax error, white space or hidden characters in the .htaccess file will “break” your site, so its a good idea to be emotionally prepared for hiccups.  Make a backup copy of the .htaccess file before you start!

*If your site is on an IIS server, the process is not at all straightforward, and requires that you have administrator access to the server, unlikely in most hosting accounts…

1. List Your Old Website’s Pages

Before you start rebuilding, make sure you’ve got a full list of every page on your original website. The most efficient way is to build a URL LIST using one of the online sitemap generators. The one I use is;

This site offers you the opportunity to download XML, HTML and TXT files. Download the urllist.txt file.

  • Open Microsoft Excel
  • Import the urllist.txt file
  • Save this as an Excel workbook

In the spreadsheet, use “Search and replace” to remove the section so that you are left with a column of page file names preceded by a forward slash – e.g.; becomes /page-number-one.htm becomes /directory/page-number-one.htm

2. Add the New Page Names

Leave 2 empty columns after the old page name columns. One will be used for a special character, the other as a spacer. Then, enter the new page URL in full beside the relevant old page…

Once you’ve completed the process of building a side-by-side listing of old and new pages, we need to prepare them in the correct format for the .HTACCESS file. Using Columns A through F, the layout is like this;

A=REDIRECT                                  B=OLD NAME               C=$ D=0  F=NEW FULL URL

RedirectMatch permanent ^/directory/page-number-one.htm$

This is where Excel comes into its own…

  • In a column to the left of the list of old page names, copy in “RedirectMatch permanent ^” for each item in the list.
  • In the first column to the right of the list of old page names, copy in the $ character.

3. Combining Fields in Excel

Excel has a command that allows us to concatenate the contents of 3 cells into a new cell.

Excel has another command that allows us to;

  • take the contents of D
  • add the space via the double quotation marks
  • take the new file name URL in column E
  • and insert the new string into column F

=D3&” “&E3  could output the following example;

RedirectMatch permanent^/about.html$

Select the contents of Column F  and paste them into Notepad – the formulas are converted into values via the copy/paste process.

  • save the file as 301-redirects.txt somewhere that you won’t lose it…

4. Applying the 301 Redirects

Copy from 301-redirects.txt to the .htaccess file in the root directory of your live site.

Test it is working correctly by copying an OLD page URL into your browser, and watching to see that it redirects to the specified new page.

Reference: Search Engine Land – create 301 redirect map

Please ask me for an expert website SEO audit or full website redesign quote and get a professional assessment of your needs.

Page last Updated on 1st October 2023 by the author Ben Kemp