Export multiple URL links

Question

I would like to know if there's functionality to export the URL's for multiple documents uploaded to OneDrive for Business, instead of the alternative of selecting each individual file and then selecting the copy link for pasting into external applications?

My example has data served from a spatial SQL server database, whereby I would have point symbols overlain on aerial imagery. Clicking on the points provides me with an opportunity to access pre-prepared documents with the hyperlinks embedded in the SQL server database. Currently I have uploaded 35 documents, with a potential capacity of 245 for each of these 35 points. Obviously the individual copying of links would become a tedious exercise.

So, looking for a tool that would automate production of links, or do I abandon the idea and retain the current method of storage on local servers and miss out on the opportunity to access the wonderful world of cloud storage?

Cheers,

Joe

Answer 1

Hi Joe,

Have you referred to the above suggestion? Can you share any update?

Regards,

Jiaxing Bian

Answer 2

I need to do something similar to Joe; however, I'm unable to follow your instructions.

I clicked "Return to classic OneDrive" but there is no ribbon at the top of the page, so Export to Excel is not available.  Please advise.

Answer 3

Hi Joe,

To export the URLs of your documents in OneDrive for Business, you can use the Export to Excel feature. Here is the article for your reference:

Using SharePoint 2013 with Excel and Access

Note: The article also applies to SharePoint Online and OneDrive for Business.

To have that feature, please switch to the classic view by clicking Return to classic OneDrive on the lower left corner, then click LIBRARY on the ribbon and Export to Excel.

Update: The ribbon can be turned on by clicking the gear icon on the top right corner, and then choose On for Ribbon.

Regards,

Jiaxing Bian

Answer 4

Hi Jianxing,

I'm sorry I didn't back to you earlier, production pressures pushed my efforts at resolution to the back-burner. I have successfully replicated your recommendations. I belive in effect you have answered my question. The true realization of this problem for myself is reconciling the View link that SharePoint gives you with the normal and sensible links that the Export to Excel method that you provide gives.

I have successfully opened the link in excel, but my real test would be another user on the network accessing my files, I will investigate the sharing and security settings.

Thanks for your help on the matter, I am a step closer to where I would like to be.

Cheers,

Joe

Answer 5

Hi Brian,

Sorry for my mistake.

The ribbon is  turned off by default, and we can turn it on by clicking the gear icon on the top right corner, and then choose On for Ribbon.

Regards,

Jiaxing Bian