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
-
Backlinks from local businesses
Hello, I need to make sure I understand this correctly. Will it help my SEO if I: find local businesses with a good DA & low spam score select businesses that are somehow related to mine (Insurance Agency) offer to guest post and include a backlink on their blog ( ask them if they'd like to reciprocate) For example, businesses such as
Link Building | | laurentjb
Roofing companies
Contractors
moving companies
etc Please let me know if there's anything I'm missing? Many thanks0 -
Payday loan backlinks
Dear Friends, I just checked my backlinks in Ahrefs because my traffic has been dropping since the last 4 weeks. I have 2 questions is google penguin a part of Google core algorithm yet like Google panda is? I have backlinks of Payday loans which many webmasters claimed were the problem. The anchor text was payday loans. The sites hardly have any pagerank or anything. What is the way forward for me? So i contact the webmasters, and they dont reply then disavow the links or disavow them directly knowing that google hates pay day loans backlinks
Link Building | | marketing910 -
What is the role of nofollow in SEO backlinking?
I'm checking out my competition on opensiteexplorer, who does quite well for the main keyword. I see that 40% - 60% of the backlinks are ref="nofollow" is there any benefit to such links? if i hire a linkbuilder, should I ever accept nofollow links? can u explain please update 1/18/12 i apologize, i mistyped. i was referring to ref="nofollow"
Link Building | | limens0 -
How do I get quality, relevant backlinks?
Hi, I am trying to improve the SEO our my website which sells mens designer clothes. I know the huge value of backlinks on relevant, high ranking/authoirtive sites. Problem is how do I find these sites? I am currently using twitter, facebook and google to find relevant blogs, websites, forums etc... (ones in the fashion, menswear, designer clothing field) but it is a slow and tedious process. I there any tools, that I can use that find these high ranking sites or is it a case of me searching, searching and requesting to have an article published from blog owners with a link to one of my product pages in etc...? Any help on backlinking and best way to approach would be great. Thanks
Link Building | | WillBlackburn
Will0 -
How Important is Placement of Anchor Text
I'm working on a series of guest posts to help promote a site. These are competitive, high quality posts from a well-respected resource in the industry. I placed the author introduction at the front of the posts, with anchor text for the keywords we are targetting (e.g., "This is a guest post by John Doe, a [keyword] who ... and writes about [keyword]."). I understand that having the anchor text in a prominent location - such as near the front of the post - will probably be more authoritative than a sentence at the very end. My question: how significant is this difference? The blog that I am posting on wants to include author information at the end only and only have one link using the site name (which doesn't contain keywords). The post I sent had two deep links using keyword-rich anchor text, placed at the beginning. I am trying to decide whether to walk away and keep shopping the material around.
Link Building | | Falconberg1 -
Why isnt google picking up my backlinks?
Over the last 2 months, my company has had almost 10 articles placed on very established websites. When I search for my company's backlinks on Google Advance Search, its not picking them up. Why?
Link Building | | BYSM0 -
Finding freshest backlinks
Hi everyone, Thanks in advance for your help, I am doing some competitor analysis and noticed that one of our competitors had a massive spike in the number of baclkinks it received in the past month. Is there a tool or a method I can use to determine what links they have picked up in the last few weeks, by filtering by age of link? Many thanks Al
Link Building | | -Al-0