Sitemap.xml change to anchor links (converter)
-
Hi all,
I would like import the sitemap.xml to an anchorlinks list. List with links navigatetion html ^^. Is there a posibility to use a tool or in excel? Because I will use 5000 products and 1000 brands.
-
I think I understand what you are trying to do, but I may be off with the semantics. The xml sitemap (at it's most basic level) is just a centralized list of links for pages that are on your site to help the search engines find pages without having to crawl all of the pages on your site. They do not contain any anchor text in them.
If you are wanting to crawl your site and find out what all your anchor text is internally, I would use a tool like Screaming Frog.
If you are trying to extract information from your sitemap.xml then you would need to use a combination of a text editor and excel. Say your URL structure includes product and brand information and you have all the URLs in a sitemap. You can pull that document into a text editor and then use the "Find and replace" function to get rid of all the extraneous code and then you can be left with just the URLs on one line. You can then use the excel function "Text to columns" to then split out the URL into sections based on slashes or dashes. If you have Screaming Frog, it will extract all the URLs for you and then you can split out the info in excel as well. Use Google to find examples of how to run the tools mentioned above in detail.
If I am totally off, please give a more detailed explanation of what you are trying to do and that will help as well.
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
-
Are links from charities really better than 'normal' links.
Hi Guys. Just wondering about this idea that links from Charities are particularly good. I've heard people say that links from .org sites are particularly strong. But anyone can get a .org domain, it's just that charities tend to use them more often. Right? I just don't get the logic. Can anyone give more detail about this? Is it a myth? Is there quality info on this topic I can check out? We're working with several charities at the moment, and they all seem happy to blog and link to us...so I just wanted to know a little more. Isaac.
Link Building | | isaac6630 -
Links from my Own Blog to my Own Website and Link Scheme
Hi There, I use my own blog to give advices and offer information related to my business service. Of course in terms of SEO my blog is useful not only to expand my brand presence but also to acquire long-tail traffic. I use to insert a maximum of one link with a relative matching anchor text in every article of my blog pointing to my own webpage. Said that, the questions are as follows: Am I involuntarily participating in a Link Scheme with my blog? And If so, how many links can I send to my own webpage ? Shall I limit the number of links to a minimum? Thanks a lot for your advices.
Link Building | | Midleton0 -
What is a healthy ratio of keywords being used as anchor text in external links to our site?
Hi, One keyword is being used as anchor text in way more external links to our site than any others and I'm getting a lot of mixed advice whether or not to do anything about it. The agency we previously used had managed to remove about 1500 links (out of 6000) however our rank for that search term is still very poor. **We have 4500 external links with the anchor text "ABC" and the next highest amount of external link anchor text is the term "XYZ" which has about 400 links. That is over 10 to 1. What is a healthy ratio of anchor text between different search terms to aim for? ** Any help is greatly appreciated. Thanks!
Link Building | | Syed_Raza0 -
If i get link pointing to a specific page , will that link add up to the count of linking root domains too ?
If I create a fresh link pointing to specific page on my site, apart from adding a number to "page linking root domains" does it also add up to root domain linking ?
Link Building | | Techbate1 -
What are inbound links worth after Panda and Penguin, since a site ranks for the NATIONAL keyword "outdoor furniture" with ONLY 7 INBOUND LINKS!?!?
ARE INBOUND LINKS TODAY ALMOST WORTHLESS??!!? After having been the KING of SEO, down to the toilet? Today I got a great sample from a fellow SEO professional showing a site, rockymountainfurniture.com rank for "outdoor furniture" with ONLY 7 INBOUND LINKS FROM 3 DOMAINS and a domain trust of 14!!!! ON A NATIONAL, VALUABLE, HIGH QUERY VOLUME KEYWORD!! I was stunned, but is this the "NEW SEO WORLD" we live in, so we should skip spending hundreds of hours on link building? There are over 32 different types of inbound links but this is much MORE than a radical change, this is turning SEO as it was up-side-down. Any input, thoughts, ideas?
Link Building | | yvonneq0 -
Generic Anchor Vs Branded Anchor?
Hi, I have always been very careful when building links, making sure that I use lots of variations relevant to my site in the anchor text, so keep the ratio diluted. However, in recent weeks I have stumbled on some SEO's focussing wholly around branded anchor terms for future link building, I feel that a branded focussed link profile looks more natural. I'm interested to know what the rest of Moz community think about this? Thanks
Link Building | | dt18070 -
Anchor text
Hi there, I am looking at creating some back links into my website using guest blogging, be it product reviews, competitions or writing the post myself. I had a look at my competitors back link profile, all I can say is that they all look artificial (paid for) the article itself reads well, however when I see something like this: 'If you house got burgled and you never had home insurance in place, you could lose thousands of pounds of household goods' It just looks paid for, the question is if I am placing a guest post on a blog, what is best practice in making the link look more natural? Thank you
Link Building | | Paul780 -
So I ran into a site that was not ranking 4 days ago and has over 2 million links to it on some keywords. My guess is this is a link bomb, but the issue is this is pushing one of my sites down. Does anyone know a good way to over come a bomb like this?
So I ran http://www.riogrande.com/ into this site not that long ago and wanted to see if any other SEO's have an opinion on it. I've seen a Google bomb before, but the amount of links going into this URL is insane. The thing is how does one over come a Google Bomb? Do you just wait to see what Google does or do you just hope to rank under that URL? I should also note that it appears that all the keywords to it are relevant to the sites content. Let me know your thoughts. Thanks
Link Building | | kateG12980