SOLVED
Home

Importing Hyperlinks from an excel spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-653291%22%20slang%3D%22en-US%22%3EImporting%20Hyperlinks%20from%20an%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-653291%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20scouring%20and%20have%20tried%20everything%20I%20have%20found%20so%20far%20with%20no%20luck%20(add%20an%20app%20-%20import%20spreadsheet%20etc%20etc)%20I%20have%20an%20excel%20spreadsheet%20that%20contains%20url%20hyperlinks%20and%20display%20names.%20I%20would%20like%20to%20import%20this%20list%2C%20displaying%20the%20display%20name%20but%20following%20the%20url%20when%20clicked.%20I%20cannot%20seem%20to%20get%20this%20to%20work%20at%20all%20on%20Office%20365.%20I%20really%20do%20not%20want%20to%20have%20to%20manually%20add%20these%20700%20urls%20and%20link%20them%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20advice%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-653291%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-658827%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Hyperlinks%20from%20an%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-658827%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F350309%22%20target%3D%22_blank%22%3E%40Mindbender%3C%2FA%3E%26nbsp%3BI%20figured%20out%20something%20that%20will%20work.%20I%20created%20a%20list%2C%20renamed%20the%20Title%20column%20to%20Display%20Text%2C%20added%20a%20column%20type%20of%20Hyperlink%20named%20URL.%20I%20then%20went%20into%20Quick%20Edit%20and%20was%20able%20to%20copy%20my%20data%20from%20excel%20and%20paste%20it%20into%20the%20list%20template%20in%20Quick%20Edit%20by%20highlighting%20both%20columns%20and%20hitting%20Ctrl%2Bv.%20I%20then%20added%20this%20list%20as%20an%20app%20part%20to%20a%20page.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Mindbender
New Contributor

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 display names. I would like to import this list, displaying the display name but following the url when clicked. I cannot seem to get this to work at all on Office 365. I really do not want to have to manually add these 700 urls and link them

Any advice?

1 Reply
Solution

@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.

Related Conversations
I can't find the right import language for csv files.
o0McArt0o in Excel on
4 Replies
How to export Office 365 mailbox to PST?
alainajodi in Office 365 on
6 Replies
Outlook Import Contacts - Outlook Customer Manager
Dave_Zwyssig in Office 365 on
1 Replies
parse two-level JSON data
Gregory Guthrie in Excel on
10 Replies
Decimal separator after CSV import
Luca Rivoira in Excel on
6 Replies