March 2006 Archives

Example Spreadsheets

| 1 Comment

I've had a number of people ask me for example spreadsheets to help them with conducting a content audit or content inventory.

Jeff Veen, a founder of Adaptive Path, wrote an essay about content analysis back in 2002. You can find the essay and a basic spreadsheet on the AP site. I find that I often customize Jeff's basic spreadsheet based upon the needs of the site and the project.

Here is an example of a content inventory spreadsheet (Excel: 72 KB) that has been customized for site migration. The first tab is blank and the second tab shows what it could look like all filled in. This was from my days at PeopleSoft, but since the site (and company) no longer exist, I figured there was no harm in posting the spreadsheet.

The main thing to remember is that the spreadsheet is just a tool to help you capture what it is that you are learning about and seeing on the site. There is no "one true" spreadsheet that will work in all cases. Play around with it. Adjust the columns to capture the information that is relevent to your situation.

And remember - content analysis is fun!

IA Summit Presentation

Tomorrow afternoon I'm presenting a session on "Content Analysis: Methods and Mentoring." The presentation is not included in the conference CD, but you can find the PowerPoint slides here on my site.

About this Archive

This page is an archive of entries from March 2006 listed from newest to oldest.

February 2006 is the previous archive.

May 2006 is the next archive.

Find recent content on the main index or look in the archives to find all content.


Recent Comments

  • Laura Zucchetti: Speaking as someone who started out as a jack of read more
  • Kate: Hey Chiara: This is a wonderful post. I am so read more
  • Lisa Paul: Wow. This is great. I always try to shop proactively read more
  • Elisa Camahort Page: Thanks Chiara!! Hope we will see you in Chicago this read more
  • Chiara: Hi Conner- That's great that you are happy with the read more
  • Conner Versione: I used these guys for my website They did read more
  • Conner Versione: Conner, I used these guys to add a video to read more
  • Mamacita: Wow, I've been quoted! Thank you so much for those read more
  • scotter: Yes, I guess that anger hangover is right. read more
  • anger hangover: i've been blogging for a few years and i don't read more
Powered by Movable Type 5.04