Generate a sitemap for html static website with Excel VBA macro

Generate a site map for HTML static website with Excel macro in VBA

 

Category:

Description

Generate a standard sitemap file with a VBA macro

https://www.inventorybigdata.com/wp-content/uploads/tools/List CB Sitemap.xlsx

Use last version of CB main VBA tool. Down last CB main.xlsm file. Open it

Open “List CB Sitemap.xlsx” launch line with Crtl+Shit+Z

or launch automatically with CB main and daily planified task

A sitemap generator is a tool that creates a list of all the pages on a website and their relative hierarchy, which helps search engines understand the structure of the site.

Example of automatic sitemap with Excel VBA macro :

<urlset xmlns=”http://www.sitemaps.org/schemas/sitemap/0.9>
<url>
  <loc>https://www.beelicense.com/</loc>
  <priority>1.00</priority>
  </url>
<url>
  <loc>https://www.beelicense.com/contact.html</loc>
  <lastmod>2021-02-01</lastmod>
  <priority>0.80</priority>
  </url>
<url>
  <loc>https://www.beelicense.com/index.html</loc>
  <lastmod>2021-02-02</lastmod>
  <priority>0.80</priority>
  </url>
<url>
  <loc>https://www.beelicense.com/lesseropenbeelicensev1-3_1.pdf</loc>
  <lastmod>2021-01-14</lastmod>
  <priority>0.60</priority>
  </url>
  </urlset>

 

 

Creating a sitemap generator using Excel VBA can be a powerful tool for web developers. Not only does it help you understand the structure of a website, but it can also help you extract data from that site and link it to your own Excel spreadsheet. This can save time and increase efficiency in your workflow.

 

Context:

Here is my sitemap generator written in Excel VBA
How to extract data from a website into an Excel spreadsheet
How to link data on a website
way you can use to create dynamic hyperlinks