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
-
Does "external noopener" still pass on link equity
Just wondering what the consensus WRT "external noopener" passing on link equity?
Link Building | | jasongmcmahon0 -
How to improve domain authority
I'm having a terrible time with one of my sites - it's a new (less than 1 year) business, and I have accounts
Link Building | | chill986
in a number of social media sites including Houzz, but Moz acts like there's only one link to the site. DA is 1.
Ugh. She has pretty good traffic for a small local business, but I'm tearing my hair out over this.
Any suggestions?0 -
Sub domain names will they help with rankings
Hi, i have a site where i want to use sub domains to showcase the different areas in the country that we work, and i was thinking of having a couple of domain names with the city names to showcase the work we do in that city. I would like to know if by having a subdomain name and then linking it back to the main site if this will help me with the rankings for the main site. look forward to hearing from you
Link Building | | ClaireH-1848860 -
Ways to remove spammy backlinks
Hello everyone, I got hit with an algorithm penalty and need to start removing old backlinks ASAP. Does anyone have any good resources on how best to ask webmasters for removal? Are there any other ways to remove bad back links besides the disavow tool? (An SEO consultant I talked to said that they had a proprietary software that can remove them - is that possible?) Thanks all,
Link Building | | CleanEdisonInc1 -
How to add website to Dmoz?
Hello all, i'm a webmaster, i need add my website : http://itvseo.com to dmoz, before i add some website to dmoz but unscuccessfull, please help me thank all
Link Building | | ITVSEO.COM0 -
Which Links to Disavow!
We just took over SEO for a new client who is being penalized for a bad link profile. They've asked Google to reconsider multiple times, and Google still claims that the links are bad. Because of this, and because I don't have direct access (logins, etc.) to what the former SEO did, I am considering using the disavow links tool. The most obvious links to disavow are a group of almost 1000 links that come from the same forum. However, when viewing the links on this forum they actually seem natural. People are reviewing the product (ipod cases), both negatively and positively. While this could have been an SEO tactic for link building, I don't want to disavow these links if they're not the problem, even though this domain is the source of almost all the low-quality links. Another site that has more than 200 links is Askives. Do any of you have experience with links from Askives, or removing these links? Thanks again!
Link Building | | newwhy0 -
Quick way to extract nofollow sites
Hi all Is there a tool available to quickly detemrine nofollow from follow sites as part of a link building campaign? At the moment I am just referring to the source codes of each identified site Cheers
Link Building | | simonsw0 -
What is the best way to transfer a sites link juice.
We have been building a new website for one of our clients which he wants it to replace an existing website which will be taken down shortly. The existing site has a reasonable amount of inbound links and we would like to redirect that link juice to the new website, can anyone tell me what the best way to do this would be. Thanks Fraser
Link Building | | fraserhannah0