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
-
SEO traffic + backlinks question
Let's say I want to write a guest post for a website that is relevant to my website. Should i guest post on a website with high traffic but the traffic country is not mine? (eg// My website sells products in Canada only, should i guest post on a high traffic site from India?) Or would it be better to find a lower traffic website to guest post on but their organic traffic comes from Canada? Thanks!
Link Building | | chrisjordan0i10 -
Tooltip text
Will adding tooltip text to al my links improve my rankings? I read some article, but it's a hell of a job to add tooltip text to al my links. i was wondering if it's worth the time: A tooltip text appears if the mouse hovers over the image or a link and is provided by using the TITLE attribute. A description of the image or the link then appears in the tooltip in a small yellow box (Internet Explorer). The TITLE text (tooltip text) gives a short description of a link or image. The difference between an ALT text and the TITLE text is that the ALT text is a short description that replaces the image if the image does not load. The number of links (internal and external) and images must be equal to the number of tooltips for every page. The number of TITLE text can be higher because ALT text can also be used for other HTML elements. Add Title texts to links or images for those which do not have them yet. Thanks!
Link Building | | Happy-SEO3 -
Backlinks from the Same Domain (But Different Pages)
Wayyy back when (in the days of yore) Mr Cutts spelled out in a video that page rank is distributed equally between the external links on the page. If there are two links on a page, each gets passed 50% of the available page rank etc. (Perhaps an oversimplification but bear with me). As a result of this, the company I worked for at the time (this was the dark ages when sidebar homepage links were in vogue) decreed that we would only ever approach a site about a link for a client once, as additional links had little extra SEO Value. Now you could argue that if there are 5 external links, each acquiring 20% of the power, and your site has 2 of those, you are getting 40% of the power, but lets forget the basic math for a minute. I have scoured the web and Mr Cutts' videos and I cannot find the answer to my question: If my site (Site A) has a backlink from SiteB Page 1, and a backlink from SiteB page 2 - does this count as two separate links in the eyes of Google? If the SAME site links out to my site, linking to different pages in different posts, does this give me more SEO benefit? Thanks for your time!
Link Building | | Turkey0 -
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 -
Video Backlinks
This looks like an interesting idea from Wistia. Anyone have comments or experience with this? http://wistia.com/blog/video-backlinks Best,
Link Building | | ChristopherGlaeser
Christopher1 -
Backlinks on an older domain which is now 301
Hi What is the best way to see what backlinks one of my domains has pointing at it? It is an older domain and is no longer being used for marketing purposes and has a 301 redirect on it. However when looking at this older domain in opensiteexplorer it does not show what the links are because it redirects to the newer domain name
Link Building | | ocelot0 -
Ideas for structuring contest to get links?
Hi Mozzers, So I'm getting all set to run a contest. The prizes are great and I've developed a good way to promote it via paid and natural venues. I'm just not sure how to structure the actual contest so the end result is more links than mentions. One idea I had was to make this a story telling contest where the contestant blogs about a good/bad experience within the niche industry and adds a link back to us to enter. Does this seem like to much effort for the user? Prices are worth about $250 each, and I plan to have 3 winners. Any ideas on how to better gear this towards link building is appreciated. Thanks!
Link Building | | ErikDster0 -
Should we BackLink to Guest Post ?
Hi, I have been actively doing guest blogging for last few weeks . But the page authority , moz Rank and moz Trust of my guest posts appear 0 as those posts have their own pages on blogs with snippets of posts on home page. I wanted to ask if i should backlink to my guest posts to increase the authority, mR and mT of pages. Those posts are already appearing as backlinks in webmaster tools but if i backlink to my posts to increase mR and mT, then will it also increase the juice passed by backlinks in those posts to landing pages on my site ? Thanks,
Link Building | | shaz_lhr0