Can you import Excel file with the file extension *.xlsm

HelenOBrien · January 2016

I have Excel file which are macro driven so their extension is *.xlsm for some reason it would not import into DOMO I had to save the data a *.xlsx

kshah008 · January 2016

Hi all,

Can anybody help @HelenOBrien with their question?

Thanks!

quinnj · January 2016

Hey @HelenOBrien,

Not sure why you'd be having trouble uploading an *.xlsm file through Workbench since it supports that kind of file. Is there anything special/unique about the file or its formatting? If you'd feel comfortable, you could private message me a copy of the file and that may help me figure out what's going wrong.

HelenOBrien · January 2016

I was not using Workbench, as I do not have rights or do not have it installed, will check this out with the DBA.

When I was creating a new chart I was importing the Excel file *.xlsm and this is where I was having the problem.

thanks

quinnj · January 2016

Ah, I see. I assumed this was Workbench related since you posted in the "Workbench" forum here. Yes, when you go to create a card and add the datasource that way, it is using the Domo Excel Connector, which currently doesn't support .xlsm.

You can download Workbench from within Domo by going to your Domo instance, then in the top right arrow, selecting "Admin", then "Tool Downloads" from the left-hand pane. Once downloaded, you will need admin access to be able to install (you may need to get the right authorization here), but once installed, you can then connect to your Domo instance and push up an .xlsm file.