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

sophiecs
sophiecs Member
in Connectors

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!

Best Answer

  • RGranada
    RGranada Contributor
    Answer ✓

    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.

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.

Answers

  • RGranada
    RGranada Contributor

    Hi,

     

    What connector are you using to upload the excel files?

     

    Regards,

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • sophiecs
    sophiecs Member

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

  • RGranada
    RGranada Contributor
    Answer ✓

    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.

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • sophiecs
    sophiecs Member

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

Categories