Skip to content
    Moz logo Menu open Menu close
    • Products
      • Moz Pro
      • Moz Pro Home
      • Moz Local
      • Moz Local Home
      • STAT
      • Moz API
      • Moz API Home
      • Compare SEO Products
      • Moz Data
    • Free SEO Tools
      • Domain Analysis
      • Keyword Explorer
      • Link Explorer
      • Competitive Research
      • MozBar
      • More Free SEO Tools
    • Learn SEO
      • Beginner's Guide to SEO
      • SEO Learning Center
      • Moz Academy
      • MozCon
      • Webinars, Whitepapers, & Guides
    • Blog
    • Why Moz
      • Digital Marketers
      • Agency Solutions
      • Enterprise Solutions
      • Small Business Solutions
      • The Moz Story
      • New Releases
    • Log in
    • Log out
    • Products
      • Moz Pro

        Your all-in-one suite of SEO essentials.

      • Moz Local

        Raise your local SEO visibility with complete local SEO management.

      • STAT

        SERP tracking and analytics for enterprise SEO experts.

      • Moz API

        Power your SEO with our index of over 44 trillion links.

      • Compare SEO Products

        See which Moz SEO solution best meets your business needs.

      • Moz Data

        Power your SEO strategy & AI models with custom data solutions.

      Track AI Overviews in Keyword Research
      Moz Pro

      Track AI Overviews in Keyword Research

      Try it free!
    • Free SEO Tools
      • Domain Analysis

        Get top competitive SEO metrics like DA, top pages and more.

      • Keyword Explorer

        Find traffic-driving keywords with our 1.25 billion+ keyword index.

      • Link Explorer

        Explore over 40 trillion links for powerful backlink data.

      • Competitive Research

        Uncover valuable insights on your organic search competitors.

      • MozBar

        See top SEO metrics for free as you browse the web.

      • More Free SEO Tools

        Explore all the free SEO tools Moz has to offer.

      NEW Keyword Suggestions by Topic
      Moz Pro

      NEW Keyword Suggestions by Topic

      Learn more
    • Learn SEO
      • Beginner's Guide to SEO

        The #1 most popular introduction to SEO, trusted by millions.

      • SEO Learning Center

        Broaden your knowledge with SEO resources for all skill levels.

      • On-Demand Webinars

        Learn modern SEO best practices from industry experts.

      • How-To Guides

        Step-by-step guides to search success from the authority on SEO.

      • Moz Academy

        Upskill and get certified with on-demand courses & certifications.

      • MozCon

        Save on Early Bird tickets and join us in London or New York City

      Unlock flexible pricing & new endpoints
      Moz API

      Unlock flexible pricing & new endpoints

      Find your plan
    • Blog
    • Why Moz
      • Digital Marketers

        Simplify SEO tasks to save time and grow your traffic.

      • Small Business Solutions

        Uncover insights to make smarter marketing decisions in less time.

      • Agency Solutions

        Earn & keep valuable clients with unparalleled data & insights.

      • Enterprise Solutions

        Gain a competitive edge in the ever-changing world of search.

      • The Moz Story

        Moz was the first & remains the most trusted SEO company.

      • New Releases

        Get the scoop on the latest and greatest from Moz.

      Surface actionable competitive intel
      New Feature

      Surface actionable competitive intel

      Learn More
    • Log in
      • Moz Pro
      • Moz Local
      • Moz Local Dashboard
      • Moz API
      • Moz API Dashboard
      • Moz Academy
    • Avatar
      • Moz Home
      • Notifications
      • Account & Billing
      • Manage Users
      • Community Profile
      • My Q&A
      • My Videos
      • Log Out

    The Moz Q&A Forum

    • Forum
    • Questions
    • Users
    • Ask the Community

    Welcome to the Q&A Forum

    Browse the forum for helpful insights and fresh discussions about all things SEO.

    1. Home
    2. SEO Tactics
    3. Content Development
    4. How to create a dynamic visual sitemap using Google sheets?

    Moz Q&A is closed.

    After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.

    How to create a dynamic visual sitemap using Google sheets?

    Content Development
    1
    1
    1021
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as question
    Log in to reply
    This topic has been deleted. Only users with question management privileges can see it.
    • peteboyd
      peteboyd Subscriber last edited by

      Does anyone have a solution where you can use a listing of page names with tiers in a Google spreadsheet and have it dynamically appear in a visual sitemap architecture format within in a Google document?

      Thanks in advance Moz community!

      1 Reply Last reply Reply Quote 0
      • 1 / 1
      • First post
        Last post

      Got a burning SEO question?

      Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.


      Start my free trial


      Browse Questions

      Explore more categories

      • Moz Tools

        Chat with the community about the Moz tools.

      • SEO Tactics

        Discuss the SEO process with fellow marketers

      • Community

        Discuss industry events, jobs, and news!

      • Digital Marketing

        Chat about tactics outside of SEO

      • Research & Trends

        Dive into research and trends in the search industry.

      • Support

        Connect on product support and feature requests.

      • See all categories

      Related Questions

      • nb2e4fg

        Best SEO Structure For E-Commerce With Products Using Multiple Categories

        site structure seo

        Hi all, I am in the process of re-structuring my e-commerce website for better SEO and user experience. I have done some keyword research and would like some advice on how best to structure my site around those keywords. For example, my site (All Things Nature) sells a brand of wooden sculptures (Woodsculp) and I would like to rank for keywords related to that brand, the brand by animal, the brand by collection and the brand by release date.
        Examples of keywords could be: Brand by Animal: Woodsculp Dogs, Woodsculp Cats, Woodsculp Elephants
        Brand by Collection: Woodsculp Pets, Woodsculp Safari
        Brand by Release Date: Woodsculp Christmas 2023, Woodsculp Summer 2022 I would create each of these keywords as a category so that they can be found by a search engine and by users. I would then structure as follows: All Things Nature -> Woodsculp -> Woodsculp by Animal -> Woodsculp Dogs
        All Things Nature -> Woodsculp -> Woodsculp by Animal -> Woodsculp Elephants
        All Things Nature -> Woodsculp -> Woodsculp by Collection -> Woodsculp Pets
        All Things Nature -> Woodsculp -> Woodsculp by Collection -> Woodsculp Safari
        All Things Nature -> Woodsculp -> Woodsculp by Release Date -> Woodsculp Christmas 2023
        All Things Nature -> Woodsculp -> Woodsculp by Release Date -> Woodsculp Summer 2022 The only problem with this structure is it would take more than 3 clicks (4) for the user to reach a product. How critical is this for good SEO and user experience? Would I be better off getting rid of the ‘Woodsculp by Animal’, ‘Woodsculp by Collection’ and ‘Woodsculp by Release Date’ categories? Structure would look as follows: All Things Nature -> Woodsculp -> Woodsculp Dogs
        All Things Nature -> Woodsculp -> Woodsculp Elephants
        All Things Nature -> Woodsculp -> Woodsculp Safari
        All Things Nature -> Woodsculp -> Woodsculp Christmas 2023 The only thing with this is there would be a lot of categories under the brand name which might make it more difficult for search engines and users to logically follow. Would I be better off getting rid of the brand category and replace them with the keyword categories? Structure would look as follows: All Things Nature -> Woodsculp by Animal -> Woodsculp Dogs
        All Things Nature -> Woodsculp by Animal -> Woodsculp Elephants
        All Things Nature -> Woodsculp by Collection -> Woodsculp Safari
        All Things Nature -> Woodsculp by Release Date -> Woodsculp Christmas 2023 This would organise things more logically but I would then lose the brand category (and the potential of the brand keyword ranking?) Would I be better off choosing one main keyword to use as a category and then use tags for the other categories? Categories: All Things Nature -> Woodsculp -> Woodsculp Dogs
        All Things Nature -> Woodsculp -> Woodsculp Elephants Tags: Woodsculp Safari
        Woodsculp Christmas 2023 The next issue I have is that I have products which could fall under several different categories. A product called Elijah Elephant, for example could fall under Woodsculp Elephants, Woodsculp Safari and Woodsculp Summer 2022. In previous e-commerce sites I have never assigned multiple categories to one product (I instead have used tags). Is it good practice to organise products under multiple categories for an e-commerce site? Thanks in advance for any help and advice.

        Content Development | | nb2e4fg
        0
      • EstherBrice

        Does google penalize you if you post content in french and english on a website

        I'm trying to encourage content editors to only  post content in either English or French. For example we have a French press release but the team are wanting it on our site in French and English.  I thought this would fall under duplicate content rules. Does google penalize you if you post content in French and English on a website?

        Content Development | | EstherBrice
        0
      • Wagada

        I want to use some content that I sent out in a newsletter and post as a blog, but will this count as duplicate content?

        I want to use some content that I sent out in a newsletter a while ago - adding it as a blog to my website. The newsletter exists on a http://myemail.constantcontact.com URL and is being indexed by Google. Will this count as duplicate content?

        Content Development | | Wagada
        0
      • Davit1985

        Using images from Wikipedia, The right way to give credit for them?

        Hi, I am writing my first blog post and I have downloaded 9 images from Wikipedia, After reading the confusing legal stuff, I am under the impression that all those images are allowed to be used  for other purposes with citing/ giving credit to the owner. At least the ones I download the author said its ok to use them anywhere, for anything So how do i do that? Should I have something like this: Image,  underneath--  image credit to xyz (link to Wikipedia page where i downloaded the image)  ??? Thanks for you time and explanation.

        Content Development | | Davit1985
        0
      • fattestcat

        Any Idea who i can contact at Google Finance?

        Hi Everyone, I run a popular news site and we are already working with Yahoo Finance, CNN, USA Today, CNBC, etc...
        The one site we really also want to start working with is Google Finance - but there is no way as far as i can see of getting in touch with them. Our content is the best in our sector and every news site we pitch we almost always start a relationship with - i just need an in. Does anyone know who to contact or how to get in touch with them? Thanks for any advice. James

        Content Development | | fattestcat
        0
      • TMI.com

        Does Google Dislike Slideshows?

        I've noticed a recent drop in organic traffic and a slight dip in rankings. When I looked at who replaced us in the top spots, I noticed text heavy, in depth articles. We produce many articles in the slideshow format. Do you think this is the reason our rankings dropped?

        Content Development | | TMI.com
        0
      • Qcmny

        How do I properly sitemap a site with static pages + Wordpress in it's own directory?

        I apologize for the awkward wording in the headline. No to the issue, I have a site with static pages that are created as follows: url.com, url.com/page1, url.com/page2, etc. I then have WordPress install at url.com/blog. What is the proper method for creating a comprehensive sitemap for my entire domain. I like the sitemap feature provided by Yoast SEO plugin but I assume it will only index the wordpress directory (url.com/blog). Any help would be greatly appreciated!

        Content Development | | Qcmny
        0
      • Thos003

        Wordpress Ping List, does pinging Google Help? Could it hurt?

        So I was looking at updating my ping list in WP. Some of the lists I have come across have a lot of "blogsearch.google" What does a WP site risk in pinging all of these google properties?

        Content Development | | Thos003
        0

      Get started with Moz Pro!

      Unlock the power of advanced SEO tools and data-driven insights.

      Start my free trial
      Products
      • Moz Pro
      • Moz Local
      • Moz API
      • Moz Data
      • STAT
      • Product Updates
      Moz Solutions
      • SMB Solutions
      • Agency Solutions
      • Enterprise Solutions
      • Digital Marketers
      Free SEO Tools
      • Domain Authority Checker
      • Link Explorer
      • Keyword Explorer
      • Competitive Research
      • Brand Authority Checker
      • Local Citation Checker
      • MozBar Extension
      • MozCast
      Resources
      • Blog
      • SEO Learning Center
      • Help Hub
      • Beginner's Guide to SEO
      • How-to Guides
      • Moz Academy
      • API Docs
      About Moz
      • About
      • Team
      • Careers
      • Contact
      Why Moz
      • Case Studies
      • Testimonials
      Get Involved
      • Become an Affiliate
      • MozCon
      • Webinars
      • Practical Marketer Series
      • MozPod
      Connect with us

      Contact the Help team

      Join our newsletter
      Moz logo
      © 2021 - 2025 SEOMoz, Inc., a Ziff Davis company. All rights reserved. Moz is a registered trademark of SEOMoz, Inc.
      • Accessibility
      • Terms of Use
      • Privacy

      Looks like your connection to Moz was lost, please wait while we try to reconnect.