Exporting SharePoint document/file/item URLs can be quite tiresome if you have multiple sites and if each has multiple libraries/lists. Hence, I am writing this post to help you find the right process for you. In this post I have shared 3 methods which you can use to export all the file/item URLs from any SharePoint site.
#. Knowledge Check
In this post I have shared 3 methods to export the URLs. More specifically,
1. without any tool,
2. using Power Automate and
3. with help of PowerShell
So if you have understanding of PowerShell and/or Power Automate, then it will be easier for you to follow along. However, if you are new to them, do not worry as this tutorial is fairly simple and I have explained them in detail.
#1. Without Any Tool
Okay, let us start from the basic one, that is, without any tools or programming languages. This method is good if you want to export one or two libraries or lists. However if you have multiple libraries and list then I will not prefer this approach as it requires a lot of manual work.
Note. If your document library/list has more than 5000 items then you need to do this step multiple time. Because SharePoint has list view limit set to 5000 items.
The only con of using this approach is that, if you have multiple libraries then this is not an efficient process.
Very simple and easy
Okay, so before we can begin, we need to open the SharePoint document library/list and create a view without any folders. If your library or list does not have any folder then feel free to skip this step and proceed to the next one.
Navigate to the Document Library Settings and Create a new view
Next, scroll down to the bottom and click create view
Choose option standard view
Give it a name, choose public(available to everyone) or private(only available to you) and set the folders and item limits as below. Save it to finish creating the view.
Now navigate back to the SharePoint and choose the correct view. Then select Export to Excel as shown below.
That’s it you have the details of the items directly in excel. If you need additional information, try adding other columns in the view and export again.
Let’s move forward to the second method.
#2. Using Power Automate
Power Automate is a powerful tool. It can automate repetitive tasks such as sending emails, updating entries, deleting files etc. However, here we are using Power Automate to export the file URLs
Automated solution. Once setup no manual intervention required
Little complex to setup and requires knowledge of Power Automate
As the tutorial is fairly big, I have created a separate post for it. Please check it using the below link
#3. PowerShell comes to rescue
As always PowerShell has answers to all requirements of SharePoint or O365 applications. This is true for this requirement as well. There are already many tutorials available using PowerShell and hence I am not writing it again. Below are some of the documents which I found useful. However, if you have any questions, feel free to ask in comments
Well That’s all I have for exporting SharePoint file URL’s. I hope you found this tutorial helpful, however if you have any questions, feel free to ask in comments
Please Help us Grow!
I hope you have found this article helpful. If you are happy with the document, please use the below links when you buy something from Amazon to help us grow.
How this works?
Amazon affiliate program gives a small (%)share of price to the referrers, so feel free to buy anything.
Below are some Amazon affiliate links, if you open amazon application/website using these links and buy something, (it can be one of the below items or anything of your choice) Then Amazon will give us a little percentage(%) of the money you spend on Amazon. To know more check this document.
Amazon Affiliate Links
More Ways to Help
For your Contribution
Ramiz is a professional working in an MNC as a business and technology consultant for quite a few years now. Ramiz is proficient in various Microsoft tools and technologies. He is a tech enthusiast and an active blogger. Ramiz spends his free time playing games or watching movies. He writes blogs to share his knowledge with the world and to make it a better place to live.