Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.