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
-
DA not increased as backlinks generated...
Hi,
Link Building | | p4pakao
I would like to discuss my issue as my site's some backlinks are generated but DA is still there. Can anyone make me understand the reason?0 -
Would you get a backlink from a site that doesn't have many ranking keywords?
I been seeing some sites that have 0 ranking keywords but a DA 40 and 0% spam score, would you guys get a link from one of these sites?
Link Building | | arango200 -
How to do LinkBuilding in 2015 without getting affected?
Hello. My name is Palla Sridhar. from India. small time blogger. I have a SEO site which recently had 12 pv/day. I recently did 2 guest posts on 2 sites. On 1 site, I included link to my site's article in the content and author bio. In another I just did it in author bio. After that my traffic dropped to 4 pv/day. Is there any official guide from Moz, on how to do link-building? Is the above process of doing link-building correct? How to do it without getting our traffic affected in the long run and short run?
Link Building | | karri20250 -
Adding Quality Backlinks
Without sounding like an idiot, what are the best ways in adding good quality back links. There are websites out there such as Click Submit but from experience they just link from weird URL's and the links are in comments. In an ideal world starting up my own Blogs and building up a good domain authority would work best but the customer would like some back links adding by next week. Using local directories wouldn't really work for their business so if anyone has any idea's I would love to hear them.
Link Building | | chrissmithps0 -
Backlinks from Open Site Explorer not updated
Hi folks! I was checking the backlink profile for my website - wishpicker.com - we got linked to by a large number of prominent websites in the last couple of months. For some reason, this does not seem to show up when I do a backlink search on OSE. Is there something that I need to do here/ fix? Thanks in advance!
Link Building | | AB_Newbie0 -
Getting links to a blog post
Hi, What is the best way to get a "good quality" link to my blog posts? Thanks
Link Building | | Studio330 -
Should you ever change your anchor text ?
Hello I have a question about anchors. I have done all my own seo over the last 3 years, with tools from various sites. I had an seo audit done about 1 month ago and was told my link profile was very natural. They had one recommendation. To go back over my link profile and ask some webmasters if they would change the anchor from the name of my site or my url to a more seo friendly phrase. This seemed logical. I never did a lot of anchor text just name or site or url. Anyway, over last 4 weeks I have messaged several webmasters and asked to have anchor text changed to something along the lines of the keywords Im targeting. Tedious task to go through all the links but I changed several anchors to what was recommended. I was also out link building at same time. These last links and I got several of them all natural links after 16 hours work days. Are all will seo friendly anchors, because as Ive gotten more experienced my links have gotten more in lines of what is "seo friendly" or at least I hoped. I asked one webmaster to change my anchor and he warned me I would be slapped with a penguin penalty and wouldn't recommend I do this. I have already done this to several of my links. Then today the new seomoz update came up and I was down on DA and PA by 3-4 points. Do these have anything to do with one another and have I been given bad advice and can I fix it if I have ? Sorry about long post just a little confused. I don't want to step into penalty land and not know I did.
Link Building | | New1000ad0