Creating 301 Redirects can be a fiddly job, writing out a redirect one by one can take an age – even for an SEO with experience we don’t want to be sat there writing out the redirects. So instead to make the process a little quicker I have created a 301 Generator in Excel, this spreadsheet is to accompany my SEO Checklist for Website Relaunches.
There are a few ways to use this spreadsheet, below is the most basic and helpful use that ANY website owner could use. This 301 generator is not just for those relaunching a website but also those who just need to create a bunch of redirects.

How to use my 301 Generator Spreadsheet

  1. Download the FREE 301 Generator Spreadsheet – Get it here
    or use the link within the SEO Checklist PDF
  2. Enter your Old / Bad Url into Col A (the non-domain part only)
    If you have a spreadsheet such as the “404 list” download from Google Webmaster Tools (diagnostics>crawl errors>404s) or a sitemap in a spreadsheet you can copy and paste these over.
  3. Enter the New URL (url to redirect to, including domain) in Col B
  4. Copy Col D output and Paste to your Htaccess file
    Then save an upload this, and test your redirects fully.
[cta id=”8637″]

create 310 redirects in excel

Some Important Notes:

  • This spreadsheet is only for .htaccess files and not web.config redirects
  • You should Always backup your file .htaccess file before editing
  • You should Always test your redirects (never assume they work)

 

Share:
Written by Andy Kinsey SEO Consultant
For over ten years I have been working with all kinds of clients big and small, start ups to multi-nationals, helping them to make the most of their online assets and ensure they can grow.