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
-
Which site is gonna get most of the link juice?
site: a has PA of 25 , DA of 30 and has 1000 external links. site:b has PA of 5 , DA of 30 and has 5 external links i already know that high PA and DA matters but please explains in terms of those external links mentioned above, because i have heard if a page has a lot of ext links, the link juice will be given to all the external sites , ultimately juice will be divided.
Link Building | | calvinkj0 -
Site scraped/Backlink problem?
Hi - I was looking in my Google webmaster tools because we saw a huge jump in backlinks last week. We found this one article with 84,475 total links, which obviously stands out as spam. All the links are from 1 page and 1 domain (financeai.com). This is the article on our website - http://loyalty360.org/resources/article/engaging-customer-atmosphere-at-pizza-patron and webmaster tools says all the links back to it come from this page http://financeai.com/forex/mxn/pkr/q/39665 My question is - should we/what can we do to clean this up? How does this impact our search ranking? We have had some issues with our website getting extremely slow overnight, and we believe the site scraping is really slowing down the site at points. Thanks.
Link Building | | carlystemmer1 -
Clean up over optimised backlink profile
A little while back a whole heap (around 5000) of exact match anchor text links showed up in my GWT profile. Now over time quite a few of them have dropped away, but according to Remoovem I've still got a 73% link percentage score for this particular anchor text (which is my main keyword), along with a 55% root percentage. Obviously this is a Bad Thing. What would be the best way to combat this over optimised profile?
Link Building | | schitz011
Disavow the links? Leave them be and work on more exact match links? When I look at some links listed in GWT, I can't find the link to my page anywhere in the source code. Can I ignore those domains or should they also go into a removal program? I've not received any manual penalty or notice in GWT, though I did see a drop of traffic last year around the early may 'Phantom' update. From which the site has never really recovered.0 -
I have a real estate site. I want to beat Zillo and Trulia for local real estate searches. Any suggestions and also how do I get white hat backlinks( not just write great content stuff but good alternative ideas).
I need some tips on outranking giants in the real estate field for local search keywords. I need sources of back link sources (white hat) and some ideas to beat them in my backyard with my Real estate site. I have a great idx plugin and am ranking first page for address searches. I want to beat them for local long tail. Any ideas?
Link Building | | kpstreams0 -
Backlinks outside my country
Hi there! If the product, service or resouce I offer is located in my country: Is it worth to include directories located in p.e EEUU in order to increase my Pagerank although this is not my potencial client (due to the "distance" obviouly).? If my potencial clients were people fromo other countries that could come to mine to enjoy this service? Should I include my links in directories of these countries and obtain links from websites of these countries? many thanks
Link Building | | juanmiguelcr0 -
Backlink Lists
I am trying to create a valid list of backlink domain to disavow after a 50% traffic cut by Penguin......problem is I have now pulled lists from 4 tool and the lists are all different. I find a toxic domain from the tool run on LinkResearchTools and look on Google and Site Explorer and the toxic link does not even show. I look at the page and sure enough the link from year ago on a link farm is there. Is there really a rue definitive tool that will give me a list of all links? Better yet is there a tool that will help me evaluate which domain to disavow ? I want to follow Dr. Pete's advice and go slow but I am also anxious to cut ties with SEO work done by someone else in the hay day of link farm SEO and frankly looking at resent links some Bad SEO by competitors.
Link Building | | freestone0 -
Frustrated with spammy backlinks from competitors
I've only been doing SEO for my company for the last month and I've made some headway but what is really frustrating me right now is a couple of competitors that have OBVIOUS spammy links ranking in the number 1,2,3 stops all over the board for the keywords i'm going for. One competitor in particular has anchor text links EVERYWHERE that make absolutely no sense...junk like... "I have never been more saddened by anything in my life than when my grandfather got cancer. I told my uncle he needed to buy some auto insurance. I really like pork." I mean, these links are the pages with the most page authority and page rank out of all of the ones they have...and I'd venture to say that almost all of their backlinks are like this...well, half of them are just random links with good anchor text on the sidebar of a bazillion spam websites (diapers, toys, fake blogs, etc.)...while i have about 3k links and most of my top competitors have about 5k links...these guys have over 33k. Worse yet, when I look at something like Alexa rank, they have pretty high overall traffic rank but it shows traffic rank in MX (mexico) instead of the US...these guys only sell in the US! I mean, they're black hat if I've ever seen such a thing and they rank superbly on all keywords. What can I do to compete with this junk?
Link Building | | jgower0 -
Ever Get disillusioned with SEO
Many times now we have pushed certain keywords for homepage listings but we have found the traffic levels to be very poor and many cases first page listings turn out to be vanity. The frustrating thing is that sometimes we have to tell some of our SEO customers that in order to get a good market share for there industry they will always have to do google adwords. What are your thoughts on this . Thanks
Link Building | | onlinemediadirect0