I had already seen this Video. But this is not the solution. This is importing all the excel sheets and then removing and renaming the ids and create the relations manual.

I like to have an automated solution for importing multiple excel sheets with related data and transfer them to entities with relations. Outsystems can see the relations by the naming of the column headers.

if you want to use the excel files only to do a "temporary transfer", only disregard the id created by Studio because you already have the id in the fields that will refer to the tables that will receive the data.

Try to avoid names that have pattern behavior. Every name that finishes with Id will be an identifier. The same for boolean that begins with Is or Enable.

you need to understand how OS works. Every table will have an Id and it is auto number by default. Every time you import an excel file a new number will be generated. So, you will not get to implement your logic because every row from excel will always have a new key.

If OS detects the id in your spreadsheet it will rename your field name and add the id with auto number because this is the pattern inside OS.