Is there a easy way to take all links from O.S.E and add them to My Google WMT.CSV file?
-
Good morning everyone.
I have recently discovered that someone has targeted me with a negative SEO campaign and I have been inundated with 13,000 anchor text links from spam sites pointing to my domain.
I have run Open Site Explorer and gotten all of my backlinks on my desktop but what I need to do is add them to the back links .csv file from Google Webmaster Tools so that I can upload the file to my CognitiveSEO campaign.
What I would like to know is, does anyone know how to transfer all backlinks from the open site explorer.csv file over to the webmaster tools .csv file in a bulk action without having to copy each link individually?
I don't really have any working knowledge of excell in this capacity for SEO so, If anyone could explain how this would be done I would be eternally grateful because adding one link at a time is very painful and very time consuming.
Thank you.
Cam
-
Never mind, I figured it out
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
-
Internal Equity-Passing Links not getting crawled in Moz Open Site Explorer?
Internal Equity-Passing Links not getting crawled in Moz Open Site Explorer. What is the cause of this? We've checked the robots.txt and htaccess file, but so far we can't find anything that would be blocking Moz from crawling the internal links. We manage loads of other clients on this platform and this is the first time we've run into this issue. What else can I check?
Link Explorer | | OozleMedia0 -
Sudden Spike in 404 Pages Not Found in Moz Crawl But No Errors in WMT
Recently I received a spike in errors from the Moz crawler. When I looked into the matter I noticed that all the URI's looked right but then I looked a little closer and there was a /page/2 and /page/3 in front of the URI's. I'm running a WordPress website. Immediately I thought to myself this must be some kind of caching or permalinks error. So I disabled all my plugins including W3 Total Cache and ran the Integrity Link Crawler for the Mac and found that the errors were still popping up. 404-errors-ncworkercomp.png?dl=0
Link Explorer | | NCCompLawyer0 -
Why does OSE show different link equity for homepage with and without trailing slash?
Hi all, I am working with a developer who believes OSE (Open Site Explorer) is flawed. His reasoning is that OSE shows completely different link equity and domain authority for these two URLs [company name is purposely withheld]: http://www.mydomain.com/us/ and http://www.mydomain.com/us NOTE: http://www.mydomain.com/us has been properly 301-redirecting to http://www.mydomain.com/us/ for years. The developer's argument is that the URL that is being 301-redirected shouldn't have any link equity at all, therefore OSE is flawed. Here is the response I would like to give him. Please feel free to poke holes, provide feedback or flat out correct me if I am wrong: Dear inquisitive developer, Any URL that is being linked to by another site that has link equity will get link equity passed to it. This is true even if the URL is a page that doesn't exist. What it can't do (if it doesn't exist) is then pass that link equity on to another page. Moz's OSE is showing separate link equity for the two versions of this URL because other sites have linked to both versions. The fact that one 301-redirects to the other is good and ensures that link equity from one is passing to the preferred URL. The 301-redirect does not, however, remove link equity from the first URL, but rather passes the existing link equity from one to the other. Consequently, Moz's OSE is not flawed, but rather is displaying the link equity of one URL that is benefiting the other via a 301-redirect. Sincerely, Dana
Link Explorer | | danatanseo3 -
Dofollow link from Moz user profile still not showing in OpenSiteExplorer
Hi everyone! Refering to my last question http://moz.com/community/q/dofollow-link-from-moz-user-profile-not-showing-in-opensiteexplorer, the last update was on March 10 and I'm still searching my dofollow link from my Moz user profile http://moz.com/community/users/625691 after have 200 MozPoints, Opensiteexplorer only found the nofollow link from the icon, but nothing from the anchor text of my URL. Is possible that only take the first link to my blog and ignore the rest if it have the same href? 😞 Thanks! fTdwaO6.png
Link Explorer | | rubenalonsoes1 -
Only one internal Equity Passing Link
Our web site IYBI is reporting only one internal equity passing link. I've somehow never noticed this and now that we are doing a lot more competitor analysis, I'm a little concerned given the numbers some of the other sites in the space are getting. I'm not sure I understand it completely and how it's possible we only have one. Any help would be appreciated.
Link Explorer | | wearehappymedia0 -
Why moz pro detects inexistent links?
I have a campaign in moz pro to my personal webpage for testing purposes and also a bit of learning. But i have a question: On link -> Link analysis i can see this: http://maqui.darkbolt.net/project/chat/index.php 404http://maqui.darkbolt.net/project/docs/index.php 404http://maqui.darkbolt.net/project/down/index.php 404http://maqui.darkbolt.net/project/foto/index.php 404http://maqui.darkbolt.net/project/news/index.php?news=1 404http://maqui.darkbolt.net/project/project/index.php 404http://maqui.darkbolt.net/project/ro/index.php 404http://maqui.darkbolt.net/project/who/index.php 404Obviously all these address doesn't exist. There are links on the page project/index.php linking to, for example, /chat/index.php.How can i resolve this problem on the stats? There's something bad really on the page? As i can see all links on the page are working properly.
Link Explorer | | Er_Maqui0 -
Feedburner Links Showing Up In OSE
I, for years now, have been seeing lots of links from http://feeds.feedburner.com/ showing up very high in backlink profiles. Why is this? And if these links are not passing link juice why are they being reported on in OSE? Seems like there should be some sort of filter for these, or that OSE bot should follow robots.txt directives as googlebot does.
Link Explorer | | MiguelSalcido0 -
Internal Equity Passing Links Showing 0
Hi There. I ran Open Site Explorer on a client's site and it's showing 0 for Internal Equity Passing Links and 0 Total Internal Links. Has anyone seen this before? If anyone knows what might be causing this I'd be very appreciative of the assistance. Thank you!
Link Explorer | | kwaterman0