File Format & Compatibility

How to Fix Visio Organization Chart Missing Excel Data During Import

Chanuka GeekiyanageChanuka Geekiyanage Nov 4, 2026 869 views

Question details

Users experience missing data fields when importing an organization chart from Excel into Visio.

How to Fix Visio Organization Chart Missing Excel Data During Import
Product
Microsoft Visio
Device & OS
not provided
Scenario
Importing employee or organizational data from an Excel spreadsheet to automatically generate an organization chart in Visio.
Observed behavior
Visio omits certain values or entire columns from the imported Excel data, usually because of inconsistent data types or hidden shape settings.
Before you start

Ensure your Excel spreadsheet is fully saved and closed before starting the import process in Visio to prevent file locking conflicts.

Solution 1Recommended

Standardize Excel Column Data Types

Clean your spreadsheet by ensuring all cells within a specific column use the exact same data type, preventing Visio from skipping mixed-value fields during import.

Visio's import wizard expects a uniform data format for each column. If a column contains both text strings and pure numbers, the wizard may fail to parse the inconsistent fields properly, resulting in missing data in your chart.

1
Open the source spreadsheet

Open your Excel file containing the organizational hierarchy data.

2
Locate problem columns

Check columns such as Position Number, DeptID, or Titles for mixed values. Look for cells that mix numbers with text (like 'BUD') or use inconsistent hyphens.

3
Normalize the data

Format the entire column to a single data type (e.g., set the format to 'Text' for all cells in a column that contains mixed characters). Remove or normalize any unnecessary special characters.

4
Re-import into Visio

Save the changes, close Excel, and run the Visio Organization Chart Wizard again to import the cleaned data.

Standardize Excel Column Data Types
Tip for text conversion: Adding an apostrophe (') before a number in Excel forces the application to treat that cell as text, which is helpful when standardizing ID columns.
Free Microsoft Office alternative

Manage Spreadsheet Data Seamlessly with WPS Office

While Visio is a Microsoft product, you can efficiently prepare, format, and clean your organizational data using WPS Spreadsheet before importing. WPS Office provides a free, lightweight, and highly compatible suite for all your document needs.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats to ensure smooth data preparation.Advanced data formatting and cleaning tools to quickly standardize mixed-value columns.Built-in flowchart and smart diagramming features available within WPS Writer and Presentation.Free and lightweight software with a familiar, easy-to-use interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Visio drop my Excel data during the org chart import?

Visio relies on strict and consistent data formatting to read columns. If an Excel column contains a mix of text, numbers, or special characters, Visio might fail to parse the column correctly and will drop or omit the inconsistent values.

How can I check if my imported data is in Visio but just hidden?

Right-click any shape in your organization chart, hover over 'Data', and select 'Shape Data'. If your missing Excel fields appear in this side window, they have been successfully imported but are simply hidden from the main visual diagram layout.

What file formats does the Visio Organization Chart Wizard support?

The wizard supports importing data from Microsoft Excel worksheets (.xls, .xlsx), plain text files (.txt, .csv), Microsoft Exchange Server directories, and ODBC-compliant data sources.

Can I use formulas in Excel for Visio organization chart data?

Yes, but Visio imports the resulting value of the formula, not the formula itself. Ensure that the calculated values are uniform in format and do not yield errors like #N/A or #VALUE!, as these will break the import process.