In order to provide some contrast, here is a non-Excel solution we have been using for one of our datacenter groups:

RackTables: http://racktables.org/about.php

It provides some asset management and other functions, so there might be some overlap in your organization, but primarily it's a rack visualizer / organizer. Perhaps the most useful feature is the ability to actually configure the physical ports on each object and how they're connected to each other, as well as the tagging system.

Try it, you might like it -- if not there is always the custom spreadsheet option as others have suggested.


I were in the exact same situation as you, and I spent quite alot of time searching for software to make this easier. No matter what I found, 42 rows in excel was the best option (with comment fields).


I have used Excel with Visio Stencils (icons) it is quite nice.

Dell Stencils

Cisco Stencils

A good resource for Visio Stencils: VisoCafe