Moz Q&A is closed.
After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
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
-
If I disavow bad links on "disavow link webmaster" will they still show up on my moz reports?
We recently found out we have a lot of bad links linking back to our website from spam sites, I disavowed them through the google disavow link webmaster. On my moz report it still shows the links, is that normal?
Link Building | | Ryan.Cruz0 -
Spammy links
Hi Guys, I have a case which seems to occur more often for our customers. The websites of our customers seem to receive tons of backlinks from websites all over the world (China, Russia, Ukrain, etc). It’s spam we never asked for, we didn’t buy any dodgy linkbuilding packages or anything. Do any of you guys have experience with this matter? We try to disavow the links but it takes too much time and we will never manage to disavow 100% of all links. Examples are www.keukensduitsland.nl and www.m2beveiliging.nl Hope anyone has experience and maybe even solutions for this matter. Thanks!
Link Building | | Happy-SEO1 -
Links from coupon sites
Hi All, I post coupons on coupon sites a month ago and when I checked backlinks of my website I saw approx 1000 links coming from coupon sites on my Brand Name. IMO it is quite natural please share your views. *All the big brands listed on that coupon sites e.g amazon, dell etc Thanks
Link Building | | Alick3001 -
A link with "return false"- OSE sees as a No Followed Link
Hello, I couldn't find a clear answer to the impact on SEO for a link written in this way: [" class="expert_info" onclick="window.open(this.href);return false;">](w</span>ww.yourwebsite.com<span style=) [Does the "return false" act as a "no follow"? I came across this in our link data in Open Site Explorer which lists these links all as "no follows." However, an engineer I spoke to said that it shouldn't impact search engine behavior. Any ideas? Thank you in advance! -Sarah K.](w</span>ww.yourwebsite.com<span style=)
Link Building | | OneMedical0 -
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 -
Link Building Ideas?
Hi everyone, I am currently working on a site where people can buy mail-order bagels, i.e. the bagels are shipped via postal mail. It's a good alternative for places that have no good bagel stores nearby, especially in small, rural towns. I am about to launch a link-building campaign for the website, but am a little stuck as to where to begin. My first thought was guest posting, but it seems like the vast majority of food blog owners are very protective of their blogs and rarely, if ever, allow guest posts. I also thought about doing sponsored reviews (i.e. sending mommy bloggers free samples in exchange for a review), but that's essentially a paid link, i.e. a no-no. There are of course generic web directories, but those only get you so far, and article marketing is out of the question (too spammy). Was hoping I might be able to bounce off some ideas off of you all. Any thoughts? Thank you in advance for whatever tips/ideas you might be able to share 🙂 Lukas
Link Building | | TampaSEO0 -
How many links per week is too fast in link building?
For a new website/blog how many links per week looks suspicious or hurt the rankings?
Link Building | | aaran1 -
Links on the same keyword
When is linking from one particular keyword to much. At what point could link building from one keyword be considered spam and potentially delist a site ? Is it possible for a site to be delisted for having to many links from the same keyword ? Heard linking from the website name is more important following recent changes. I try and link from a selection of 3 to 4 keywords. Thanks for your help
Link Building | | onlinemediadirect0