sharepoint-icon-x128

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.

Cons

The only con of using this approach is that, if you have multiple libraries then this is not an efficient process.

Pros

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

library settings in sharepoint online

Next, scroll down to the bottom and click create view

Create view from settings in SharePoint Online

Choose option standard view

standard view in SharePoint online

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.

folder filter in sharepoint online view

Now navigate back to the SharePoint and choose the correct view. Then select Export to Excel as shown below.

export to excel option in SharePoint

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

Pros

Automated solution. Once setup no manual intervention required

Cons

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

Retrieve All SharePoint Document URLs – New Signature

Get URL of All Files in SharePoint Online Document Library using PowerShell – SharePoint Diary

Office 365/SharePoint Online – PowerShell Script to Get and Export Site Pages ViewsLifeTimeUniqueUsers & ViewsLifeTime Details (c-sharpcorner.com)

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

$350-Best Student laptop
Amazon In, Amazon US

$600-Work laptop
Amazon In, Amazon US

$989– High performance
Amazon In, Amazon US

Headset – $15.99
Amazon In, Amazon US

Lightspeed Mouse – $39
Amazon In, Amazon US

Keyboard – $29
Amazon In, Amazon US

The Psychology of Money
Amazon In, Amazon

Atomic Habits:
Amazon In, Amazon

Find Balance and Purpose in Life
Amazon In, Amazon

$30, Smart Watch for Smart you
Amazon In, Amazon US, Amazon UK

Work comfortably with $110
Amazon In, Amazon US, Amazon UK

Exercise at home
Amazon In, Amazon US, Amazon UK

More Ways to Help

Thank you
For your Contribution


Newbietechie.com
Author @ramizmollahmd

About Ramiz

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.


Leave a Comment