Importing Excel Spreadsheet with Hyperlinked text

Question

_{Tuesday, November 20, 2018 2:40 PM}

I have an Excel spreadsheet with a column that has hyperlinked text. When I import that spreadsheet into SharePoint using the "Import Spreadsheet" App, the hyperlinked text is not maintained and the column only shows the non-clickable URL. Please advise as to how to import the spreadsheet into SharePoint so that the Hyperlinks are imported properly. Thanks!

All replies (6)

_{Wednesday, November 21, 2018 5:29 AM}

Hi

You can create a hyperlink column after import. And switch quick edit view to copy&paste the hyperlinks.

Justin Liu Office Servers and Services MVP, MCSE
Senior Software Engineer
Please Vote and Mark as Answer if it helps you.

_{Thursday, November 22, 2018 2:56 AM}

Hi Sal Bawany,

Per my test, it works fine on my environment.

This is my way to import the spreadsheet, hope it will help you.

1.Create an excel spreadsheet with hyperlink like this:

2.Create Import Spreadsheet List.

3.Type the name and choose the file then import.

4.The hyperlinks show correctly in the list.

Besides, as a workaround, you could create a hyperlink column in the list. Then copy the hyperlink text to sharepoint list in datasheet view.

Best Regards,

Michael Han

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

_{Tuesday, November 27, 2018 5:09 AM}

Michael - thanks for your reply. I just realized that I posted my question in the SP 2010 forum whereas the version I am working on is SharePoint Online. The steps you have provided would work find in 2010 however they don't work in as well in SharePoint Online. Would you happen to have any solutions for SharePoint Online?

_{Tuesday, November 27, 2018 8:24 AM}

Hi Sal Bawany,

Per my test, it also works fine in SharePoint Online.

1. Create Import Spreadsheet List in SharePoint Online.

2.Type the list name and choose the file, then import.

3. The Hyperlinks are imported properly.

Best Regards,

Michael Han

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

_{Friday, December 7, 2018 10:26 AM}

Hi Sal Bawany,

Is there anything to update?

Please remember to mark the reply as an answer if it helps.

Have a nice day!

Best Regards,

Michael Han

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

_{Tuesday, October 15, 2019 1:22 PM}

hi Michael, that works in SHO, but can you import 2 columns that are hyperlink? I can see on the one that does show a Hyperlink, that the setting for the column is Hyperlinked. but the column that has hyperlink text in is showing in settings as Text.

Just wondered on a side note if there was something  preventing you from importing from Excel 2 columns containing Hyperlinks.

Kindest regards

Kieron