Import/Paste data from Excel to Smartsheet



I need to import or copy paste data from my excel into Smartsheet. Some of the columns have names in them, but when I paste them into Snartsheet they do not convert into a contact even though the column property is set to be Contact Type.

I have seen other suggestions to save them as email address in order for it to be converted into a contact type.

Unfortunately, the data source does not have an email address and I cannot save email address in a helper sheet as the contacts are not limited to a few, it is open to anyone in the organization.

Is there a work around for this as I need to set up notification workflows which is currently not possible due to this limitation.