How to make 301 redirections using excel – 301 redirections excel creator for SEO

All SEOs who are non-coders have been through this stage where they recommend to their clients to 301 (permanently) redirect their old URLs to the new ones.

Most likely these URLs are dysfunctional, they are not search engine-friendly or user-friendly. Let’s not forget that by doing a proper 301 redirect, almost 90% to 99% of the link equity is passed to the new URL.

Additionally, -I guess- less SEOs have been into the situation where the client asks from them to provide the list of the old and the new URLs so that they provide this list to their developers. Obviously the developers will generate the code.

Now, even less SEOs had to face a situation where the client asks them to provide the code, so that the developers to simply implement the code. Now, this is where things can get a bit tricky. However, this is where EXCEL can come to the rescue.

Without any further ado the code that I am providing in this case concerns website that use Apache server. For our case study, what we need to do is to make a 301 from a single page URL to another:

Redirect 301 /old-page.php http://www.abc.com/new-page/

However imagine having 1000 URLs for which you need to do the same job. With EXCEL we can automate the process by using a relatively simple formula (from cell 2 to cell 7):

=A2 & ” ” & B2 & ” ” & C2

3___screenshot

The second function we can use, can come up through the use of CONCATENATE (from cell 8 to cell 10):

=CONCATENATE(A8 & ” ” & B8 & ” ” & C8)

4_screenshot

In both cases the formula is generated in column D and all you need to is drag and drop the cells and that’s it.

Bonus SEO tip: Don’t forget that the source URL should be a relative and the destination URL should be absolute.

If you want to download the excel 301 redirection creator (.xls) , please feel free to do so.

Until next time, happy analysing.

Also read...

Leave a Reply

Your email address will not be published. Required fields are marked *