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 \u201cpriority\u201d<\/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 \u201ccode\u201d<\/p>\n\n\n\n Use the following formula =\u201d<url><loc>\u201d&A2&\u201d<\/loc><changefreq>\u201d&B2&\u201d<\/changefreq><priority>\u201d&C2&\u201d<\/priority><\/url>\u201d<\/p>\n\n\n\n Apply this formula for all your URL\u2019s<\/p>\n\n\n\n Then,<\/strong> Add the following code <urlset xmlns=\u201dhttp:\/\/www.sitemaps.org\/schemas\/\u2026 \u201c> 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> 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. Here, you can see how to generate xml sitemap…<\/p>\n","protected":false},"author":21,"featured_media":7103,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[5263],"tags":[5394,4696,5395,148,5067,5388,4722,5396,311],"class_list":["post-7102","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-seo","tag-excel","tag-google","tag-google-bot","tag-microsoft","tag-schema","tag-search-engines","tag-seo","tag-sitemap-xml","tag-tools"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/7102","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=7102"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/7102\/revisions"}],"predecessor-version":[{"id":7104,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/7102\/revisions\/7104"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media\/7103"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=7102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=7102"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=7102"}],"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 \u201cloc\u201d<\/p>\n\n\n\n
paste all your website URL\u2019s under loc (i.e in A column)<\/p>\n\n\n\n
In B1 just enter this word \u201cchangefreq\u201d<\/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","protected":false},"excerpt":{"rendered":"