Home » How to Import Sitemap & Sitemap Index to Google Sheets?

How to Import Sitemap & Sitemap Index to Google Sheets?

I built an extension for Google Sheets that allows you to import your sitemap and sitemap indexes to Google Sheet documents directly. Probably SEO executives will love this extension because they are working with sitemaps often.

If you do not want to know technical stuff you can get a copy from this link.

How to Import Sitemap?

Google Sheets Sitemap Import
Google Sheets Sitemap Import

You can see a screenshot on the right that shows you a menu in Google Sheets. When you add this extension to your google sheets workplace, you are going to be able to import sitemaps or sitemap indexes to your sheet.

It’s really simple, you will click the Load Sitemap menu item then you will see a prompt that is asking you an URL for sitemap or sitemap index.

Paste Sitemap URL

Load sitemap screen for Google Sheets Sitemap Import

When you paste the URL you need to click the OK button. Then Google Sheet starts to process your sitemap to append the active sheet.

Wait Until Process Complete

Loading sitemap process is completed alert

You can see an alert that gives you information about the process. You will see this when the process is completed.

Enjoy the results

As you can see all results came from the sitemap file. These results are from my blog’s sitemap.

How to Install Sitemap Import Extension?

When you create a Google Sheet document you need to follow these steps:

Time needed: 1 minute

How to install Google Sheets Sitemap Import Extension?

  1. Create a document

    Create a document or open your available document.

  2. Find Tools Menu

    Then Tools->Script Editor
    Then you will see a code editor screen.

  3. Paste the code to the editor

    You need to copy all code that I wrote below. Then paste it into the editor area in the script editor.
    You can delete myFunction code block.

  4. Apply the changes

    You can save all changes/codes with the save button. Then you’re ready to go!

The Code That You Need

I hope you enjoy this post!

See you in the next tutorial!

Ilyas Ozkurt

Hello I'm İlyas Özkurt. I am a software developer who has been working on websites for 10 years. My first studies in this field were during my high school years. Now I work as a software developer at 6harf and am responsible for all web projects there.

3 comments