We have Excel Workbooks with multiple sheets of data to import using DMT. Is there a way to specify what sheet is to be imported or will it only import the first sheet in the file?
Thanks.
TBH I didn’t know you could use Excel (.xlsx) files for DMT, I thought it only took CSV files, which are single-sheets.
I use xlsx files all the time, but only the first sheet is used as far as I can tell.
4 Likes
I would agree with Mark that as long as what you need is on the first sheet, you should be good.
DMT is a finicky beast though. Some imports will not take an XLSX or even an XLS And do require a CSV. Most will work fine though.
I have had on rare occasions where data on other tabs does seem to confuse DMT and I’ve had to remove them. This has been a while though and might no longer be an issue.
4 Likes
I 100% agree with @Mark_Wonsil and @Chad_Smith. Only sheet1 if I recall.
If creating a templet from DMT and you output to XLSX then you get the field descriptions as well. 
Back in the bad old days, excel was a bit flaky for importing and easy to introduce spaces to data without noticing it.
It is way more stable theses days.
If you want to keep using the multi-tab spreadsheets, then there are a few ways to skin that cat.
- Use a tool like SSIS to create a workflow to get the data from the different sheets.
- Use a Macro in the spreadsheet to generate the csv files.
- A python script would be another way.
- Or even Power Automate.
Remember you can run the DMT from the command line also.
And on the topic of DMT and importing data, don’t forget the ability to use updatable dashboards or the paste insert capabilities to load up lists of data.
Not fully knowing your need for using DMT, but there may be a simpler more use friendly way than giving people access to DMT (frankly I find it a bit of blunt instrument, and if in the wrong hands can royally mess things up.)