The Lazy IA's Guide to Making Sitemaps
by Stephen Turbek on 2006/01/30 | [64 Comments]
This article further develops the excellent Automating Diagrams with Visio by Michael Angeles.
Sitemaps are common deliverables, desired by clients who want a visual representation of a site. Since they are rarely used to make decisions, information architects may not consider them the valuable tools they are. The effort required to make and maintain them requires time that might be better used elsewhere. In fact, I would suggest that making sure the little boxes line up is a waste of an IA’s mental abilities.
Especially when your sitemap looks like this.
So what is an IA to do? Turn to Excel, of course. Storing sitemap data in a structured data format such as Microsoft Excel makes the data easy to edit, easy to share with the team, and easy to elaborate on (e.g., adding example notes and URLs that may not be appropriate for the map itself). Unfortunately, this approach requires maintaining a spreadsheet in addition to maintaining the visual sitemap.
Or does it?
This article includes step-by-step instructions on how to make sitemaps with:
1. Excel and Visio 2000 or Visio 2003 (Windows only)
2. Word and Inspiration (Mac OS and Windows)
Use these lazy techniques and spend your time on better and more interesting problems than lining up little boxes!
Techniques
I’ve chosen these three options because they use standard applications that store the sitemap data in a format that can be edited by non-IAs. Each option demonstrates how you can store the data in the first format (Excel or Word) and import it into the second program (Visio or Inspiration) to—Voila!—create the sitemap.
You can use this zip file to access all the templates referenced in this article. I suggest doing the exercise once with the sample file to get the hang of it, then editing that file to your needs. The Excel spreadsheet has been written to do some semi-fancy calculations to let you store your data on the import sheet in a nice format and to output Visio-readable data on the output sheet.
1. Only edit data on the Input page.
2. Eliminate blank rows in the middle of your data.
3. The top sitemap box must be in field A2.
4. The template is defined for up to 200 elements ”
Technique 1: Excel and Visio 2000 / 2003
This approach uses the import data feature of Visio 2000 (Note that this feature has been removed in Visio 2003) and (mis)uses the “Organization Chart Wizard” from Visio 2003. You store and manage the sitemap data (the list of links in a structured organization) in Microsoft Excel, save it as a text file, and import it into Visio for quick visualization.
Step 1: Enter your sitemap data in the “Input” sheet in the file “template_for_visio_2000_and_2003.xls.”

For Visio 2003, proceed to the variation below.
Step 2: Go to the “Output for Visio 2000” sheet (and pay it no mind). 
Save as Type “Text (tab delimited).” 
You will see two alerts. Click OK and Yes.


Close the file. You may get the alerts again, hit “OK” and “Yes.” Closing the file is actually important!
Step 3: Open Visio 2000. Click “Open.” Choose Files of Type “Text (.txt, .csv).” Choose the file you just saved. 
Step 4: When the dialog box pops up, set Field separator to [Tab] Text Delimiter to “Comment Character to ;. Click “OK.” 
Step 5: A sitemap! Edit your sitemap to suit your fancy. 
Variation for Visio 2003
Step 2: Click on the Sheet tab “Output Visio 2003” (and pay it no mind). Save the Excel file and close it. 

