Creating 301 Redirects with Excel – FREE Spreadsheet


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.

Creating 301 Redirects with Excel FREE Spreadsheet

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)


Creating 301 Redirects with Excel FREE Spreadsheet


  • Austen Selby

    Awesome post.Thanks for sharing.It was informative.Keep posting