0

I have a Spreadsheet with columns as below

enter image description here

Scenario

I am trying to import this spreadsheet to create a SharePoint list using the import spreadsheet app which duplicates the columns and data of existing spreadsheet. As you know Hyperlink is not supported in this its importing the Column as plain text. Is there any other method to import this data as the spreadsheet has 3500 records.

enter image description here Final output should be something like this

enter image description here

1 Answer 1

0

Create SharePoint list items from Excel rows

Please the following steps:

  1. Upload the .excel file to the SharePoint Document Library

enter image description here

  1. Creat a new list

enter image description here

  1. Create a MS Flow

enter image description here

  1. Save and Test this Flow

enter image description here

3
  • Hello @EchoDu_MSFT Sorry i might not be specific with my requirement and Hyperlink column is type of column and it has alternative text in one column as tag station and url is the link that should go in to Site URL and i have my list already created with Stations sites and url now the task is to move the content from sites to alternative text and url to site url as shown in the figure
    – AIM4DREAM
    Mar 3, 2021 at 19:29
  • I can move the content directly from spread sheet to a list but hyperlink column has two variables like Site url and alternative text
    – AIM4DREAM
    Mar 3, 2021 at 19:37
  • Hi, AIM4DREAM. It is not yet possible to realize your design, you can only manually add alternate text for each hyperlink. If there is any better solution later, I will share with you as soon as possible. Have a nice day! Mar 4, 2021 at 7:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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