2

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?

Simon Sheehan
  • 9,164
ThanatosTA
  • 23

1 Answers1

0

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.

saveenr
  • 1,514