SEO Tool to Generate Sitemap.xml for Unlimited Page

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 manually using Microsoft excel.

First of all,
Get your all website pages from database.

after that,
Open an excel sheet

In A1 just enter this word “loc”

paste all your website URL’s under loc (i.e in A column)

In B1 just enter this word “changefreq”

after that,
Under changefreq you can type either monthly, weekly or daily according to your needs.

Make sure you mentioned changefreq for all your pages

In C1 just enter this word “priority”

Under c1, set your priority and also make sure you have mentioned priority for all pages

In D1 just enter this word “code”

Use the following formula =”<url><loc>”&A2&”</loc><changefreq>”&B2&”</changefreq><priority>”&C2&”</priority></url>”

Apply this formula for all your URL’s

Copy the code column and past it into the notepad

Add the following code <urlset xmlns=”… “> at begining

Add the following code at the end </urlset>

save that notepad file into xml version

Upload it into in your root folder

Submit your sitemap in search console