Create Flowchart from Excel Spreadsheet in Visio 2016 with Data Visualizer

Need to create a flowchart from an Excel spreadsheet using Visio 2016? Well, you're in the right place. This tutorial will show you how to use the Data Visualizer in Visio 2016 to create a process chart from an Excel spreadsheet.

The exercise file to follow along with this video can be found at:
#computertutoring

00:00 Introduction
00:30 Check Visio version
01:30 Take a look at Excel process map, flow chart templates
02:20 Open Visio
02:50 Explanation of process steps in Excel
04:53 Basic flowchart data visualiser
07:55 Edit process steps in Excel
09:30 Update flow chart in Visio

😊 Check out my website and social media to keep up to date - enjoy learning 😊

[libbysworld]

This video needs more views. it was so very helpful to me today! THANK YOU!!!

[CrampingFingers]

This was great! thanks... But have you created the Data Visualizer using Swimlanes video?

[AjayMathur]

How to have multiple next steps from a process? i.e. a process has three or four connections coming out of it?

[crazyrocket.]

I read on the page of Microsoft, that you need a subscription for Office365. Is it true? Did they change it? It is about Visio Plan 2 to use the function of Data Visualizer. Maybe Visio Online Plan 2 different to Vision Plan2. Hope you can help me.

Many thanks.

[zegers]

Professor. Do you know if the flowchart from excel wizard allows for BPMN as a valid stencil?

[rorycanavan]

PS: Can this work the other way? I map in ARIS, and have 37 detailed drawings that would benefit from being in traditional BPMN - a table creation in Excel, and re-import into Visio would save me a bucket-load of time.

[priyaramakrishnan]

Hi....Can you please provide the link to download the trial version of visio online plan 2...Thanks !!!

[tomavril]

Hi guys I'm using Visio Pro 2019 and I'm trying to export a data base from excel to Visio in order to create processes. I watched the video and tried to do the same on the 2019 version but the shapes aren't automatically linked like in this video. Any ideas ? Thanks for the help :)

[andysusilo]

Where is the process owner in the Visio diagram ?

[McLuthian]

You need to change the title because data visualizer only works in Visio online, not in Visio 2016 or 2019. This makes me embarrassing.

[rorycanavan]

Very useful :) although my spelling OCD kicked in at the end - subscribe, not subsribe ;)