Microsoft Visio's new feature can automatically convert process map data in Excel into data-driven Visio diagrams

Reading time icon 1 min. read


Readers help support MSpoweruser. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help MSPoweruser sustain the editorial team Read more

Microsoft today announced a new feature in Visio called Data Visualizer that will automatically convert process map data in Excel into data-driven Visio diagrams. Business Analysts can now visualize process steps and associated metadata in a structured Excel table as Visio diagram.

They can do this by using a premade Excel template or an existing spreadsheet of their own design. There is a basic template and then there is another template for cross-functional flowcharts providing a sample mapping table to populate with diagram metadata. The table includes predefined columns for process step number, description, dependencies, owner, function, phase and more. Users can also customize the table with their own columns to meet specific business requirements.

This new feature is available to Visio Pro for Office 365 users.

Learn more about it here.

More about the topics: data-driven Visio diagrams, Microsoft Excel, Microsoft Visio, process map data