Grab URL from Document Library link

%3CLINGO-SUB%20id%3D%22lingo-sub-1513489%22%20slang%3D%22en-US%22%3EGrab%20URL%20from%20Document%20Library%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1513489%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20document%20library%20containing%20links%20out%20to%20videos%20on%20our%20YouTube%20channel.%20I%20have%20run%20a%20query%20on%20the%20Sharepoint%20list%20so%20I%20can%20see%20those%20entries%20in%20Excel.%20I%20have%20also%20downloaded%20a%20CSV%20of%20all%20our%20channel%20videos%20on%20YouTube.%20The%20YouTube%20CSV%20contains%20a%20column%20containing%20just%20the%20Video%20IDs%20(e.g.%20'dQw4w9WgXcQ').%20I%20would%20like%20to%20use%20the%20Video%20ID%20as%20the%20key%20to%20join%20the%20two%20tables.%20However%2C%20the%20Links%20in%20the%20SharePoint%20library%20display%20as%20.url%20files%2C%20with%20the%20real%20destination%20(which%20contains%20the%20Video%20ID)%20being%20obfuscated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESO%2C%20short%20version%3A%20is%20there%20a%20way%20to%20display%20the%20destination%20URL%20of%20a%20Sharepoint%20Link%20in%20a%20Document%20Library%2C%20short%20of%20manually%20following%20it%3F%20Or%20of%20converting%20a%20.url%20link%20into%20an%20actual%20URL%20in%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1513489%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi everyone,

 

We have a document library containing links out to videos on our YouTube channel. I have run a query on the Sharepoint list so I can see those entries in Excel. I have also downloaded a CSV of all our channel videos on YouTube. The YouTube CSV contains a column containing just the Video IDs (e.g. 'dQw4w9WgXcQ'). I would like to use the Video ID as the key to join the two tables. However, the Links in the SharePoint library display as .url files, with the real destination (which contains the Video ID) being obfuscated.

 

SO, short version: is there a way to display the destination URL of a Sharepoint Link in a Document Library, short of manually following it? Or of converting a .url link into an actual URL in Excel?

 

0 Replies