Others

How to Fix Visio Organization Chart Position Types from Excel Master_Shape Column

Rana GarciaRana Garcia Nov 3, 2026 869 views

Question details

The user is experiencing an issue where Visio assigns incorrect organization chart shapes when importing data from an Excel Master_Shape column.

How to Fix Visio Organization Chart Position Types from Excel Master_Shape Column
Product
Microsoft Visio and Excel
Device & OS
not provided
Scenario
Importing organizational chart data from an Excel spreadsheet into Visio using the Organization Chart Wizard.
Observed behavior
Visio displays different position types (e.g., standard positions instead of assistants) even though the numbers or text in the Excel Master_Shape column appear correct.
Before you start

Before troubleshooting, ensure your Excel data is clean by removing any trailing spaces, hidden characters, or conflicting formatting in the Master_Shape column.

Solution 1Recommended

Verify Excel Data and Visio Import Settings

Check the initial rows of your Excel data and ensure the Master_Shape values exactly match Visio's required mapping parameters.

Visio's Organization Chart Wizard relies on exact string or numeric matches to assign specific shapes (like Manager, Position, or Assistant). If the data formatting in the Excel column differs slightly from what Visio expects, it defaults to standard shapes.

1
Inspect Excel Data Formatting

Open your Excel spreadsheet and closely examine the first ten rows of your data. Ensure the Master_Shape column contains plain text or standard numbers without extra spaces or special characters.

2
Validate Shape Values

Confirm that the values used to designate 'Position' or 'Assistant' strictly align with Visio's default mapping terms. Avoid mixing numeric IDs and text labels in the same column.

3
Run the Organization Chart Wizard

In Visio, go to File > New > Organization Chart and launch the Organization Chart Wizard. Carefully step through the mapping prompts to ensure the Master_Shape column is correctly assigned to the Shape type.

4
Request Support Investigation

If the mapping continues to fail, create a detailed support thread in the official product forum. Include a screenshot of your spreadsheet, the exact steps used, and sample data so engineers can investigate the shape mapping.

Verify Excel Data and Visio Import Settings
Common Assistant Shape Issue: A frequent problem occurs when position type numbers intended for 'Assistant' are mistakenly processed as standard 'Position' shapes due to wizard misconfiguration.
Create Org Charts Easily

Build Organization Charts Directly in WPS Office

Avoid complex Excel data mapping and Visio import errors by creating visually appealing organization charts directly within WPS Office using intuitive SmartArt tools.

  1. 1. Open WPS Office: Launch WPS Office and open a new Writer Document, Spreadsheet, or Presentation.
  2. 2. Insert SmartArt: Navigate to the Insert tab on the top ribbon menu and click on the SmartArt button.
  3. 3. Select Hierarchy Chart: Choose the Hierarchy category from the left pane and select an Organization Chart style that fits your needs.
  4. 4. Customize Your Data: Click directly on the shapes to type in names and positions. Use the SmartArt Tools menu to quickly add assistants or create new organizational branches.
No complex data mapping or Master_Shape configuration requiredFully compatible with Microsoft Office formatsEasy drag-and-drop interface for structural changesFree and lightweight alternative to heavy diagramming software
microsoft office alternative - wps office

Frequently Asked Questions

Why are my Excel Assistant shapes appearing as standard positions in Visio?

This usually happens when the Master_Shape column values do not precisely match Visio's internal mapping terms, or if there is conflicting data formatting in the Excel rows causing the wizard to default to standard position shapes.

What is the correct format for the Master_Shape column in Excel?

The Master_Shape column should contain text strings or numeric identifiers that the import wizard explicitly recognizes, such as 'Position', 'Manager', or 'Assistant'. Ensure there are no trailing spaces or hidden characters.

How can I share my Excel and Visio mapping issue with support?

You should create a support thread on the official forum including the first ten rows of your Excel data, a screenshot of the spreadsheet, and the exact steps you took during the import wizard process.