I have around 1400 records that I would like to import in SharePoint list and entering each URL manually with description doesn't make much sense. Is there any way I can import these URLs in either data sheet view or Access Database synced with this list. I do know that I can use Content Editor web part if I enter these URLs with HTML tags but that would be little complicated as these list will be displayed on multiple pages and I would have to add Content Editor Web part on all the pages where I show this list.
I write hyperlink columns to lists all the time using a simple SharePoint designer workflow. Whether you run the workflow on create (if you're creating your list via the import) or on update is up to you; your post implies that the list already exists and that you're extending it with a hyperlink column but it should work either way.
The workflow process is simple:
The key is just that the hyperlink column consumes the URL and description as [URL],[Description]. You could probably work that out in Access as well, simply haven't tried.
Use a formula in Excel =Hyperlink(A1,B1) where A1 is the URL and B1 is the description. Then copy/paste to SharePoint Datasheet view.
This may work for SharePoint 2010 Datasheet view, but does not work for SharePoint 2013 Quick Edit.
If you need to bulk enter 1400 exact same URLs into each of the records, you can enter the hyperlink as http://www.yahoo.com. Then right click the cell, and click Hyperlink, Edit Hyperlink and put in the description. Then this can be dragged down and applied to every cell.
Access and Datasheet view act the same, which is no surprise since the datasheet view is Access.
If they are all unique it won't work. I have used a Nintex workflow in the past to build a dynamic string of url, description and then set the hyperlink field that way. There may be other options out there like Powershell or SPService (web services) to do bulk updates of unique values.
I found this solution: http://www.minasi.com/forum/topic.asp?TOPIC_ID=39895
This will retain the links but show just the text.
protected by Community♦ Apr 11 at 19:27
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?