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
-
Backlinking and Redirect links
Can anyone properly explain that whats the basic differnce between redirects? and backlinks? my site lottery sambad is getting some 301 redirects, is that good or bad??
Link Building | | Mubashir_Baloch0 -
Why my website is not getting rank?
I can understand my website age is a big issue but now I want you to help me. I have been doing guest posts for increasing the domain authority but no good result. I just want you to let me what should I do next? AmazeInvent
Link Building | | alexmurphy11220 -
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 -
I know its a silly question. but how do i get the best backlinks.
I am new to seo. Every where i see seo people are talking about nearly all the links are bad. I have read everything but cant seem to figure out how to get good backlinks. And what kind of backlinks will actually help my site. I used blackhat stuff in past that really made my life miserable. if you know what i mean. can someone guide me personaly 😛 . (kidding) i know you guys are very busy . but if you could may be tell me which direction to go , it will put a smile on my face.
Link Building | | samafaq0 -
Website/blog list to get quality backlinks?
Hi Everyone says quality backlinks increase ranking of your website. Can you please suggest a list of good websites and blogs from where I can get quality backlinks and how to do that. I have one person at my disposal full time to do manual commenting or any manual tasks for getting backlinks but how should i approach this problem (of getting backlinks). Where do I start. For information, my website provides online services (its an ecommerce site) and also has a blog in subdirectory. refer to www.geekwik.com www.geekwik.com/blog Would like to become top ranker on search for these services (eg 'logo design services', 'website programming', 'content writing', 'hire virtual assistant' etc) Also anyone interested to become our SEO consultant or SEO service provider (of course paid) is most welcome 🙂 Thanks in Advance!
Link Building | | geekwik0 -
How many backlinks on start up?
How many backlinks would you say is too many on a start up site. Assume about 300 visitors driven to the site via adwords.
Link Building | | JML11790 -
Anchor text... How hard should one try?
I'm looking at a lot of competitor's sites, and they only seem to have gone after root domain anchor text in their link-building campaigns. Since I am just launching and am essentially a one-man band (with some hired help), is it worth my while to attempt to optimize individual keywords or pages at this point, or should I just do as they have done, and try to get domain-name links wherever I can? For that matter, should I spend more time going for the low-hanging fruit of followed blog comments, forum posts etc, or emailing influencers to try and get editorial links? Sorry if that last one is a bit broad, and thanks very much in advance for any and all help.
Link Building | | ZakGottlieb710 -
Paul and Angela Style Backlinks
Do Forum Profile Links provided by Paul and Angela hold any SEO merit ? Will it help in improving SER?
Link Building | | krishrun0