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.
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”
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=”http://www.sitemaps.org/schemas/… “> 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