Hi @1036910, a flat (.txt) file is definitely preferred. If you wan to use Excel a source file, check out Using Excel Trial Balance Files to Import Data in the FDMEE admin guide. You can download the Excel trial balance template via the FDMEE user interface.
The problem with this approach is, it ignores the import scripts used in the import format.
Is it possible to use import scripts with template upload?
Hi @1036910, you're correct. If you use a template upload it bypasses the import format and thus any associated import scripts. I imagine the Excel template is the only method for Excel data as the template uses metadata tags and ranges to clearly define column tags and the rows of data to upload, respectively. Maybe save the Excel file content to CSV and then upload.
You cannot use import scripts with the template load approach. Any transformation you require would either need to e done in an event script or moved to the mappings.