To help you get started right away, you can use this free Google Sheets template
Using the ImportFromWeb add-on and the function it adds to Google Sheets, you can extract all the URLs contained in any sitemap. And this in seconds, without technical knowledge!
We’ve designed an easy-to-use template so you can try our Sitemap URL extractor.
Make sure you have installed and activated ImportFromWeb in your Google Sheets.