Step 1: Make a copy of the Sheets template
Step 2: In the Table tab, add the markets as a heading in row 1
Step 3: For each row include each market’s URL Step 4: Once completed, go to the Export tab and copy all the cells coloured green
Step 5: Go back to the sitemap generator and provide a name for the file
Step 6: Click clear to remove the demo data from the textbox and then paste the copied values.
Step 7: Hit Generate.
Tips
- Google requires that the file is no larger than 50k URLs or 50mb uncompressed, in Col E of the Export tabe we run a count of URLs to help keep track
- When there is no URL for a market leave the cell blank, the tool is clever enough to skip markets without a URL