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
-
.edu backlinks.. where to point them for a scholarship
Hello, My company offers an annual college scholarship to Women in Business. I have numerous colleges that have agreed to post our scholarship on their college websites. I want to make sure I get the full value of the .edu backlink and need some advice. I have a brand new scholarship page with no authority and that's basically orphaned from the rest of the website. This page details the application process for the scholarship. If I were to link out to my home page, and say 3-4 other top landing pages, would this be the best way to flow some of that link juice into my site? Or is there a better way to do this? Another thought I had was this.... I could take one of my top landing pages, www.example.com/example, and place the scholarship information on that page at the bottom, and have the school link to this: www.example.com/example#scholarship (so the scholarship info appears on top when applicants click it)-- My question here is this... becase the second URL includes an anchor, does google treat that as a different page? Or would the pagerank flow to www.example.com/example ? Recovering from unnatural link warnings and algorthmic penalties and trying to get the best benefit out of the new, quality links I'm building. Any advise would be appreciated! THANKS!
Link Building | | ktrout0 -
How to Index my backlinks?
I create backlinks at everyfay but backlinks not indexed. So, i want to know how to indexed my backlinks?? If you have any free indexed tool then please suggest me as soon as possible.
Link Building | | renukishor0 -
Which number is important for backlinks?
I'm getting very confused. What is the important number regarding backlinks to my site? The Moz number vs. Hubspot grader spits out vastly different numbers. For the particular site I'm trying to improve, I don't have Webmaster Tools installed yet (waiting for webmaster to do as it doesn't have asynchronous code on it). Also apologies for novice question but I remember once being told that offpage SEO and specifically the amount of external backlinks is responsible for 75% of your SERP. Is that still the case?
Link Building | | Bua0 -
Anchor text diversity - post penguin.
Hi, It seems that achor text diversity is hugely important post penguin but what's the best strategy? What kind of anchor text should I be going for? As I understand it more that 60% of links with the keywords in trigger a google flag. For example are the following good examples for the term 'wedding singer'? local wedding singer, best wedding singer, wedding singer website, hire wedding singer. Would these cause triggers in google as all contain the keyword 'wedding singer'? Or should I be going for: click here, visit us, listen now, view a profile Obviously these words don't contain the anchor text 'wedding singer' but with a few exact match #wedding singer' anchor texts and good on page SEO will this mix give better results?
Link Building | | SamCUK0 -
External Anchor text page to target?
I have onpage optimised 4 pages on my website example.com/services/chosenkeyword-1 example.com/services/chosenkeyword-2 example.com/services/chosenkeyword-3 example.com/services/chosenkeyword-4 Should I built links with various anchor text to my home page or the exact internal page as above? Cheers.
Link Building | | Socialdude0 -
Finding sites to target for backlinks
How can I quickly find a list of sites that link with follow and 301 links to my competitor, but not to me?
Link Building | | Nashville0 -
Many competitor's backlinks are in content anchor links. Ho do I get these same links?
Hi I managed to open up OSE. I'm finding that much of the competition's backlinks are in content anchor text links. Am I supposed to get backlinks from these same pages using the same anchor text but linking back to my page or is that allowed? If so, how do I get these in content blog post links? Thanks. Sunil.
Link Building | | sunilmuse0 -
Does getting reblogged on Tumblr offer any positive/powerful backlinks?
This would be under the assumption that our company blog was hosted on tumblr.
Link Building | | twin88850