I definitely think this is possible, it’s just a matter of getting the configurations correct. If you haven’t already I’d recommend you take a look at this documentation on importing data from an excel sheet:
General Info: https://docs.mendix.com/howto/integration/importing-excel-documents
Automatically generating import template from excel file: https://docs.mendix.com/howto/integration/importing-excel-documents#7-automatically-creating-an-import-template-via-an-excel-file
First I’d recommend you prep your excel sheet how you want it, as you’ve described above, and then I’d recommend you perform the automatic template generation step using that prepared excel sheet. If you’ve already done these steps, you’d need to provide more in depth information on the exact errors/functionality you’re seeing so I can provide some additional help.
Also, something to look out for here, if it’s applicable for your project, is security if you haven’t double-checked that yet.