SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Thanks for moving this to a new question. :) For everyone else, Roshni references this question:… – Kit Menke Oct 14 '11 at 20:04
@Roshni Parikh, Try keeping a space between comma and text.... e.g., [URL to Navigate], [Text to display] – Sudheer Gupta Parimi Feb 11 at 17:51
up vote 1 down vote accepted

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:

  1. Create plain text columns in the list for URL and Description and a Hyperlink column for the final value
  2. Open SPD and create a new workflow on your list (on create or on update, up to you)
  3. Specify conditions if needed (like "if Hyperlink column is empty")
  4. Add a workflow action in SPD to Build Dynamic String
  5. Store [URL column],[Description column] in Variable:[Variable name]
  6. then Set [Hyperlink column] to Variable:[Variable name]
  7. Stop workflow

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.

share|improve this answer
Thanks SharePoint Eric, I will try this sometime today and will let you know how did it go. Really appreciate your time here. – Roshni Parikh Oct 20 '11 at 13:12
Hello Eric, Again, thank you for your time, but I think I followed your direction and still it didn't work out for me. Here is what I had. I created 3 columns. 1. Link, 2. Description and 3. Hyperlink. and was combining the Link and Description column using SPD workflow in a variable and add that variable to Hyperlink column. but it gave me http://[],[google] below value instead of giving me URL with Google word. Let me know if you have more ideas. – Roshni Parikh Oct 20 '11 at 15:02
At a glance I'd say that you typed the literal column names into the string builder in the variable instead of using workflow lookups. In step 5 above you'd build the dynamic string by clicking the Add Lookup button at the lower left corner of the string builder dialog, selecting the Link column from the list, then typing a comma, then clicking Add Lookup again and selecting the Description column. Does that sound right? – SharePointEric Oct 20 '11 at 18:26

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.

share|improve this answer

If you need to bulk enter 1400 exact same URLs into each of the records, you can enter the hyperlink as 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.

share|improve this answer
Yes, they are all unique values. so dragging down and applying it to every cell wont work. Thanks for your reply. Nintex workflow can't be solution for me as its a one kind of application I am working and I would not be able to get funding for this. can you elaborate more on Powershell or SPService. – Roshni Parikh Oct 17 '11 at 16:15
My reputation is not good enough to comment, but I can offer this: 5. Store [URL column],[Description column] in Variable:[Variable name] Please note that you MUST have a space after the comma for it to work: 5. Store [URL column], [Description column] in Variable:[Variable name] – Joe Void Apr 11 at 14:10

I found this solution:


  1. Copy and paste the links into Datasheet view (so they show up as http: etc etc)
  2. Copy and paste the text you want to show as the Description for the Hyperlink on top of the hyperlinks.

This will retain the links but show just the text.

share|improve this answer

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?

Not the answer you're looking for? Browse other questions tagged or ask your own question.