Open Visio 2003. Select the "Organization Chart Wizard."Step 3: Select “Information that is stored in a file or database.” Click “Next.” 
Step 4: Select “A text, Org Plus (*.txt), or Microsoft Excel file. Click “Next.” 
Step 5: Find the demo file included with this presentation “example_visio_2003.XLS.” Click “Next.” 
Step 6: Leave these defaults. Click “Next.” 
Step 7: Remove “Title” as a displayed field. Click “Next.” 
Step 8: Ignore the Custom Property fields (though you might be able to think of some use for the other fields in some interesting way). Click “Next.” 
Step 9: You can make sitemaps that span multiple pages. Choose “specify.” Click “Next.” 
Step 10: This allows you to define the top Sitemap box on the page. If you follow the Excel template, you can leave this alone. Click “Finish.” 
Step 11: A sitemap!
Step 12 Right click on the sitemap to edit properities. 
“Arrange subordinates” changes the sitemap layout. 
“Change Position” changes the look of the boxes 
Technique 2: Microsoft Word and Inspiration
This (mis)uses the flowcharting tool Inspiration. To do so, you format the sitemap in Microsoft Word outline format, save it as a RTF document, import it into Inspiration, and modify the diagram to look like a sitemap. The outline format can also be created directly in Inspiration, but storing the data in Word allows you to better collaborate with coworkers and clients.
Step 1: Outline your sitemap using Microsoft Word’s Outline format. Save it as a RTF file. (Step 1 is optional: you can make the outline in Inspiration, but some users may wish a more accessible format, like Microsoft Word.) 
Step 2: Open Inspiration. Create a new file. Open the RTF file.
Step 3: Inspiration converts the RTF file to its own format. You may have to do some minor editing to remove blank rows, as shown above. (See image 26)
Step 4: Click the “diagram” button at the upper left. What a mess! But click the “arrange ” button… 
Step 5: Select diagram type “Top down Tree” and Lower level stacking option “Right.” 
Better arranged, but visually lacking. 
Step 6: Select all then click the rectangle in the menu bar. Now you can do things like take off the drop shadow, change the fill color to white, change the line color, etc. 

A sitemap!Working hard, hardly working
Sitemaps can be useful tools and are a whole lot easier when you separate the data from the visualization. After you have done these steps a few times, you will be able to update a sitemap in under a minute.
All these techniques can be expanded and improved upon. Let me know what you have done and what works for you. Have fun, but don’t work too hard!
Downloads
This article references the following downloads:
Templates referenced in article (Visio, Inspiration, Excel)
For more information
This article includes step-by-step instructions on how to make sitemaps with:
Excel and Visio 2000 or Visio 2003 (Windows only)
Word and Inspiration (Mac OS and Windows)
Downloadable excel Site Map Thanks to Jon Stuckey and Marcia Stanton.




