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
-
Links
Hi, im wondering if links that is not exact anchor links gives any boost for rankings? Example if lets say somebody links to my site http://domain.com/category/article with anchor: domainname or url link.
Link Building | | Rob_I0 -
Linking to press coverage, reciprocal links?
We have been generating decent online press coverage with links to our site thanks to our PR agency and I have been asked to link to the online coverage from our website in a 'press coverage' section. My question is would google consider links from our site to the online press coverage as reciprocal links? Thanks
Link Building | | gavinr
Gavin0 -
Domain Change, loss of inbound links ...
We're strongly considering a domain name change; this is purely for marketing reasons. We think in the long term, this will be a good thing. I believe we can mitigate the page redirection, branding changes, etc. My concern are the inbound links: from 200+ domains, 3,000+ links. So, I guess we can contact each of the top sites linking to us and hope they update our links. I'm not hopeful. I believe we'll loose must of the links. Has anyone been down this road and have experience to share?
Link Building | | jmueller0823
What should I expect, worst case? Is there a way to mitigate? Thanks much.
Jim0 -
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 -
Why my twitter handle link is not getting counted in links, though for other sites it is counting!
My twitter handle page link is not getting counted, though it is getting counted for other sites
Link Building | | EG0CENTRIX0 -
Does the ratio of external nofollow links to external "do follow" links matter in terms of SERPs ranking?
My site has an external link nofollow:dofollow ratio of approximately 1:1 That is, there are about as many nofollow external links as "do follow" external links. I have an impression that the ratio of no-follow to "do follow" links is a factor in the way that our website shows up in SERPs. I have the impression from reading a variety of sources, and from looking at Seomoz, that calculate "trust" factors as if they mattered (in SERPs), that seem to value a relatively low nofollow:dofollow ratio. Am I correct about that? Thanks,
Link Building | | tcolling
Tim PS - I don't know whether or not this matters, but our website is at: www.trustworthycare.com - Tim0 -
Links with very bad anchor text!
I have a client with an online shop with auto parts in Romania, on google.ro. The site is quite old but it hasn't good links. The only links (about 700 seen in OSE) the site have are from porn sites/forum/blogs with all kind of obscene words in the anchor text. Those links were placed by competitors, i am sure of that. Now how Google treats those links? Does he know that those links were not placed by any normal human? Does it gives credit to them or doesn't? The site is on a very competitive niche and it is not ranking so good.
Link Building | | maldiniii0 -
Free link on a Paid Link Blog
Hi there, I have been doing some outreaching, and managed to have a blog post accepted on a authority blog. They included links to my website, and I was very pleased with the placement. However, having browsed through the site, I was worried to see that they openly admit they allow 'reviews' of websites, with backlinks included, for $50 per review. I am worried I might be penalised without actually doing anything wrong. I did not pay for my link, but the link has been placed on a site which openly admits they accept payment for links. Should I be worried? Should I ask them to take it down? To date I have been told countless times by bloggers I am outreaching that if I pay $10, $50, $100 etc I can write a blog post. I have never accepted because of the risk of penalization. Now, unwittingly, I am linked to from a paid link site with a blog post that would look like I have paid for it because of the placement and style of back link. What do you think? Thanks,
Link Building | | giveacar0