How to import excel table to SharePoint List with hyperlinks?

Question

I got a excel file with hyperlinks, when i import to SharePoint list, the hyperlinks change to text only. I tried to change the column type from text to hyperlink, it's not possible to find type hyperlink. BTW, I also tried to create a new column with type hyperlink after import excel file to list. Can i copy the text column to new hyperlink column? How to copy & paste column? I can't find the feature.

Answer 1

Hi @JIANG, DAN ,

Great to know that and thanks for sharing the update here.

By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

[How to import excel table to SharePoint List with hyperlinks?]

Issue Symptom:
I got a excel file with hyperlinks, when i import to SharePoint list, the hyperlinks change to text only. I tried to change the column type from text to hyperlink, it's not possible to find type hyperlink. BTW, I also tried to create a new column with type hyperlink after import excel file to list. Can i copy the text column to new hyperlink column? How to copy & paste column? I can't find the feature.

Current status:
It's ok to add a new blank column set as hyperlink, copy URL in Text Column to this Hyperlink Column. Copy & Paste can be edit in grid view. If you find better solution, please let me know.

You got the excel file through the link, right? So, if you want to store this link in the SharePoint library, according to my test, there are two ways:

1. You can directly create a hyperlink column and paste the link into it.
2. You can create a file as a link by follow steps:

Click New> Link.

Paste the link in, enter the file name, and click Create.

And the result just like this:

You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community member's to see the useful information when reading this thread. Thanks for your understanding!