Share via

Export multiple URL links

Anonymous
2016-02-29T17:50:45+00:00

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

Microsoft 365 and Office
Microsoft 365 and Office

A comprehensive suite of productivity tools and cloud services that enhance collaboration, communication, and efficiency. Combining classic Office apps with advanced Microsoft 365 features, it supports both personal and business needs

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2016-03-05T04:10:48+00:00

Hi Joe,

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

Regards,

Jiaxing Bian

Was this answer helpful?

0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-03-05T02:33:13+00:00

    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.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2016-03-01T03:32:58+00:00

    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

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2016-03-05T06:43:50+00:00

    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

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-03-05T02:53:28+00:00

    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

    Was this answer helpful?

    0 comments