Excel to Dataverse migration and lookup value
Assuming that your primary columns are text columns, always have unique values, you should be able to use a model driven app to first export a template, copy and paste the data from your original excel document, then reimport the data using the value of the primary key of the target table, and in the background the Model Driven App would create the connection.
If you are still having trouble, you have the option to create an Alternate Key in your Dataverse table, as long as this is a text column that contains strictly unique values
Let me know if this helps!.
