transfer data from excel to Visio

I need to know if there is a way to automate a process to transfer data from an excel spreadsheet to an organization chart in Visio.

Or

a way to validate the data that is on an excel spreadsheet matches what is on an organization chart and show any mistakes