Tag: Google Sheets

  • 3 XML Sitemap tricks for Google Sheets

    In the last post I described how I eventually managed to import a Google XML sitemap file into Google sheets. In short, this: =importxml(“http://example.com/sitemap.xml”,”//*[local-name() = ‘url’]”) I’ve been building on that recently and thought I’d share a few ways I’ve been using it. Filtering the sitemap by path Filtering the sitemap by date Counting pages