Excel import - web link

Shotgun
#1

How do I import an external web page link into an asset as a column and have it come in as a clickable link?
Importing from a CSV

Cheers