Page Comparison

• Navigate to the Sitemap Generator Template sheet from Ryan Kelner and copy the only tab there to the client sheet of the dealer you want to create an SEO sitemap for (Click on Existing spreadsheet).

  

• When you copy a new tab to a client sheet the new tab goes all the way to the right of all existing tabs so make sure you move it near the Work Done Import and SEO Work Done tabs.

• Make sure to also remove the “Copy of ”in the name of the tab.

  

• For the sitemap generator to work we need two things:

  • Add the site URL to the A2 cell of the Sitemap Generator tab.

    Image RemovedImage Added

  • Add all URLs from the old SEO Work Done tab to the new Work Done import tab:

    • Select all the cells on the SEO Work Done tab by clicking on the top left blank space and copy it by Ctrl+C or right-clicking and selecting Copy.

      Image RemovedImage Added

    • Visit the URL Extractor page and paste the contents of the SEO Work Done tab in the Step 1 box.

      

    • Go right into step 3 skipping step 2 and click on the copy to clipboard button to get all links extracted from the SEO Work Done tab.

      

    • Paste these links at the bottom of the oldest link or row in the Work Done Import tab adding a little note like “SEO Work Done URLs:”

      

Once you’ve got all your links in the Work Done Import tab

• Copy the B2 cell of the Sitemap Generator

  Image Added

• Paste into a blank notepad file, it should look something like this:

  Image Added

• Create a folder for each of your clients' sitemaps in your documents.

  Image Added

• Save your file type as “All Files” and name your file “seo-sitemap.xml”

  Image Added

• This should leave you with an XML file

  Image Added