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
-
One or multiple backlinks from business profiles?
Hi, When building diverse backlinks to a website it's often possible to place one, or several, links in the business profile on a directory or social platform such as https://www.broadjam.com/Scambler, https://coub.com/scamblermusic, https://issuu.com/scamblermusic or https://soundcloud.com/scambler. Typically I would only add one backlink to these profiles (and that would be to the home page) but I often wonder if I should take the opportunity to add several links to internal pages and blog posts. Am I missing an opportunity to add more backlinks and spread out the link juice, or could multiple backlinks within short profiles be considered spammy? Any advice would be helpful. Thanks.
Link Building | | JCN-SBWD1 -
Backlinks niche specific or high DA?
Hello Moz Community,I have sports niche website. I am in process of link building for my website. One query in my mind. Which backlink is better for increasing my MOZ DA and domain authority in terms of google domain authority.1: Profile backlink of DA50+ website , not belonging to my sports niche.2:DA 10 or DA 20+ link belonging to my sports niche.Which out of these will help gain better MOZ DA.ThanksRakesh
Link Building | | T4FS0 -
Should backlink URLs include www, https, or both???
My business is located at remotebaba.com, and I am wanting several sites to link to it.
Link Building | | udaipabla
I am only interested in home page at this point, and we are using HTTPS for our site. Which one of these should I have other sites link to (Please provide complete justification):
remotebaba.com (my root domain)
www.remotebaba.com
https://remotebaba.com
https://www.remotebaba.com I really appreciate your help!1 -
Alt text from an external site
We have a relevant external website that is linking to our site through an image. What ideally should the alt text of this image be? Should it just be non-commercial as generally advised with the anchor text of an external link? Or should it include where suitable relevant keywords? Keen to know people's thoughts here! Thanks.
Link Building | | Gavo0 -
Should I get comment removed?
I left a comment on a site's blog post maybe 2 months or so ago. Yes, that blog has DoFollow comments on. It turns out that site uses one of those sidebar featured comment widgets, and has a crazy amount of duplicate pages due to an unruly wordpress install, pagination and attachments indexed. Well, I checked my google analytics recently and it shows that I'm getting 652 links from that site. Ahh.. Should I ask the blogger to remove my comment? Or should I let it go, and wait until google reindexes that site? My links don't technically show on all those pages anymore because since that time, the blogger has gotten more comments that are now featured instead of mine.
Link Building | | studio35design0 -
Logistics of getting links removed
I recently got an unnatural links penalty notice from Google. Well, at least it's the type where they say they're only penalizing the links, and not the site. I've noticed lots of links from low-quality sites in my Webmaster Tools, and have been wondering why my site hasn't been ranking better since it abruptly dropped off around October 22, 2012 (I know, that's a very long time ago – I've been neglecting the site for other parts of my business). I'm hoping that if I make an earnest attempt to get these links removed, disavow the others, and submit a reconsideration request, my rankings may improve. So my question is this: How, logistically, do you go about getting all of these links removed? I mean, technically I get it: go through all of the links, try to contact all of those webmasters, keep records of all correspondence, and share that with Google. But how? Are there special tools and services for this? Are there contractors you recommend? I have other things I'd rather worry about in my business than undoing these unauthorized links.
Link Building | | kadavy0 -
About to get my competition domain, how what I can do?
Hello, I'm trying to get a domain from what it used to be my main competition, if I get this domain can I forward the domain to my website? because they have good local ranking that I don't have and also a lot of links. I don't really want to use that brand name, I just want to take advantage of the links they already created if that possible. Or can I do something else with the domain or just buy it and keep it so nobody else can buy it? Thank you
Link Building | | jpgprinting0