How to add a relationship properties column in a xlsx file.

Question

I am able to create a digital twin using the sample xlsx file shared on GitHub repository of ADT as shown in below snapshot.

In above image the twin properties are added by column 'init data'. But in my case the relationship also have their own properties associated with them.
So how can I include the relationship properties in the xlsx ?
What will be the name of the column for the relationship properties needed to be specified in xlsx ?
It will be helpful if you can share a xlsx having the multiple nodes and relationship where the relationship properties added in them.

Answer 1

Duplicate on StackOverflow

Currently, the Azure Digital Twins explorer doesn't support uploading relationships with properties through Excel or JSON files. The Excel plugin currently only looks at the columns that are defined in the file. This means that if you absolutely must use an Excel file to import your twin, you would need to build this functionality yourself.

There is also an open issue that describes relationship properties not being shown in ADT Explorer, so there doesn't seem to be support for it. You could use the API to create these relationships.