How do I get Domo to automatically pull in Excel data?

sophiecs

I have data in several Excel spreadsheets, which are updated every day. How do I get Domo to automatically pull in this data? At the moment I can only see how to manually update (with the option to be prompted every day to update). Given there are several sheets, all of which feed into dataflows which run first thing in the morning, it's not practical for us to manually update.

 

Any solutions/workarounds would be much appreciated!

RGranada

I think if you need to schedule an excel or CSV  file upload and the file is on premises you should use workbench tool to do it.

 

It 's pretty straight forward to use i think. You can download it at the Tool Downloads on the Admin Settings page.

 

Here's a good link on workbench:

 

http://knowledge.domo.com?cid=workbench4

 

Don't hesitate to ask if you need help setting this up.

 

Hope this Helps.

RGranada

Hi,

 

What connector are you using to upload the excel files?

 

Regards,

sophiecs

Just the Excel connector, but happy to try others (for instance, a .csv would be fine)

RGranada

I think if you need to schedule an excel or CSV  file upload and the file is on premises you should use workbench tool to do it.

 

It 's pretty straight forward to use i think. You can download it at the Tool Downloads on the Admin Settings page.

 

Here's a good link on workbench:

 

http://knowledge.domo.com?cid=workbench4

 

Don't hesitate to ask if you need help setting this up.

 

Hope this Helps.

sophiecs

Thank you, this is exactly what I was looking for.