Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I just started using Visio last week and have network items mapped out and their information entered in the shape data for each item. My question is this, is there a way to export the shape data that I entered in to an excel spread sheet. For example: I have a 42 port switch and have all 42 ports entered in the shape data.

I would like to export that info to excel so I don't have to type it again in excel. Is there a way to do this?

share|improve this question
up vote 0 down vote accepted

Creating a report based on shape data is a built-in feature of Visio.

In the Visio 2010 ribbon, select Review tab and then click Shape Reports

enter image description here

Then select a report you want to run and click Run

enter image description here

Then select the output format you want and click OK

enter image description here

If you selected Excel, then Excel will start with report data

enter image description here

Notice that you can modify or create new kinds of reports to meet your particular needs.

share|improve this answer
That's exactly what I was looking for. Thanks for the help! – ThanatosTA Oct 6 '11 at 17:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.