A sitemap is one type of file where you can list the web pages of your site to inform Google and other search engines about the organization\/Set-up of your site content. Search engine web crawlers like Google-bot read this file to more prudentially crawl your site.<\/p>\n\n\n\n
Here, you can see how to generate xml sitemap manually using Microsoft excel.<\/strong><\/p>\n\n\n\n First of all,<\/strong> after that,<\/strong> and,<\/strong> Then,<\/strong> and,<\/strong> after that,<\/strong> Make sure you mentioned changefreq for all your pages<\/p>\n\n\n\n In C1 just enter this word “priority”<\/p>\n\n\n\n Under c1, set your priority and also make sure you have mentioned priority for all pages<\/p>\n\n\n\n In D1 just enter this word “code”<\/p>\n\n\n\n Use the following formula =”<url><loc>”&A2&”<\/loc><changefreq>”&B2&”<\/changefreq><priority>”&C2&”<\/priority><\/url>”<\/p>\n\n\n\n Apply this formula for all your URL’s<\/p>\n\n\n\n Then,<\/strong> Add the following code <urlset xmlns=”http:\/\/www.sitemaps.org\/schemas\/… “> at begining<\/p>\n\n\n\n Add the following code at the end <\/urlset><\/p>\n\n\n\n Then,<\/strong> Upload it into in your root folder<\/p>\n\n\n\n Finally,<\/strong> Cheers!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" A sitemap is one type of file where you can list the web pages of your site to inform Google and other search engines about the organization\/Set-up of your site… <\/p>\n","protected":false},"author":21,"featured_media":9298,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5263],"tags":[4696,4722,5756,5399,5757],"class_list":["post-9297","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-seo","tag-google","tag-seo","tag-seo-tool","tag-sitemap","tag-sitemap-generate"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/9297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=9297"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/9297\/revisions"}],"predecessor-version":[{"id":9299,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/9297\/revisions\/9299"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media\/9298"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=9297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=9297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=9297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Get your all website pages from database.<\/p>\n\n\n\n
Open an excel sheet<\/p>\n\n\n\n
In A1 just enter this word “loc”<\/p>\n\n\n\n
paste all your website URL’s under loc (i.e in A column)<\/p>\n\n\n\n
In B1 just enter this word “changefreq”<\/p>\n\n\n\n
Under changefreq you can type either monthly, weekly or daily according to your needs.<\/p>\n\n\n\n
Copy the code column and past it into the notepad<\/p>\n\n\n\n
save that notepad file into xml version<\/p>\n\n\n\n
Submit your sitemap in search console<\/p>\n\n\n\n