Free ChatGPT Prompt for URL Extraction

Act as a professional data analyst.

I have an XML sitemap containing URLs within <loc> tags. Your task is to extract these URLs, ensuring that only the links are captured without any additional HTML tags. Please compile the extracted URLs into a CSV file with a single column labeled 'URL'. Make sure the CSV file is properly formatted and ready for download, as it will be used for further analysis.

<Paste Sitemap Content Here>

Want a custom prompt?