How to get a plain text instead of csv output for backlink analyzer?
-
The link analyzer looks really great, I'm using it now to do some reverse engineering and it is seemingly able to give me far more than just the 1k limit we can get from yahoo site. But it spits out the results to a csv file which just has everything bunched up into a bunch of gibberish.
Is there a way to get a plain text file so its readable/usable? Or how to convert or view the csv file properly?
Thanks
-
Thanks I will give that a try.But it seems silly it is designed like this, very user unfriendly to have to jump thru so many hoops to get a plain list of the target urls that I want.
-
What about removing the unneeded columns while you have it in the spreadsheet, then save as html? You can then open that up in the browser and everything is hyperlinked. Or dump it into Word then save that as html.
This will be about the only time in my life I ever recommend using Word to save as html, but it should do for your purposes here.
-
Thanks,yes I am able to view them in a better format now that I'm not trying to load them into a plain notepad file. My related question now is, how are we supposed to get a plain list of all these urls in a practical manner? I mean it's great to have all the pr, anchor text, etc etc etc all listed next to each one, but frankly I just want a plain list of JUST the urls for me to be able to actually use. I've tried a link extractor and didnt work and no way I'm copy pasting thousands of urls
Ideas? How do you gets get a practical working list without all the extras?
-
hey justin -
try importing it into microsoft excel or google docs spreadsheet, that should make it quite a bit more readable. if that doesn't work you may be able to export it from one of those 2 programs in a more readable format. :>)
thanksdan
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
-
Web 2.0 Backlinks
Hi Normal Web 2.0 websites like Wordpress.com, blogger.com have very High DA and PA. But when we create a subdomain, DA and PA falls to 1 as Google treats subdomain as new websites. Does it make any sense then to get backlinks from web 2.0 websites? will it help in Google rankings?
Link Building | | aliasgarbabat1234567890 -
Backlinks with high DA but PA1
Whenever we get new backlinks, its always on a PA 1 page, does this pass a lot of link juice as long as the DA is high? I know the PA can go up by promoting the page, but i rather promote my own website than one page linking to my site. Any thoughts on this?
Link Building | | MozVpn0 -
Domain and page backlinks
Hello Everyone, I am new at SEO, and I am a bit confused with the following situation: I have domain, wordpress site on it, and I am building backlinks to it (testing). I do not have "home" page among pages in wordpress, if it means anything. When I build links, i use different anchor texts, but they all point to http://somethingsomething.net -Ahrefs shows that I have 830 backlinks from 45 domains, to my URL, which is http://somethingsomething.net (it is also my site's home page address) -MOZ;s Open site explorer, on the other hand, shows the following: 8 internal links and 0 external links for page specific metrics, and 878 total links 0 external for root domain metrics. -Google Webmaster tools shows 10 external links pointing to my site Please can someone explain to me what is happening here? Thanks a lot
Link Building | | ShivFriv770 -
What is the best way to go about building backlinks?
I'm a newbie here and my head is spinning because I don't know where or how to start the backlink building process. My website is 1 month old and I don't have any backlinks yet. what is the best way to go about it? Should I study my competition's backlinks and go from there? I'm so confused I need help! Please help! Any information will be greatly appreciated!!
Link Building | | allie741 -
A backlinks question
Hi all Could do with a second opinion on this one if anyone has a moment please. Recent Google updates have targeted overally optimised backlink profiles as they are clearly for seo purposes and not natural. The question I have is how does this relate to an ecommerce website? If I sell 'blue 1980 aged cheese' (I know nothing about cheese so perhaps not the best example!!) and I have a url on my shop domain.com/store/blue-1980-aged-cheese with the product name as the page title along with the domain name. If I were to get backlinks pointing to this page using the anchor of 'blue 1980 aged cheese' (and other variations of that, blue cheese, aged blue cheese etc) would this be considered to be too optimised? Given the page is about this item then surely it could be considered natural that people link using the product name, as well as using the site name and the domain url Any thoughts please Thanks, Carl
Link Building | | GrumpyCarl0 -
What is the best way to obtain backlinks?
Im tryin to obtain backlinks to my website...what is the best way to accomplish this?
Link Building | | juniorbeagle0 -
What is the best pinging service for my backlinks?
I am looking for a good pinging service that indexes my backlinks fast. After doing some research I found linklicious, backlinksindexer and pingfarm among others. My quesiton: do those services still work and if yes, which one is the best one out there at the moment. Thanks for the help.
Link Building | | Romaine0 -
Effectiveness of Forum Backlinks: specifically Paul's Backlinks
I know the general consensus is that these kinds of backlinks are of low value, however I'm curious as to anyones present day experience with them and if they are providing any value. More specifically, I am curious if they can do harm. I don't see how they could, as it would be a very easy tactic for an unscrupulous competitor to sabotage another by implementing them for their competitors. I can see possibly losing rank if they were discounted, however if this is the case, then it would only be rank that would not have been gained in the first place, minus those kinds of links. I ask because I have competing websites who have started to outrank me (they have been climbing and improving through each Google algorithm change in the past year), despite the fact that my mosrank and authority are better than every single one of them. But they have a sheer growing volume of backlinks that I can't match (seemingly low value when I look at their link profiles). Plus my domain is older (9 years as opposed to 3-4 years), and my site is clearly better (in terms of aesthetics, usability, content, etc), as well as my link profile being selectively cultivated from truly relevant sites. None the less, they are starting to kill me at this point -and I don't have the luxury of time. So....I was wondering about the wisdom of upping my volume of forum type links, as this is the only area of measurement where I can see my competitors are beating me. I am a believer in true, difficult, quality inbound marketing - however it is not getting the job done. Any thoughts on this?
Link Building | | csblev0