benellwood.co.uk

Category: Spreadsheets

  • Import an XML Sitemap into Google Sheets

    —

    by

    benellwood
    in

    Importing an XML Sitemap into Google Sheets is a really quick (and free) way to start carrying out content audits on your website. The =IMPORTXML() function in Google sheets lets you load in data from a web page, but I found the syntax didn’t work how I’d expect for a sitemap XML file.