Import data to organization chart

Did you know that it is possible to make organizational chart in Visio by simply a few clicks from the table in Excel? In addition to the standard procedure dragging shapes from a stencil to a drawing this program has integrated data import wizard. Step by step the can user go through uploading data from another file, and by its structure it automatically deploys supervisor and his subordinates to the drawing. Do not believe? Continue reading this tutorial.

Source table

Create a table in Excel that will satisfy the following conditions:

  • column must have the person’s name (eg. name)
  • must have a column for the unique identification of the person (eg. ID)
  • must have a column for information about senior people (eg. Parent)

Column names may be different, because the data import wizard allows to leave the selection of specific identification of columns to the user. Field ID and Parent see picture “Organization chart” shows who has what superior. The main supervisor can be only one and he has no superor (Jan Novák).

Tabulka organizace
Organization chart

Table is required to be closed before you run the wizard in Visio.

Source file used for this example can be downloaded here.

Import wizard

In Visio, create a new file by choosing File > New. In the business category, we find Organization Chart Wizard. Option to create activates the wizard.

Založení výkresu
Create a drawing

The individual steps of the wizard can be found in the gallery below. Part of the guide is a description of each step.

  1. step – we choose, whether we have already prepared the data file.
  2. step – we choose the type of source file (in our case Excel).
  3. step – load a specific source file.
  4. step – sets which fields from our table represent identifiable information to a person. ID field in our table is associated with the field name in Visio – this field must have a unique information about the person.
  5. step – we choose which information you want directly see near the individual shapes.
  6. step – which fields are stored in the shapes data.
  7. step – we choose automatic or manual arrangement of shapes in a drawing.

After completing the wizard it creates automatically distributed organizational chart. After editing and applying the images / photos to individuals can be achieved even such nice picture.

Organizační diagram
Organization diagram

If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too

Similar posts about this topic

One Comment

  • Dobrý den,
    jak prosím mohu ve visiu vytvořit strukturu organizace – ne osoby, ale divize – útvary – oddělení, z tabulky z excelu? Nechci tam ty ikonky fotek. Když jsem se snažila, hodilo mi to každý útvar na jiný sešit i s těmi ikonkami fotek. Děkuji moc za pomoc, Petra


Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top