FAQ // All answers
How do I convert an XML sitemap to Excel?
Convert an XML sitemap to Excel either through Excel's built-in XML importer (Data → Get Data → From File → From XML, then point at the sitemap URL or downloaded .xml file) or with a web converter that emits a real .xlsx file. Excel's native importer works for small, simple sitemaps but doesn't follow sitemap-index files, sometimes mangles long URLs into scientific notation, and won't handle gzipped (.xml.gz) sitemaps. The xmlsitemapmaker.com converter handles all of these — follows the index, preserves URL strings as text, auto-sizes the URL column — and outputs a real .xlsx workbook, not a renamed CSV. Drop in a URL, click Convert, open the file directly in Excel.
RELATED