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
-
Are Sidebar Backlinks worth for SEO?
Hello! Let's use the following example: I have a blog (let's call it Blog A) and I find another blog in the same niche (this will be Blog B) that has higher DA and PA than mine. Will Google penalize me if the Blog B puts a link to my blog in their sidebar? Remember, the Blog A and Blog B are from the same niche. I ask this because Google says that links on sidebars appears in every page and in some pages the link may be useless. But if both blogs are from the same niche, there won't be pages where the links will be from different themes and with less relevance. So, is my thought correct: we can use sidebar links without caring about penalization ONLY if the blogs are from the same niche? Thanks in advance!
Link Building | | btqkelvin0 -
A lot of backlinks from outside of niche – bad?
We have received a lot of backlinks over the years by users putting links on their websites to their home pages on our site, eg: our.domain/user1 our.domain/user2 … our.domain/user100000 There are 10’s of thousands of these backlinks, all natural, but many of them come from blogs that are completely outside of our niche. Only a small percentage of our backlinks 1% to 5% could actually be coming from pages related to our niche, the other 95%+ could be users just linking to their home pages. Could this really hurt us..? We have 1000’s of backlinks related to our niche, yet we’ve noticed that some competitors with less than 50 backlinks can outrank us for certain keywords.. Also related, we’ve noticed these user links popping up on a lot of spammy sites, directories, etc. We didn’t create them but we’re disavowing them now to be safe. So this could also be hitting our rankings.
Link Building | | dsumter0 -
I have a real estate site. I want to beat Zillo and Trulia for local real estate searches. Any suggestions and also how do I get white hat backlinks( not just write great content stuff but good alternative ideas).
I need some tips on outranking giants in the real estate field for local search keywords. I need sources of back link sources (white hat) and some ideas to beat them in my backyard with my Real estate site. I have a great idx plugin and am ranking first page for address searches. I want to beat them for local long tail. Any ideas?
Link Building | | kpstreams0 -
Too much backlinks [Penalized]
Hello, I purchased a backlink service and I think the most of them were spam sites and sites like that. I am lossing Organic traffic, Im sure that my site is penalized, how long will last it?Can I do something? Thank you
Link Building | | matiw0 -
Individual keyword pages or single page with backlinks and anchor text?
Hi, I was wondering which is the better strategy? People say the keyword dig is the basis for any SEO strategy, which i totally agree with, however, traditionally the strategy for these keywords has been to write fresh content based on sometimes very similar keywords / terms to attract specific keywords traffic... With google getting smarter and smarter, would you say it is safer (if you know you have a very tight and stable backlinking strategy) to backlink a page that has a number of your similar keywords present, with the relevant anchor text on the inbound sites? So in essence the site ranks for multiple keywords..? I hope this makes sense, it's a very difficult one to get out onto paper! 🙂 Many thanks in advance!
Link Building | | turnips
Turnips0 -
Daily backlinks
Hi whats the number of backlinks i can create a day, for each keyword that i want to rank for, some say 5-10 or 20-30, other say there is no limited, if you create quality backlnks i know its not about quantity but quality ,but really whats a best answer? Thanks
Link Building | | xverticle0 -
Does getting reblogged on Tumblr offer any positive/powerful backlinks?
This would be under the assumption that our company blog was hosted on tumblr.
Link Building | | twin88850