Is there any way to connect or join an excel spreadsheet to a dataset that is already in Domo?

MDavis

Hi All!

I am new in Domo and I don’t have an IT background but I have gone through the Domo Certification Training (pending the tests). I am trying to get my excel spreadsheet to get updated every time the cards in a dashboard in Domo updates, I have tried to use Magic ETL to join my data but I have not been able to get an Output DataSet that would work for what I need since both datasets doesn’t have any matching columns or have the same data structure. 

I provided a screenshot as an example. Is it possible for the Forecast excel spreadsheet to update every time the numbers on the domo dashboard updates?

Thank you in advance and please excuse my lack of experience and knowledge.

DashboardDude

Hi @MDavis ,

Yes! You can use the Microsoft Plugin from Domo. Here's a video I made to show you how: https://www.loom.com/share/d042cc7f705a4489a57340da9ebf5ae0.

Good luck,

John Le

More videos at: https://www.dashboarddudes.com/pantry

DashboardDude

Hi @MDavis ,

Yes! You can use the Microsoft Plugin from Domo. Here's a video I made to show you how: https://www.loom.com/share/d042cc7f705a4489a57340da9ebf5ae0.

Good luck,

John Le

More videos at: https://www.dashboarddudes.com/pantry

MDavis

Thank you John, I appreciate your time in creating a video!