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
-
Is it worth getting a backlink to a page that will be 301'd?
I have an opportunity to get high value backlinks (from the Emmy's) to a landing page before our new website is live. The backlinks won't be free and they would go live before the website is live. Is it worth spending the money if the landing page will be redirected once the site goes live?
Link Building | | TimThiel0 -
My Backlinks become 404s
if pages linking to my website went deleted (become 404 pages ) ... Do they affect my website in google ranking ? Thank you and sorry for my bad english
Link Building | | simobens0 -
Backlinks embedded in posts or backlinks in sidebar?
What's better? A backlink to my site, embedded into a blog post/article? Or a hardlink in the sidebar? The problem with links embedded inside articles, is that when the blog linking to me, gets updated, the articles disappear from first page and I lose the link from home page. How do you deal with this? I also read this: "The best link you can get is from a site ranking #1 for the keyword you want to rank for. It would be great to have the #1 site for a desired keyword linking me even if they are a PR 0 site." Is this right? Thx in advance.
Link Building | | BloggerGuy0 -
What should be the anchor text in a footer?
For anchor text that is in a footer, should it be a keyword or the domain name www.example.com or Keyword for Example.com? We have a parent company that has other subsidiary companies and they want to have links in the footer that has domain name for link building purposes. But we want them to have keywords in the anchor text instead of the domain name?
Link Building | | cfield_splashmedia.com0 -
Anchor text... How hard should one try?
I'm looking at a lot of competitor's sites, and they only seem to have gone after root domain anchor text in their link-building campaigns. Since I am just launching and am essentially a one-man band (with some hired help), is it worth my while to attempt to optimize individual keywords or pages at this point, or should I just do as they have done, and try to get domain-name links wherever I can? For that matter, should I spend more time going for the low-hanging fruit of followed blog comments, forum posts etc, or emailing influencers to try and get editorial links? Sorry if that last one is a bit broad, and thanks very much in advance for any and all help.
Link Building | | ZakGottlieb710 -
Text Link Ads - have you worked with them?
I work with a large group of community sites and we were approached by a company called Text Link Ads to purchase links on our sites for SEO purposes. This means we can't add "nofollow" and the resulting page is crawl-able. This goes directly against Google's policy but I think it would be tough to find out exactly what we're doing. It could be a great revenue source and this company has many, many sites they work with. That said, this sounds like what you say right before something bad happens. So, two part question: Has anyone worked with this company before? And should these links be avoided or are they not so bad? Thanks in advance!
Link Building | | joshcanhelp1 -
Finding sites to target for backlinks
How can I quickly find a list of sites that link with follow and 301 links to my competitor, but not to me?
Link Building | | Nashville0 -
What are good sites to get no-follow links from?
Yahoo Answers is a good one. What other sites have you guys used to get no-follow links? Blog comments excluded from this.
Link Building | | qlkasdjfw0