How to create a visio network diagram from excel data

Written by tricia goss Google
  • Share
  • Tweet
  • Share
  • Email

One of the benefits of using the Microsoft Office suite of programs is that the applications work so well together. Another advantage is the availability of templates for all sorts of document types. Combining the two can make creating complex files much simpler. For instance, you can create a detailed network diagram in Visio 2010 by starting with a template and then importing associated information from an existing Excel file, linking data in the worksheet to the shapes in the diagram.

Skill level:
Moderately Easy

Other People Are Reading


  1. 1

    Start Visio and click on the "File" tab. Click "New" in the left pane and select "Network." Choose "Detailed Network Diagram" and click "Create."

  2. 2

    Drag a ring network shape or Ethernet shape from the "Network and Peripherals" group onto the page. Drag the appropriate devices from the "Computers and Monitors" or "Network and Peripherals" section onto the page.

  3. 3

    Connect the device shapes to the network shape. Click on the network or Ethernet shape and hover the mouse pointer over the yellow, diamond-shaped control handle. When the pointer changes to a four-way arrow, drag toward the first device to draw a connector. Repeat with the remaining devices.

  4. 4

    Import Excel data into the diagram. Go to the "Data" tab. Click on "Link Data to Shapes" in the "External Data" group. The Data Selector Wizard opens.

  5. 5

    Select "Microsoft Excel Workbook" as the type of data source you want to use and click "Next." Browse to the workbook you want to use and click "Insert." Complete the wizard.

  6. 6

    Drag a row of the imported Excel data to a shape in the diagram to add it to the shape data. Repeat for the remaining shapes and information.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.