VKT Toolkit · September 12, 2026 · 9 min read

How to Extract All URLs From a Sitemap.xml (SEO Audit, 2026)

Your sitemap has 2,000 URLs. You open sitemap.xml in a text editor, see a wall of <loc> tags, and start scrolling. Twenty minutes later you're at URL 143 with tired eyes and no plan. This is where SEO audits go to die.

The truth is that a sitemap is already a machine-readable list of every URL you consider important — you just need to pull those URLs out of the XML and into a format you can actually work with. In this guide you'll learn three ways to do it, from a 60-second browser method to heavyweight crawlers, plus a short checklist that turns a raw URL list into a real audit.

Why Extract a Sitemap's URLs?

Before the how, the why. A flattened URL list from your sitemap unlocks several core SEO tasks:

• Index audits: compare the URLs you submitted against what search engines actually index. Gaps reveal canonicalization problems, noindex leftovers, or thin content.
• Content inventory: a complete list of published pages is the foundation for content audits, pruning decisions, and topic clustering.
• Migration checklists: before a redesign, extract the old sitemap; after launch, extract the new one. The difference is your redirect and QA checklist.
• Competitor sitemap research: sitemaps are public. Extracting a competitor's sitemap shows you their full page structure, publishing velocity, and sections you haven't covered.

Method 1: Open sitemap.xml in the Browser + Extractor Extension (Recommended)

Here's the trick most people miss: a sitemap is just a list of links. Every URL lives inside a <loc> tag, and browsers render those as clickable links on the page. That means any tool that extracts links from a webpage also extracts URLs from a sitemap — no XML parsing required.

This is where VKT LinkHarvest comes in. It's a Chrome and Edge extension that extracts all links from any webpage, including dynamically rendered pages. Open your sitemap URL, click the LinkHarvest icon, and it captures every URL on the rendered page — with filtering, sorting, internal/external classification, and occurrence counting.

Two practical notes:

• Sitemap index files: if your sitemap.xml is an index pointing to child sitemaps (sitemap-posts.xml, sitemap-pages.xml...), extract the index first, then open each child sitemap and extract it the same way. LinkHarvest's occurrence count makes it easy to spot which URLs you've already collected.
• Exports: the free tier lets you copy filtered links to the clipboard and export as TXT. LinkHarvest Premium (one-time $9.99, lifetime) adds CSV export with UTF-8 BOM encoding — ideal for pasting straight into Excel or Google Sheets without garbled characters.

Method 2: Screaming Frog / Online Parsers

Desktop crawlers like Screaming Frog SEO Spider have a dedicated sitemap mode: paste the sitemap URL, choose "List Mode," and the crawler fetches every URL and reports status codes, redirects, and metadata. Online XML parsers work similarly in your browser.

Use this method when you need full crawling data — response codes, titles, canonical tags — not just the URL list. The trade-off is setup and resources: desktop crawlers need installation and can be slow or memory-hungry on very large sitemaps, and many online parsers cap how many URLs they'll process for free. If your goal is simply "give me the list of URLs," Method 1 is faster.

Method 3: Spreadsheet + XML Import

Excel and Google Sheets can import XML directly. In Excel it's Data → Get Data → From XML File; in Google Sheets you can use the =IMPORTXML() function with an XPath like //loc pointed at the sitemap URL.

This works for small, flat sitemaps, but it gets brittle fast: IMPORTXML has cell and length limits that large sitemaps blow past, sitemap index files need a second query per child sitemap, and XML namespaces occasionally make the import silently return nothing. It's fine for a one-off on a 50-URL sitemap; for anything bigger or nested, use Method 1.

Quick Audit Checklist After Extraction

Once the URLs are in one list, the audit is mostly mechanical:

1. Dedupe. Combine child sitemaps and remove duplicates — LinkHarvest's occurrence count shows each URL once with the number of times it appeared.
2. Check status codes. Crawl the list (or spot-check) for 404s and 301/302 chains. URLs in the sitemap should return 200.
3. Compare against indexed counts. Run a site: query or check your search console coverage. A large gap between submitted and indexed URLs is your top priority.
4. Spot orphaned patterns. URL patterns present in the sitemap but linked from nowhere on the site (or vice versa) reveal navigation and internal-linking gaps.
5. Flag junk. Tag pages, parameterized URLs, and staging subdomains shouldn't be in a production sitemap. Filter by keyword in LinkHarvest to find them in seconds.

Step-by-Step: Extract Sitemap URLs With LinkHarvest

1. Install VKT LinkHarvest from the Chrome Web Store or Edge Add-ons.
2. Type your sitemap address (typically yourdomain.com/sitemap.xml) into the address bar and open it. If unsure, check robots.txt for a Sitemap directive.
3. Click the LinkHarvest icon. It captures every URL rendered on the page and shows them with occurrence counts.
4. If it's a sitemap index, open each child sitemap link and repeat the extraction, then merge the lists.
5. Use the keyword filter to remove noise (for example, exclude URLs containing tag or page) and sort the results.
6. Copy the filtered links to your clipboard or export as TXT (both free). For spreadsheets, upgrade to CSV export on the pricing page.

If you've never used a link extractor before, our guide on how to extract all links from a webpage walks through the interface in more detail.

Method Comparison at a Glance

Frequently Asked Questions

Explore more tools in the VKT Extensions catalog, or reach us at [email protected].