Please check the section Manually Creating an Import Template of this guide. It describes a similar scenario of setting an association. You need to specify the association in import template
https://docs.mendix.com/howto/integration/importing-excel-documents