How to Fix Visio Organization Chart Position Types from Excel Master_Shape Column
Question details
The user is experiencing an issue where Visio assigns incorrect organization chart shapes when importing data from an 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 troubleshooting, ensure your Excel data is clean by removing any trailing spaces, hidden characters, or conflicting formatting in the Master_Shape column.
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.
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.
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.
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.
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.

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. Open WPS Office: Launch WPS Office and open a new Writer Document, Spreadsheet, or Presentation.
- 2. Insert SmartArt: Navigate to the Insert tab on the top ribbon menu and click on the SmartArt button.
- 3. Select Hierarchy Chart: Choose the Hierarchy category from the left pane and select an Organization Chart style that fits your needs.
- 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.

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.




