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 local businesses
Hello, I need to make sure I understand this correctly. Will it help my SEO if I: find local businesses with a good DA & low spam score select businesses that are somehow related to mine (Insurance Agency) offer to guest post and include a backlink on their blog ( ask them if they'd like to reciprocate) For example, businesses such as
Link Building | | laurentjb
Roofing companies
Contractors
moving companies
etc Please let me know if there's anything I'm missing? Many thanks0 -
DA not increased as backlinks generated...
Hi,
Link Building | | p4pakao
I would like to discuss my issue as my site's some backlinks are generated but DA is still there. Can anyone make me understand the reason?0 -
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 -
Internal Linking Anchor text
Hallo everybody, I am trying to improve internal linking but I am little bit confused about internal linking title. Should I use Kenya all-inclusive accommodation, Kenya full board accommodation etc or I should be using the title without the destination name, all-inclusive accommodation, full board accommodation? My worry is if it will not be too much of Kenya in each title. Any advice what is the best practice? Thank you very much
Link Building | | Rebeca10 -
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 -
Backlinking unclarities.
Hello, I'm trying to get external links from different websites. http://www.meubels.uwpagina.nl/ is one of them. Now what I am wondering is that 95% of the links on that page arent paid links. The paid links are in bold. To get a link for free on that website you need to place a link on your page to that page. This is not alloud by google, and if you do so you will get a penalty. How do all those websites manage to do it? They obviously know it is not alloud, but still they managed somehow to do this without getting penalized. Can someone clarify this for me? Best regards, onlinedesignmeubel.nl
Link Building | | Onlinedesignmeubel0 -
Backlinks that redirect to your site
Hi all, I just wanted to ask you all about backlinks that redirect to your site. I recently used Link Detox Tools to carry out a link analysis. However, some of our backlinks are redirecting to our homepage. Is this ok? Why is this happening? Thanks guys!!!
Link Building | | AAttias0 -
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