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
-
Reciprocal Backlinks
Hi all, We've just started looking into backlinks for our website, and we're...a bit overwhelmed to say at least. We thought the best way to start with backlinks is to reach out to our industry partners, and ask them to put a link to our website on theirs (in a blog, or a relevant page of course), as it's relevant for users. However, the question we almost always get is, can you do the same and link back to our website? How does google look at reciprocal links? We think they can be seen as a 'transaction of links' and not have as much link juice as links which aren't reciprocal. Is there any best practice for how to approach this? Thank you in advance. Diana
Link Building | | dianacatrinoi0 -
How do we identify poor backlink sites
We are often being preached to not get backlinks to dodgy or spammy sites but how do we identify these sites?
Link Building | | dynamyt1000 -
Backlink Disavow strategy
Hi, I would like to know what are the things to check when Disavow backlinks? Should we disavow all the low PR and DA backlinks ex: disavow all the backlinks under 4PR? Thanks alot !
Link Building | | bigrat950 -
How long it takes to see backlink ?
We are promoting a law related website and I have posted a blog as a guest on a Law related blog which has PR 3 and Alexa Ranking 171.. It's been 3 weeks but when i run a backlink report from OpenExplorer or other tools that i use, i cannot see the link coming through at all. There is no no follow attached. I'd like to continue to post more articles on the same website but i need to make sure i am getting good links from it otherwise i will go somewhere else. However, i need to understand why do i not get links from that blog as it is very reputable and good blog. I appreciate if you can advise please? Thanks!
Link Building | | Rubix0 -
Press Releases as Backlinking
After analyzing one of my competitors I notices they show up in PRweb as one of their top rated back linking sites. My question is using prweb or something similar okay to use for backlinking? Would they help at all? Also, since they distribute content, would I get penalized for duplicate content?
Link Building | | floridaoutdoorsrv0 -
Bulk BackLink Chcecker
Does anyone know of a good bulk backlink checker? I want to input a list of URL's (1,000's) at a time and check to see if their are any external backlinks.
Link Building | | WEB-IRS0 -
Backlinks In Blogs
Hello! A direct competitor of my has a ton of backlinks exact anchor text on their inner pages coming from blogger blogs. How can they get away with this? Are they using different C blocks? Or are they paying for these links? The anchor text is Not anywhere in any of the blogs but it the side/bar colomn which follow through the entire site, so when I analyze the link anchor text OSE show ups several different pages from the same blog. Any help would be Greatly Appreciated!!!!! Thanks
Link Building | | TP_Marketing0 -
Did I over optimize on my desired Anchor Text?
I have been promoting a site using mostly the same 3 versions of anchor text. 1. Do I really need to get non related anchor texts to balance my linking profile? e.g. [http://site.com], [click here] and [non related keywords].
Link Building | | ClassifiedsKing
2. What should the ratio be between related and non related anchor text be?0