SiteMapperPro

CSV to XML sitemap generator

Already have the list? Turn a CSV, spreadsheet column or CMS export into a clean, valid XML sitemap, with real lastmod dates and optional image tags.

Several images per cell? Separate them with | or spaces.

Why build a sitemap from a list instead of a crawl?

A crawler can only list pages it can reach, and it will happily include URLs you never wanted indexed: filtered views, session parameters, duplicates. Google’s advice is to list the canonical URLs you want to appear in search. Your CMS, product database or analytics already knows that set. Export it, drop it in here, and the sitemap matches your intent exactly.

What the generator writes

  • An XML declaration with UTF-8 and the http://www.sitemaps.org/schemas/sitemap/0.9 namespace, as the protocol requires.
  • Entity-escaped URLs (an & in a query string becomes &), with fragments removed.
  • <lastmod> in W3C date format, converted from most spreadsheet date styles. Only use a date that reflects a real content change.
  • Optional <image:image> entries using Google’s image sitemap namespace.

Before you upload, run the file through the sitemap checker, and add a Sitemap line to robots.txt.

Questions

How do I create an XML sitemap from a CSV?

Paste or upload a CSV whose first row names the columns. Pick which column holds the URL and, optionally, the last-modified date and an image URL. The generator writes a valid sitemaps.org file you can download.

Does this tool crawl my site?

No. It turns a list you already trust (a CMS export, a database query, a crawler export) into XML, so the sitemap contains exactly the canonical URLs you choose. To see what a crawl finds, use the visual sitemap on the home page.

Should I include priority and changefreq?

They are valid but optional, and Google ignores both. The generator leaves them out by default; turn them on if another search engine you care about uses them.

What if I have more than 50,000 URLs?

The generator warns you and the sitemap splitter will cut the result into protocol-sized files with a sitemap index.

Sources