Is there a way to easily add "domain:" in front of an entire list of domains you want to disavow?
-
I'm submitting some disavow reports for clients. As most of you likely know you can either disavow a URL or a domain. So, to disavow a url, you would enter into the text file:
http://www.example.com/this_page.html
and to disavow the entire domain you would enter:
domain:example.com
I find that in most cases you would want to disavow the domain. For example, if there is a backlink on www.exampledirectory.com/health/page24/, by the time Google goes to disavow that link it may be on page 25.
However, it is super time consuming to take my list of urls from a spreadsheet and type, "domain:" in front and also remove the http://www.
Is there a way this can be done programatically?
-
Great! I'll let you know how it works out. It'll be a couple of days before I'm done the current link audit so I'll report back after that.
-
Aw, thanks. Hopefully I can figure this out. But if not, I'll be in touch.
-
You should be able to use the concatenate formula in the same way except I am not sure if the $ will behave in the same way. Try it and see
-
I'm on a Mac as well Marie but have MS Excel so can't help you on the others I'm afraid.
However, if you get stuck, you are more than welcome to mail me the spreadsheet and I will do the find and replace for you, then mail it back again.
Andy
-
Thanks so much Andy and James! I really should invest some time in learning more about spreadsheets!
I work from a Mac...do you know if I can do the same thing either on Google Docs or on Numbers?
-
Hi Marie,
Quite easily actually...
In MS Excel, all you have to do is move your list of domains to column B and in column A enter domain: once say in this case in cell A2
Then in column C enter this formula =CONCATENATE($A$2,B2)
You should then be able to drag down in the usual way to replicate the formula. It will retain the A2 cell but change B each time and you'll get a list of domain:http://exampledomain.com in column C.
Andy (above) has explained how to do the other part of your question.
Let me know if you have any problems.
All the best,
James
-
Just do a find and replace in Excel...
Find http://www
Replace with domain:
Then hit "replace all" - It will go off and do them all for you.
Andy
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Do you disavow all the links on the WhatsApp Gold site?
Do you disavow all the links on the WhatsApp Gold site? https://www.watsabgold.com/
Link Building | | JackBarrie0 -
Does Yext Directory Listings Help with Links?
Question: Does Yext Directory Listings Help with Links? They have 53 directories and I am trying to find out if this service is going to help building our links?
Link Building | | Tim_Jacquet0 -
Does using "pring2web" hurt SEO?
I've never really seen this before but one of my clients has 4000+ links from Print2Web. Their rankings are falling back a bit but I'm wondering if this is part of the problem. They don't seem to say their service is about SEO so I'm not so sure this is counted as spam or not. The main concern is that the next closest number of links from one site is only 97. Has anyone heard of this service? Can someone tell me from experience if using this service has hurt SEO efforts? Thanks!
Link Building | | BenRWoodard1 -
Disavow Link Tool from Bing Webmaster Tools
Okay - anyone else read about the new tool release from Bing especially the disavow tool? Very cool - id love to hear some chatter on what you guys think! Link:
Link Building | | kchandler
http://www.bing.com/community/site_blogs/b/webmaster/archive/2012/06/27/disavow-links-you-don-t-trust.aspx Here is to hoping Google will follow suit! Cheers - Kyle0 -
Linking to root domain or index page
While link building, should I link to index page of my website i.e www.mydomainname.com/index.html or should I link to root domain i.e www.mydomainname,com Also I see duplicate title error for index page and root domain in error statistic. How can I get rid of this.
Link Building | | ArtiKalra0 -
What is the best way to find high domain authority
Hi Guys, Can you anyone tell me please the best way to find high domain authority websites? I heard this is the best way to build links? Thanks Gareth
Link Building | | GAZ090 -
100 One-Way .EDU Backlinks $30?
I've seen so many of these type of advertising on forums. Do you think it's safe (i.t.o search engine rankiings) to buy or not?
Link Building | | Springboks0