Readers' Comments (64)
James Melzer
4 Reputation points
Posted 2006/01/30 @ 19:07PM with
Jason Fields
2 Reputation points
Posted 2006/01/31 @ 11:45AM with
Bryan J Busch
0 Reputation points
Posted 2006/01/31 @ 13:06PM with
Gordon Withers
1 Reputation points
Posted 2006/01/31 @ 16:04PM with
Donna Spencer
159 Reputation points
Posted 2006/01/31 @ 17:36PM with
C. Dinos Papoulias
0 Reputation points
Posted 2006/01/31 @ 22:10PM with
allen o'leary
2 Reputation points
Posted 2006/02/01 @ 03:50AM with
Audrey Crane
0 Reputation points
Posted 2006/02/01 @ 15:34PM with
Anthony Armendariz
0 Reputation points
Posted 2006/02/01 @ 17:06PM with
Gordon Withers
1 Reputation points
Posted 2006/02/02 @ 00:21AM with
Jon Stuckey
5 Reputation points
Posted 2006/02/02 @ 13:31PM with
Andrew Gilmartin
1 Reputation points
Posted 2006/02/03 @ 09:03AM with
Brian Donohue
0 Reputation points
Posted 2006/02/04 @ 15:39PM with
Harry Brignull
0 Reputation points
Posted 2006/02/06 @ 10:48AM with
Erica Heinz
0 Reputation points
Posted 2006/02/06 @ 16:52PM with
Eamon Mag Uidhir
0 Reputation points
Posted 2006/02/07 @ 03:24AM with
Gordon Withers
1 Reputation points
Posted 2006/02/07 @ 11:37AM with
Harry Brignull
0 Reputation points
Posted 2006/02/08 @ 05:19AM with
Brian Donohue
0 Reputation points
Posted 2006/02/08 @ 07:29AM with
Michael Hessling
1 Reputation points
Posted 2006/02/08 @ 15:26PM with
Eliot White
0 Reputation points
Posted 2006/02/08 @ 16:34PM with
Robert Miller
0 Reputation points
Posted 2006/02/10 @ 08:41AM with
Michael Hessling
1 Reputation points
Posted 2006/02/10 @ 10:58AM with
Jon Stuckey
5 Reputation points
Posted 2006/02/10 @ 15:09PM with
Virginia Bing
0 Reputation points
Posted 2006/02/14 @ 13:53PM with
Natasha Reynolds
0 Reputation points
Posted 2006/02/14 @ 20:09PM with
unai unai
0 Reputation points
Posted 2006/02/16 @ 08:30AM with
Noreen Whysel
0 Reputation points
Posted 2006/02/16 @ 13:36PM with
Iram Mirza
0 Reputation points
Posted 2006/02/17 @ 11:40AM with
Jon Stuckey
5 Reputation points
Posted 2006/02/23 @ 09:20AM with
Y Kagal
0 Reputation points
Posted 2006/02/28 @ 11:25AM with
Dave Linabury
0 Reputation points
Posted 2006/03/04 @ 17:02PM with
Thanh Nguyen
0 Reputation points
Posted 2006/03/06 @ 11:55AM with
Thanh Nguyen
0 Reputation points
Posted 2006/03/06 @ 12:00PM with
Sheri Handel
0 Reputation points
Posted 2006/03/12 @ 06:42AM with
Jeffrey Sekera
0 Reputation points
Posted 2006/03/14 @ 19:08PM with
louisa cameron
0 Reputation points
Posted 2006/04/10 @ 09:02AM with
Noreen Whysel
0 Reputation points
Posted 2006/04/12 @ 10:56AM with
Jon Stuckey
5 Reputation points
Posted 2006/04/12 @ 11:42AM with
Jon Jon
0 Reputation points
Posted 2006/04/24 @ 10:42AM with
Jon Jon
0 Reputation points
Posted 2006/04/24 @ 10:57AM with
Christina Wodtke
560 Reputation points
Posted 2006/05/29 @ 17:00PM with
Rohan Sandeep
11 Reputation points
Posted 2006/05/30 @ 12:09PM with
Christina Wodtke
560 Reputation points
Posted 2006/06/07 @ 13:11PM with
Rakhi Pawar
0 Reputation points
Posted 2006/06/09 @ 16:01PM with
Cheryl Fuerte
0 Reputation points
Posted 2006/07/25 @ 02:51AM with
Trevor North
0 Reputation points
Posted 2006/07/31 @ 05:31AM with
Trevor North
0 Reputation points
Posted 2006/07/31 @ 05:33AM with
Lys Maitland
1 Reputation points
Posted 2006/07/31 @ 23:42PM with
Molly Anglin
0 Reputation points
Posted 2006/09/27 @ 12:38PM with
Manoj Sinha
0 Reputation points
Posted 2006/12/19 @ 10:39AM with
Andy Dent
1 Reputation points
Posted 2007/02/01 @ 16:30PM with
Josh WT
0 Reputation points
Posted 2007/04/06 @ 13:50PM with
Julie Wetherill
0 Reputation points
Posted 2007/04/12 @ 10:57AM with
Paul Nattress
0 Reputation points
Posted 2007/04/16 @ 05:52AM with
Paul Nattress
0 Reputation points
Posted 2007/04/16 @ 05:55AM with
Rakhi Pawar
0 Reputation points
Posted 2007/06/07 @ 13:06PM with
Katral Hassan
0 Reputation points
Posted 2007/07/10 @ 08:49AM with
alex kirtland
-1 Reputation points
Posted 2007/07/10 @ 13:56PM with
juliano ferreira
0 Reputation points
Posted 2007/08/13 @ 12:01PM with
Geoff Snyder
0 Reputation points
Posted 2007/10/29 @ 21:32PM with
James Dean
0 Reputation points
Posted 2007/11/01 @ 05:11AM with
Edward Garana
4 Reputation points
Posted 2008/01/24 @ 11:17AM with
Jason Pearce
1 Reputation points
Posted 2008/02/08 @ 12:54PM with