Discuss One to One Redirects in Excel? in the Search Engine Optimization forum on SEO Chat. One to One Redirects in Excel? Search Engine Optimization forum discussing general tips and tricks to optimize your website for the search engines as a white hat or black hat. Find ideas to fine tune your website for top rankings using keywords, meta tags, SEF, and more.
Our weekly Search Engine newsletter covers the constantly evolving world of search engine optimization like no one else. To stay abreast of all the latestest news, reviews, and how-to's, subscribe today!
BuySellLinks.com is a Text Link Advertising Brokerage by the founder of LinkAdage that specializes in high end quality text links and a controlled membership base. To quickly build inventory we are paying webmasters who add quality domains that we can accepted into our inventory. We also offer free installation.
Tired of dealing with shady text link buyers and/or sellers? Try BuySellLinks.
This month's featured article takes a peek at Google Adsense and teaches you everything you need to know to properly maintain your account and get the most bang for your buck.
Posts: 51
Time spent in forums: 9 h 38 m 57 sec
Reputation Power: 5
One to One Redirects in Excel?
Hello,
I need to redirect thousands of pages and am trying to figure out the most effective way to do it. I was thinking I could cut and paste the xml sitemap into an excel file. Then put the url that I want the old one to redirect to in the cell next to it.
But I wouldn't be able to see what the old url pages look like. And would have to have two browsers open, one for the old urls and one for the new urls.
Any advice on how best to get through tons of redirects?
Posts: 3,973
Time spent in forums: 2 Months 1 Week 1 Day 9 h 49 m 17 sec
Reputation Power: 1240
If the redesign has already gone live, then you could use GWT to get a list of your 404s. This would give you your list of old URLs.
Export this to csv and you've got your spreadsheet started.
Then you'll have to go through the new site finding the new versions, which you put in the second column.
Then run a macro to export the results into a text file. Copy & paste to .htaccess and you're done.
The hardest part is finding the new URLs.... but what could make this easier is if you know which pages were ranking and which were not. Not really a need to redirect pages that weren't really showing up (unless those pages have in-bound links to them.... include these).
Posts: 51
Time spent in forums: 9 h 38 m 57 sec
Reputation Power: 5
I have the old URLs and the new URLs. They probably be gotten from the xml sitemap. I would just run a crawl xml-sitemaps.com after the new site was uploaded and delete the previous pages.
Last edited by tfraser : September 6th, 2010 at 04:28 PM.
Posts: 337
Time spent in forums: 1 Week 4 Days 17 h 58 m 6 sec
Reputation Power: 143
Quote:
Originally Posted by tfraser
Hello,
I need to redirect thousands of pages and am trying to figure out the most effective way to do it. I was thinking I could cut and paste the xml sitemap into an excel file. Then put the url that I want the old one to redirect to in the cell next to it.
But I wouldn't be able to see what the old url pages look like. And would have to have two browsers open, one for the old urls and one for the new urls.
Any advice on how best to get through tons of redirects?
Thanks
Just last month we redirected hundreds of millions pages.
We did it via mod rewrite. Your url must have pretty specific structure , Otherwise its very hard to write code for
there's no 301 rule. URL's get rewritten on the fly. from dynamic to static counterparts
( p.s:we had @ 100 pages indexed last month. Today we have 200,000 & trending upwards. )
We have a kick a*s developer. If you want i can give you his email in PM.
pps: I wouldn't go the excel macros way.
hope this helps.
Best,
-AD
__________________
"Every job is a self-portrait of the person who did it. Autograph your work with Excellence."
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
