How do I import a sitemap CSV into Google Sheets?

Two ways. First: File → Import → Upload, drop the CSV file, choose 'Replace current sheet' or 'Insert new sheet'. Google Sheets auto-detects commas and quotes, handles UTF-8 correctly, and keeps long URLs as plain text (unlike Excel, which sometimes truncates them). Second: paste the sitemap URL into a cell using =IMPORTXML("https://example.com/sitemap.xml", "//*[local-name()='loc']") — this fetches and parses the XML in-place, no download needed, and re-runs on every refresh. The IMPORTXML approach is great for dashboards but slow on huge sitemaps and doesn't follow sitemap-index files. For one-off audits, convert to CSV first.