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
-
Blog post outreach for backlinks
Hi all, My understanding of obtaining backlinks by way of blogpost outreach is that it's best to include several outbound links to related high domain websites within blog post copy (as well as a link to the website you're marketing, obviously) such as this post https://www.scoopearth.com/why-should-you-use-royalty-free-music-for-youtube-videos/ or this one https://small-bizsense.com/how-to-create-quality-content-for-your-business/. However, I've recently read a few articles that suggest that from a human perspective only having one clear link in the copy, such as this post https://www.clichemag.com/entertainment/movies/the-benefits-of-royalty-free-cinematic-music-for-your-videos/, increases the chance of the reader visiting the site in question. I guess the thinking is that if there's only one link to be clicked on it increases the chances of click-thru, as opposed to the reader possibly clicking on another external link that's only there because of current SEO advice. So is it best to follow SEO guidelines and include several outbound links within guest blog posts, or is it better to only have the one link to your client's site (to focus the readers attention on it)?
Link Building | | JCN-SBWD0 -
What about a No-record backlink in the eye of Google
I have an uncertainty - when I make a backlink as a piece of SEO in some site when I reviewed similar couple of days after. It hasn't filed and I checked its robots record. It appearing Client specialist: Mediapartners-Google Disallow: User-Agent: * Disallow: However, is this make any backlink uphold or only this with the end goal of not ordering in google. I make it straightforward - "Is this sort of backlink creation my site Best Offset Smokers uphold my SEO action or Not?" In this No-record site. Flag Share
Link Building | | seotools1030 -
How do I get rid of sites that backlink with lots of irrelevant or spammy links to our website?
This site http://herwigphoto.com/bs/ and other like it have thousands of similar links containing the word adidas We are not in the sports shoes business, therefore the links are irrelevant and many and can hurt our rankings, correct? | Page Title/URL of Linking Page | Link Anchor Text | Page Authority | Domain Authority |
Link Building | | Madlena
| Christopher Herwig Photographer » Soviet Bus Stopshttp://herwigphoto.com/bs/ | adidas Yeezy Boost 750 Grey For Sale | 48 | 47 | Below are some links to our geographics.com website that have URLs that are not ours. They will redirect to our homepage. How do we remove these links and how do we deal with the websites that send such links to us? There are thousands of inbound links to our website with anchor text containing irrelevant keywords such as these: yeezy-750-boost-light-grey-cheap or adidas-yeezy-boost-750-light-grey-sale; pirate black sale, etc Page Title/URL of Linking Page Page Authority LRDs Total External Links HTTP Status http://www.geographics.com/new/yeezy-750-boost-light-grey-cheap.html 46 120 1800 -- http://www.geographics.com/new/yeezy-350-pirate-black-sale.html 44 106 1829 -- http://www.geographics.com/new/yeezy-750-boost-gum-brown-sale.html 42 114 181 -- --- --- --- ---0 -
Minimum Page Rank to get a link
Is there a minimum Page Rank that we have to be aware of when looking to get a link from a webpage?
Link Building | | echo10 -
How many backlinks on start up?
How many backlinks would you say is too many on a start up site. Assume about 300 visitors driven to the site via adwords.
Link Building | | JML11790 -
Penalized by SEO Link Wheelers Backlinks
Just over a year ago, I've bought 4 link building packages from SEO Link Wheelers. From what I see now, most of their website network has been penalized / banned and now it's hurting my websites. I've tried to contact them but they won't reply. I'd be willing to pay to have them remove the links but they simply won't answer. And I haven't been rude or impolite at all in my communications with them. I've tried calling them to but to no avail. I know where most of the bad links are, thanks to linkresearchtools.com Now I gotta get rid of that crap. Any suggestions?
Link Building | | sbrault740 -
About to get my competition domain, how what I can do?
Hello, I'm trying to get a domain from what it used to be my main competition, if I get this domain can I forward the domain to my website? because they have good local ranking that I don't have and also a lot of links. I don't really want to use that brand name, I just want to take advantage of the links they already created if that possible. Or can I do something else with the domain or just buy it and keep it so nobody else can buy it? Thank you
Link Building | | jpgprinting0 -
Building backlinks for a newspaper site?
Anyone have tips on building links to a newspaper site? I am looking for a strategy to create links to a news site beyond building one link at a time. We have so much content that is constantly updated that it would be impossible to do this one page at a time.
Link Building | | BostonWright0