A stack of web pages turning into a table of addresses and dates
How-toSEOFree on every plan

Export every URL in a sitemap to a CSV

Before a migration, an audit or a monitoring project, someone asks for a list of every page on the site. The site already publishes one. It is just not in a form a spreadsheet can open.

· 4 min read

The problem

The list you already have

A sitemap is the list of pages a site wants search engines to know about, kept up to date by the publishing system. It is the most reliable inventory most sites have. It is also XML, often split into an index that points at a dozen child files, some of them compressed. Turning that into rows is a small script every time, and every time someone writes it again.

How to

Getting the CSV

  1. In the app, open Auto Schedules and choose Extract URLs.
  2. Enter the sitemap's address, usually https://example.com/sitemap.xml.
  3. Download the CSV. You are told how many pages the sitemap lists, and which child sitemaps could not be read, if any.
The shape of the file
url,last_modified
https://example.com/,2026-11-12T08:15:00.000Z
https://example.com/pricing,2026-10-30T14:02:11.000Z
https://example.com/blog/first-post,

The date column is empty for a page whose sitemap entry has no last-modified date, as in the third row. Nothing is created and nothing is captured. It is a tool on its own, and it is on every plan, including the free trial.

Uses

Four things to do with it

  • A migration checklist. The old site's addresses in one column, the new ones beside them, and a redirect for every row.
  • A content audit. Sort by last-modified date to find the pages nobody has touched in two years.
  • Choosing what to monitor. Pick the pages that matter and schedule those. A page schedule takes up to 10 addresses in one go.
  • Checking a pattern before you rely on it. Filter the sheet to see which pages a pattern such as /products/* would match in a sitemap schedule.
Details

What it reads

  • An XML sitemap, or a plain text file of URLs.
  • A sitemap index, one level deep: up to 50 child sitemaps on the same site.
  • Any of these compressed with gzip.
  • Up to 50,000 addresses in all, and 20 MB per file.
A sitemap is what the site declares, not everything it serves
Pages that are not in the sitemap are not in the CSV. If the list looks short, the sitemap is what needs fixing, and search engines are missing the same pages.
Questions

FAQ

Does Extract URLs capture anything?

No. It reads the sitemap and downloads its pages as a CSV. It creates no schedule and uses no captures.

Which plans have it?

Every plan, the free trial included.

What is in the CSV?

One row per page: its address in the url column and its last-modified date in ISO 8601 form. The date is empty when the sitemap gives none.

Why can I only extract one sitemap every two minutes?

Because each one makes us fetch the site's files, and the limit keeps that polite to the site. A mistyped address, or a file that is not a sitemap, can be tried again at once.