Others

How to Remove a Deleted Visio Shape Data Field from Excel Exports

Khadija KhanKhadija Khan Nov 4, 2026 870 views

Question details

The user needs to completely remove a deleted Visio Shape Data field so it no longer generates a column when exporting an organization chart to Excel.

How to Remove a Deleted Visio Shape Data Field from Excel Exports
Product
Microsoft Visio, Microsoft Excel
Device & OS
not provided
Scenario
Exporting a modified Visio organization chart to an Excel spreadsheet after removing custom shape data fields.
Observed behavior
A field previously deleted from the Define Shape Data dialog continues to appear in the exported Excel file, even though it is no longer visible in the shape's expected ShapeSheet location.
Before you start

Verify that your Visio organization chart is fully saved and close any currently open Excel exports to ensure you are not viewing a cached version of the data.

Solution 1Recommended

Check Document, Page, and Master Shape Data

Custom fields are sometimes retained at the Master shape level or inherited from the document, causing them to persist during export even if deleted from an individual shape.

In Visio, shapes often inherit data structure from a Master shape in the Document Stencil. If the field was only deleted from instances on the page, the Master shape might still be pushing the deleted field into the export wizard.

1
Enable Developer Mode

Go to File > Options > Advanced. Scroll down to the General section and check 'Run in developer mode', then click OK.

2
Inspect the Document Stencil

Navigate to Developer > Document Stencil. Right-click the Master shapes used in your organization chart, select Edit Master > Edit Master Shape, and check the Define Shape Data dialog to see if the field is still there. Delete it if found.

3
Check the Page ShapeSheet

Right-click an empty area of your drawing page and select 'Show ShapeSheet'. Scroll to the Shape Data section to ensure the deleted field is not saved at the page level.

Check Document, Page, and Master Shape Data
Master Shape Updates: When you update a Master shape, Visio will prompt you to update all instances of that shape on your drawing page. Accept this prompt to apply the deletion globally.
Free Microsoft Office alternative

Easily Manage Exported Organization Data with WPS Office

If your Visio exports contain residual columns or formatting issues, you can seamlessly open, edit, and clean up the exported data using WPS Spreadsheets. WPS Office is a powerful, lightweight suite that handles spreadsheet data effortlessly.

Fully compatible with Microsoft Excel (.xls, .xlsx) formatsFree, lightweight, and incredibly fast to installFamiliar user interface makes data cleanup simple and intuitiveComprehensive tools to easily delete unwanted phantom columns from exports
microsoft office alternative - wps office

Frequently Asked Questions

Why does a deleted field still show up in Visio Excel exports?

The field is often cached in the document's underlying XML, retained in a Master shape within the Document Stencil, or held in the organization chart wizard's memory even after being removed from an individual shape.

How do I access the ShapeSheet in Visio?

First, enable Developer mode by going to File > Options > Advanced and checking 'Run in developer mode'. Afterward, you can right-click any shape or page and select 'Show ShapeSheet'.

Can I just manually delete the column in the exported Excel file?

Yes. If Visio persistently exports a ghost field, you can open the resulting .xlsx file, right-click the column letter containing the deleted field, and select 'Delete' to permanently remove it from your final spreadsheet.