Excel-based site map generator

A good six or seven years back, I developed an Excel spreadsheet that took a hierarchical data feed of pages (page name, level in the IA, page type) and generated a visual representation for you on the fly. A crop of the visual is shown below.

It used conditional formatting up the ying-yang, with particular complexities around developing the interconnects between the boxes. While there were some macros to re-hash the incoming data, the visuals were all based on conditional formats which were at the time limited to a maximum of three (plus the default format) per cell.

All in all, it was awesome. (If I may say so.) If anyone out there has a use for it, let me know.



12 Responses to “Excel-based site map generator”

  1. Danie Lynch on December 12th, 2011 16:04

    I’d love to get a copy of your Excel-based site map generator.


  2. Lukas Sickflow on April 18th, 2013 15:52

    Can i get a copy of this Excel-based site map generator? It would help me alot!


  3. Dan on April 18th, 2013 16:20

    Sent by email, Lukas.

  4. Ralph Chan on July 3rd, 2013 03:43

    May I have a copy too? Many thanks!


  5. Frank on September 25th, 2013 19:50

    Me too!

  6. Steven Lee on November 11th, 2013 20:53

    Hey can you send me a copy too!? Thanks!

  7. Thomas on March 12th, 2014 15:01


    It seems great!
    I’m very interested!

  8. Andrea on November 12th, 2014 11:21

    It would be a great help if you could send me a copy. Thanks in advance!

  9. pter on March 19th, 2015 11:56

    hello it looks great.
    could i get also a copy?


  10. Ryan on April 9th, 2015 23:01

    Me too please?


  11. David Croucher on August 12th, 2015 16:20

    Nice work. I could really use this for work. Could you please send me a copy?

    Thank you in advance


  12. Andrew on February 8th, 2017 10:07

    I’ve been looking for something like this for a while and this looks great. Could I get a copy?


Leave a Reply