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
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
-
Why moz is fetching my backlinks so slow?
Hey, it's been 3 months almost I have launched my website and I have seen that moz is not fetching my backlinks as it should fetch them, after almost 3 month moz has fetched backlink but they are just 2 backlink although my website has more backlinks. Can someone guide me that this is the problem with my website or this is moz own algorithm which takes time? In case you need my website, it is ScanMyKitchen. Kindly some expert review and guide me it is kind of worrying that why my DA and Pa is not increasing and all Thanks yGRBCUL
Link Building | | knownboyu0 -
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 -
Why are my backlinks decreasing slowly from week to week?
I havent made any significant changes, but from week to week I'm seeing my back links slowly decrease (ie.15-17 at a time)
Link Building | | Lexalytics0 -
Backlink question
Hi all. Here's the scenario. There is a company who provide financial services to their online clients. On ALL their clients sites they have a "payments-by-us" style logo with backlink to their homepage domain name. This means they have over 3,000 links from a multitude of non-related websites - with just 3 or 4 anchor text keywords in these backlinks. No surprise they have been hit by Penguin My questions What it the best practice for these type of linking LOGO's. Should they link to a dedicated page,and NOT the homepage? Should they have branded + anchor text, no text, or just branded? or a combination of each Should they even be a link at all as they are coming from such a diverse group of sites? I understand how Penguin penalises for overuse of money word keywords as anchor text. This is something that has definitely happened here (by the bucket load) ... Assume the anchor text is "Green Chips Finance" and that phrase is also overused and a bit "stuffy" in their homepage. Here's my question - could simply lowering the prominence / significance of "Green Chips Finance" on the actual home page, help in reducing the impact of the damage caused by the thousands of backlinks with "Green Chips Finance" as the anchor text? I say this as they have a similar number of back links saying "Red Chips Finance", but there is no mention of "Red Chips Finance" on their homepage other than in the keywords and a couple of standard text mentions (no H1, H2, alt text etc) ... interestingly, "Red Chips Finance" (not the real words) is Google No1 whereas "Green Chips Finance" has been demoted from longtime No1 to about 4. Cheers
Link Building | | BinaryTris0 -
Does this count as a backlink to my category page?
I am ranking high with a certain category page and I am reading that I need backlinks to that page. It is going to be a challenge to get a backlink to that specific category page but how about this? Category page URL: www.mysite.com/category/name Backlink to this URL: www.mysite.com/category/name/specific-blog-post (EDIT: Apparently these types of links don't exist! I went into the category page and clicked on a blog post and it just gave me the www.mysite.com/blah-blah-blah) Will that count as a backlink to the category page? Right now I am only getting backlinks to these blog posts: www.mysite.com/this-is-a-blog-post Any help appreciated! EDIT: Well I guess now my question is worthless. But if you have any input, it would be appreciated.
Link Building | | dealblogger0 -
Ways to remove spammy backlinks
Hello everyone, I got hit with an algorithm penalty and need to start removing old backlinks ASAP. Does anyone have any good resources on how best to ask webmasters for removal? Are there any other ways to remove bad back links besides the disavow tool? (An SEO consultant I talked to said that they had a proprietary software that can remove them - is that possible?) Thanks all,
Link Building | | CleanEdisonInc1 -
Does it help to have more than one backlink from the same website?
I have received two follow links from a website with a domain authority of 64 because I contributed to 2 blog posts. Will it help my site to get more back links from this same website or should I focus my efforts elsewhere?
Link Building | | dealblogger0 -
Backlinks from websites with duplicate content
How does backlinks from websites with duplicate contect affect your rank in search engine? Is there any negative factor?
Link Building | | prunarevic0