Hi Con,

I don't think you cna import think format fo excel as outsystems record to excel widget treats columns of first row as your structure attributes (or do a mapping based on them). But in your case structure is not what this widget is expacting.

I have not used it but there is a component on forge which you can try if this provides custom excel import feature

https://www.outsystems.com/forge/component-overview/355/advanced-excel

Please, check this documents, with special attention to the first two.

• Bootstrap an Entity Using an Excel File
• How to update a Bootstrap Action to fetch an entity identifier from Excel

• How to customize the export to Excel (another scenario)

• How to implement excel to record list (post)
• Excel to record list (document)
• Updating database with excel to record list (post)
• Excel to Record List (component)

I hope this helps you,

Nuno