Sitemap to CSV

Sitemap to CSV produces a CSV download. The CSV has one header and one row per stored page. The columns are loc, lastmod, changefreq, priority, and image URLs. Image addresses on the same page are separated by spaces. You can paste XML into the box, or you can enter a public sitemap URL and let the server fetch it. A pasted urlset is parsed on the server without a second copy of the parser in the browser. The form stays near the top of the page, under the single title. (Sitemap to CSV, guide 1.)

Use https://example.com/sitemap.xml as the file you are checking and https://example.com/courses/seo as a page address you expect to see or not see, depending on the job. Open the file in a spreadsheet and confirm the header before you sort. A comma inside a field is quoted. The download name is sitemap-urls.csv. If the file is a sitemap index, child documents such as https://example.com/sitemaps/pages.xml are fetched only when you supplied the index URL, only while the depth is within 2, and only until 20 child sitemap requests have been made. (Sitemap to CSV, guide 2.)

Sitemap to CSV shares one fetcher with the other sitemap tools. The fetcher allows http and https only. It rejects file, gopher, and data URLs, then blocks localhost, loopback, link-local, private ranges, CGNAT space, and the cloud metadata address before it opens a socket. DNS answers are checked before the connection, and a redirect is checked again. A redirect loop is reported instead of being followed forever. Three hops is the maximum. (Sitemap to CSV, guide 3.)

Large files are cut at 5 MB, and the stored page list stops at 5,000 URLs. Gzip responses and addresses that end in .gz are decompressed before parsing. A DOCTYPE or an entity declaration is rejected so the parser cannot expand an external entity. An HTML document or a Cloudflare challenge body is reported as not a sitemap. The raw response body is not written to the log. (Sitemap to CSV, guide 4.)

When a URL must be fetched, the page sends the job to the server and shows a short progress line while it polls. Small pastes return immediately with the same result shape: source URL, index or urlset, child sitemaps, page rows, errors, duplicates, redirect hops, status, truncated flag, and counts. Repeat fetches of the same normalized URL can reuse a finished parse for 10 minutes. Jobs sit in a file folder so more than one server process can see them, and they expire after 30 minutes. (Sitemap to CSV, guide 5.)

Expecting a row for a child sitemap file. Rows are page URLs. The index is expanded only so those pages can be written. After you read that distinction, look at the severity of any finding. An error means the document or the fetch failed the check this page is responsible for. A warning, such as a duplicate loc or a truncated file, means the rest of the result is still usable. A note explains a cap, a paste that did not download child files, or a sample crawl. (Sitemap to CSV, guide 6.)

A concrete pass through Sitemap to CSV starts with https://example.com/sitemap.xml. If that address is an index whose first child is https://example.com/sitemaps/pages.xml, the file list and the page list answer different questions. The page address https://example.com/courses/seo belongs in the page list only when a urlset contains it. Keep the two lists apart when you copy them into a spreadsheet or a ticket. (Sitemap to CSV, guide 7.)

The result panel uses the same dark block as the other tools on this site. Copy is there when a text result is useful. A download button appears only for a file this page actually builds, such as CSV, XLSX, XML, or llms.txt. Sitemap to CSV does not add a second title to the page, and it does not restyle the tools around it. (Sitemap to CSV, guide 8.)

Take Sitemap to CSV as one step. The next page in this set is Sitemap to Excel, which answers a different question about the same sitemap. Sitemap URL Extractor is the other close check. Finish the reading on this page before you switch, so you do not mix a CSV download with a different report. (Sitemap to CSV, guide 9.)