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
-
Backlinks from missing sites
While combing though spammy backlinks, I'm finding a lot of supposedly "active" links that lead to 404 errors, pages that contain no html, domains for sale, and sites that all have a uniform design which I can't tell if they're web host default pages, or pages using a spammy third-party link aggregator (or both).
Link Building | | rickmic
For example: http://easyreveal.us/ So, do I disavow missing sites? Lost sites? Is there a drawback to disavowing sites that have been removed? Any help would be appreciated.0 -
Why my website dosent count as a backlink for others?
I have some Links in my website that points to other websites, when i took one of this website to see his backlinks, i didn't find mine in that list?
Link Building | | eldon190 -
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 -
How vital is it to get rid of spam links?
We have about 40, between 1-4 flags. Do you see this as a problem? We looked at the disavow feature, but it seems you need to be cautious about using it. Please advise. Thanks!
Link Building | | churchwebsites1 -
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 -
Backlink lag time or not indexed?
I've looked through a few questions relating to backlinks not showing up in Open Site Explorer and I've got the same problem. I want to understand whether my backlinks aren't showing in SEOmoz due to a lag time (some say 5 - 8weeks) or because google hasn't indexed them.
Link Building | | EdoubleD
For example: http://www.marquee-hire-directory.com/oxfordshire_marqueehire_2.html Or http://www.weddingdayangel.com/listings/katalystic-events/ My link is http://www.katalysticevents.com Am I doing something wrong here?0 -
Cant get no satisfaction: Backlink tools leave me frustrated
Bonjour from 7°C Overcast Wetherby Uk, I'm trying to get the backlink profile for a website that will tell me what inner pages are being linked too not just the home page but I'm not having any luck. Ive used Link Diagnosis but that just gives me a total backlink count, no good, I need to know what inner pages are being linked too. I then tried Yahoo Site Explorer but you can only use it know if you give them your mobile tel number for a windows live account, err no thanks! Ive also used the Site Exploerer API here via the dashboard but again no luck again 😞 [IMG]http://i216.photobucket.com/albums/cc53/zymurgy_bucket/confused.jpg[/IMG] So my question is please; "Is there a Tool I can use to see what deeper pages on a site have backlinks" Thanks in advance,
Link Building | | Nightwing
David0 -
Over Optimised Anchor Text
Hi. We are new to the seomoz community so just getting the hange of it. We have run a few reports and found that we have to many links with the eaxct match anchor text. We are as a result we feel penalised and held back at no.7 or lower. There doesn't seem to be any other logical explanations why aren't higher besides that. What would the best way to deal with this over optimisation issue? Thanks
Link Building | | GardenGamer
Shannon0