Adding URL linked items in a Microsoft List

Question

I created a Microsoft List by importing from an Excel table. The import didn't bring in the url links attached to items in one of the columns - it converted all the unique URL links to the URL link for the list itself. What can I do on import to fix this? And, when adding new items to an existing list, how do I embed URLl links within cell text (as I am able to do in Excel)?

Answer 1

Hi NCBardeau,

As per your description, I go through your post carefully, yes when we import data (include URL) from Excel to SharePoint online list by default its import text instead of hyperlink in SharePoint online list.  

Here I find a solution for you, please follow my below steps.

1.First in Excel file in URL cell/column you need to add” https:// “before in your url address.

![Image](https://learn-attachment.microsoft.com/api/attachments/e428a821-16fd-4049-b4c3-6a8bdd335734?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/b32292a8-1385-4ca5-b60c-23da498efdd0?platform=QnA" rel="ugc nofollow">![Image](https://learn-attachment.microsoft.com/api/attachments/b32292a8-1385-4ca5-b60c-23da498efdd0?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/7468acab-6a61-4a33-8097-e49cceeab5cc?platform=QnA" rel="ugc nofollow">

5. Click on Advanced mode copy the below JSON code and pate into column.

{

  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

  "elmType": "a",

  "attributes": {

    "href": "@currentField",

    "target": "_blank"

  },

  "txtContent": "[$url]"

}

 ![Image](https://learn-attachment.microsoft.com/api/attachments/e5d9496e-469e-4084-845b-786db04dbf3a?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/4ad2b761-586f-4479-8977-3b9643cc554a?platform=QnA" rel="ugc nofollow">![Image](https://learn-attachment.microsoft.com/api/attachments/4ad2b761-586f-4479-8977-3b9643cc554a?platform=QnA

Answer 2

Hi NCBardeau,

Please feel free to post back if you need further assistance. 

Best Regards,

Waqas Muhammad