We handpick every product we feature. We may be compensated or earn commission from the links on this page.Small Business|Business Models & Organizational Structure|OrganizationsHow to Import an Organization Chart Into VisioBy Andrew McClain, ContributorVisio's Organization Chart Wizard imports organizational charts and converts them to Visio documents.Getty
Microsoft Visio gives you the power to chart nearly anything that involves a hierarchy or workflow with a variety of shapes and illustrations. In addition, you can also import text-based organization charts from an Excel or other spreadsheet. Visio uses this data to create a flowchart representing the data. Before you import a spreadsheet, make sure it's clearly organized with job titles starting from the top position in the organization down to the lowest position in the organization.
Open Visio.
Click "File" and "New" to create a new, blank chart.
Click "View," "Add-Ons," "Business" and "Organization Chart Wizard" from the main menu. This opens the Organization Chart Wizard.
Mark the "Information that's already stored in a file or database" option and click "Next."
Click the "A text, Org Plus (.txt), or Excel file" option and click "Next."
Click "Browse" and locate the spreadsheet containing the organization chart. Click a language from the Specify Language drop-down and click "Next."
Select all the field names in the Data File Columns field and click the "Add" button to move the fields to the Displayed Fields column. The Displayed Fields column shows the order data will appear in each square in the chart. Click a field and the up or down buttons to move the field up or down in the list. Click "Next."
Select all the items in the Data File Columns field and click "Add" to move them to the Shape Data Fields column. Click "Next."
Mark whether you want to control how much data appears on each page or if you want Visio to automatically break the chart across different pages.
Enter the name that you want in the top of the chart in the Name at Top of Page field.
Mark whether you want to hyperlink employee shapes across pages or synchronize employee shapes across pages.
Click "Finish" to import and create your organizational chart.
More For You
How to Create a Header in Excel to Span Across the Top of the Page
How to Create a Header in Excel to Span Across the Top of the Page. A carefully placed...
How to Export Data in MS Word
How to Export Data in MS Word. Information stored in a Microsoft Word document can provide...
How Do I Create a Column Chart in Excel & Then Move It to a New Page in My Workbook?
How Do I Create a Column Chart in Excel & Then Move It to a New Page in My Workbook?. The...
Exporting Salesforce Contacts
Exporting Salesforce Contacts. Salesforce.com users can export Salesforce contact data...
How To Import a Project on MS Excel
How To Import a Project on MS Excel. Microsoft Project is an effective management service...
References
AddictiveTips: Create Organization Chart in Visio 2010 From Excel Spreadsheet
Andrew McClainContributor
Andrew McClain has been writing since 1994. He has written several articles for various websites and writes user guides and software manuals for several freelance clients. He has a Bachelor of Arts in journalism from the University of Missouri.
