Forum Discussion
Solved
Importing Hyperlinks from an excel spreadsheet
hello, I have been scouring and have tried everything I have found so far with no luck (add an app - import spreadsheet etc etc) I have an excel spreadsheet that contains url hyperlinks and displ...
Mindbender I figured out something that will work. I created a list, renamed the Title column to Display Text, added a column type of Hyperlink named URL. I then went into Quick Edit and was able to copy my data from excel and paste it into the list template in Quick Edit by highlighting both columns and hitting Ctrl+v. I then added this list as an app part to a page.
Hi,
I found an easier way to do this.
- Create a column next to the link you imported from Excel
- This column should be a Hyperlink
- Click on Edit in grid view (Beside New button)
- Click and drag to the right the cell
- You can also select 100 cells at the time and drag them to the right
You should see something like this:
Hope this helps